Teodord - Please help!!!

[yaramada123]

Hi,

I am trying to export a 16 digit number into XLS, but it is getting exported as exponential number.

 

1. I used JXL api to open the sheet and edit the number so that it is displayed as normal number.

 

2. The problem I am facing is, If I am exporting 5000323421232345, the last digit is getting replaced with 0 instead of 5 as it is getting converted to exponential number 5.0000E+15 when Jasper exports it into XLS.

 

How do I get around this problem, I can turn of IS_AUTO_CELL_DETECT_TYPE as there are numbers in other columns. Please let me know if any one knows a solution for this.

[arunvishvin]

Hi,

I also faced the same problem what i did was,

 

We used to print 16 digit numbers as TxnNo:1234567890123456 and I added the ":" into the report before the field value like this

":"+$F{Field Name} and that solved the problem.

You also try to add some character but not space before your field value, it will surely work

[lucianc]

According to Microsoft KB, the numerical precision in Excel 2000 is 15 digits. Therefore you will never be able to include a 16 digit number in a worksheet without losing the last digit.

 

If you want to include the number as text, you should set the JRXlsAbstractExporterParameter.IS_DETECT_CELL_TYPE export flag (which would deactivate IS_AUTO_DETECT_CELL_TYPE) and make sure your text has java.lang.String as type.

 

While IS_AUTO_DETECT_CELL_TYPE guesses the cell type based on the cell text, IS_DETECT_CELL_TYPE uses the type of the text field expression to determine the cell type. Note, therefore, that if you have a java.lang.String text field which was interpreted by IS_AUTO_DETECT_CELL_TYPE as a number, this would not happen with IS_DETECT_CELL_TYPE.

 

HTH,

Lucian

[szaharia]

If you want to avoid both exponential conversion and text representation of your big number, there is another possibility: try to use the java.math.BigDecimal (or BigInteger - your number appears to be rather integer) type instead of Double. But, of course, try that only if your precision does fit into Excel's allowed limits, as Lucian said.

Post edited by: shertage, at: 2007/07/24 09:04

[yaramada123]

Thank you very much for the replies!!! using IS_DETECT_CELL_TYPE solved my issue, I was using IS_AUTO_DETECT_CELL_TYPE earlier which was messing up my excel output.