On Wed, 28 Jul 2010, Matt Rogghe wrote:
In the below scientific notation case the number is stored in raw form
exactly as I would want it to be outputted. Issue being the
org.apache.poi.ss.usermodel.DataFormatter in the example code uses the
discovered format index/string (in my particular case "0.00E+00") for
output. I lose precision and may have trouble parsing that elsewhere.
Is DataFormatter outputting the value in the same format that it shows up
in Excel with? If not, could you please open a new bug in bugzilla, and
upload a file with say 3 cells:
(problem number, as a number)
(the format applied, as a string)
(what it looks like in excel, as a string)
eg
1.23456
'#.#####
'1.23456
We can use that for a unit test, and hopefully a fix. In general though,
DataFormatter (certainly in 3.7) should fairly faithfully reproduce a
decent range of excel formatting. However, as you've now seen, what Excel
shows and what Excel stores in the file can be rather different...
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
