[Libreoffice-bugs] [Bug 118177] Truncating 8*27/27 equals 7 on FILEOPEN if a cell is formatted other than General

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com
            Version|6.0.3.2 release             |4.0 all versions
     Ever confirmed|0                           |1
            Summary|Truncating 8*27/27 equals 7 |Truncating 8*27/27 equals 7
                   |on FILEOPEN if a cell is    |on FILEOPEN if a cell is
                   |formatted as fraction       |formatted other than
                   |                            |General
             Status|UNCONFIRMED                 |NEW

--- Comment #3 from Eike Rathke <erack at redhat.com> ---
This is independent of the fraction format, it happens with any numeric format
other than General (due to when loading in some circumstances formulas
formatted as General have to be recalculated). The actual cause is that =8/27
isn't exactly representable as decimal number and is stored as
0.296296296296296 which when loading the file is assigned as the formula cell's
result until recalculated (which in this case it isn't if not forced, pressing
F9 on cell F3 also does it). The same behaviour can be seen if the value
0.296296296296296 is pasted to cell F3, then also with a recalculation the
result in cell C3 is 7.

I have no quick idea how this effect could be circumvented other than
recalculating everything.

-- 
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/20180615/99e22a62/attachment.html>