https://bugs.documentfoundation.org/show_bug.cgi?id=133919
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|[email protected] |[email protected] |desktop.org | --- Comment #13 from [email protected] --- Created attachment 176154 --> https://bugs.documentfoundation.org/attachment.cgi?id=176154&action=edit Exported from Google Calendar - Rounding Issue The attached shows a rounding issue in column E, which is the difference between columns D and C (dates/times). For example, opening the file in Calc I see 00:59 instead of 01:00 and 01:44 instead of 01:45 If I open the same file in MS Excel, the correct values are shown. ------------------------------------------------------------------------------- The file is a subset of the main file, which itself shows mostly correct values [in column E] in Calc, so I include only the incorrect values. I have a work-around that seems to work. The work around is to change the cells in column E: - from: =(D2-C2) - to: =(D2-C2)+0.00001 ...but I would rather not do this for obvious reasons. Thank you -- You are receiving this mail because: You are the assignee for the bug.
