Jump to content
Changes to the Jaspersoft community edition download ×

big numbers in XLS

Recommended Posts

By: BGD - bgd81

big numbers in XLS

2006-04-19 01:56

I need to export a report in XLS format, and some values are numeric (they are some kind of ids) and i need to see them as they are, but excel is converting them to an equivalent form. Example: id number 563546235645 is displayed as 5,63546E+11.


I tried to set/unset the IS_AUTO_DETECT_CELL_TYPE attribute but it has no effect whatsoever.

Apparently this problem can be solved by setting the cell format to Text (by default, all cells are in General format). How can i force the exporter to format all cells as Text ? Is there any other solution ? 10x





By: jasperkan - jasperkannan

RE: big numbers in XLS

2006-04-20 07:41

IS_AUTO_DETECT_CELL_TYPE is false , then all fields will be considered as text .

we faced issues with decimals since teh logic of checkingfor numbers is trivial in the JRXlsExporter . WE override export method in our custom implementation . u can also do that using

Jakartha POI APIs .

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...