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

--- Comment #5 from b. <[email protected]> ---
hello @ Nicole, 

thanks for checking,  
'Precision as shown' is off here,  
issue is quite easy, entering 0.999999999999999 in a cell without the '4' and
that cell times 6 in another cell produces 5.99999999999999. 
Calc stores the original input of 0.9999999999999994 in the file without the 4
( inspect the content.xml inside the ods file, and stores '6' as text for the
result cell.  
If new calculating with the stored 0.999999999999999 it will produce
5.99999999999999, _assume_ you have some setting like 'recalc on load' off?  
Pls. check and / or pls. try recalc with F9, ctrl-shift-F9 or similar.  
If you still cant repro it could be suspected your system stores more digits,
pls. try to check with an unzipper and xml viewer. 

:-)

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to