Summary: | [PATCH] Floating point rounding problems with ROUNDDOWN function | ||
---|---|---|---|
Product: | POI | Reporter: | Cédric Walter <cedric.walter> |
Component: | SS Common | Assignee: | POI Developers List <dev> |
Status: | RESOLVED FIXED | ||
Severity: | normal | Keywords: | PatchAvailable |
Priority: | P2 | ||
Version: | 3.11-dev | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Linux | ||
Attachments: |
Patch.txt
test-data/spreadsheet/FormulaEvalTestData.xls |
Description
Cédric Walter
2014-07-18 14:32:40 UTC
Created attachment 31829 [details]
Patch.txt
Created attachment 31830 [details]
test-data/spreadsheet/FormulaEvalTestData.xls
Integration test
this patch break the ROUNDDOWN method in "some" cases and should not be merged! Patch require further analysis BTW the rounddup function also do not behave in POI like in excel and will hopefully be solved soon. There were some changes to the methods in the meantime, so I think this is mostly fixed now, if not, then please reopen this bug with updated information. The latest fix was applied via r1801798: github #43: fix roundUp and roundDown. Thanks to @FishMeat on github for the patch. |