https://issues.apache.org/bugzilla/show_bug.cgi?id=56269
Bug ID: 56269
Summary: DateFormat - Rounding of fractionals
Product: POI
Version: 3.11-dev
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSLF
Assignee: [email protected]
Reporter: [email protected]
Created attachment 31391
--> https://issues.apache.org/bugzilla/attachment.cgi?id=31391&action=edit
different fractional rounding before save/load in Libre Office
In our project we discovered some rounding problem with date fractions.
We've got some data from a database tool (TOAD) which minimal calculated
fractions differently, but the result when opening the file was ok.
But the DateUtil class uses the real milliseconds and therefore output
03.01.2014 10:59:59 instead of 11:00:00 (fraction was 41642.45833321759)
After playing around with the fractions, it seems that at least Libre Office
will round at 500 millisecs.
Actually when recalculate the second date in the example file, it will be saved
as 10:59:59, but when reopening it will be 11:00:00.
MS Excel Viewer can't be forced to recalc via [1] and I haven't check with
project laptops Excel version ...
Should this rounding be taken into account in the DateUtil class?
[1]
http://apache-poi.1045710.n5.nabble.com/How-to-force-Excel-to-recalculate-on-opening-xlsx-td3249595.html
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
