[Libreoffice-bugs] [Bug 37923] Improve Calc precision when subtracting large integers to parity with Excel

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=37923

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|WORKSFORME                  |---
             Status|CLOSED                      |REOPENED

--- Comment #19 from b. <newbie-02 at gmx.de> ---
'=806515533049393 +x -806515533049393' with sheet cells or formula with
distinct values: 

Excel 2010:       x=0,00 .. 0,93 -> 0, 
                  x=0,94 .. ...  -> values with 0,125 precision, 

calc 7.2.0.0.a0+: x=0,00 .. 0,93 -> 0, 
                  x=0,94 .. 1,06 -> 1, 
            ***   x=1,07 .. 1,93 -> 0,   ***
                  x=1,94 .. 2,06 -> 2, 
            ***   x=2,07 .. 2,81 -> 0,   ***  
                  x=2,82 .. ...  -> values with 0,125 precision, 

besides excels precision is already weak, i'd not say calc is 'to parity' ...
reopening,

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210417/cb628f53/attachment-0001.htm>