poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives
Date Thu, 04 Feb 2016 17:43:56 GMT

--- Comment #13 from Javen O'Neal <onealj@apache.org> ---
> text.DecimalFormat("#.##########"))
>               2734111.4155508447

Looks like the DataFormatter is working as expected. The number of digits is
conaistenr with the format string.

We could add another 2 # characters to the format string, but someone would
need to prove that every version of Excel on all platforms use the longer
format string for any number or formula. I'm guessing that the default format
string was chosen to be the length it is for a good reason, and wasn't selected
at random.

Until then, if you need your code to return exactly the same value as Excel,
you'll need to specify a custom format string.

If you have usage questions, please use the POI Users mailing list [1].

[1] https://poi.apache.org/mailinglists.html

You are receiving this mail because:
You are the assignee for the bug.

To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message