You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2014/03/15 14:03:01 UTC

[Bug 56269] New: DateFormat - Rounding of fractionals

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

[Bug 56269] DateFormat - Rounding of fractionals

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56269

Andreas Beeker <an...@gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

--- Comment #2 from Andreas Beeker <an...@gmx.de> ---
applied with svn rev r1592419

-- 
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

[Bug 56269] DateFormat - Rounding of fractionals

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56269

--- Comment #1 from Andreas Beeker <an...@gmx.de> ---
Created attachment 31588
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=31588&action=edit
[PATCH] Round fractionals to seconds

The patch adds another formatting option to the DateUtil class, to get rounded
dates. I think, this should be the default, to have the date values rounded to
seconds, but for the sake of compatibility I left the behavior unchanged.

-- 
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

[Bug 56269] DateFormat - Rounding of fractionals

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56269

Andreas Beeker <an...@gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|XSLF                        |XSSF
                 OS|                            |All

-- 
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

[Bug 56269] DateFormat - Rounding of fractionals

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56269

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |54071

-- 
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