https://bugs.documentfoundation.org/show_bug.cgi?id=118177
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
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 <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
