poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 56269] New: DateFormat - Rounding of fractionals
Date Sat, 15 Mar 2014 13:03:01 GMT
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: dev@poi.apache.org
          Reporter: andreas.beeker@gmx.de

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message