https://bugs.documentfoundation.org/show_bug.cgi?id=140722
--- Comment #5 from b. <[email protected]> ---
Created attachment 171437
--> https://bugs.documentfoundation.org/attachment.cgi?id=171437&action=edit
another sheet with the same issue
found that it's not a complete hard recalc needed, but already a recalc of
cells E51:E53 with 'F9' triggers a correction of G51:G53 in
32183_testsheet_01_a.ods,
in the new attachement 140722_testsheet_02_ori.ods cell A9 is shown as
1970-01-01 T 00:25:00,99999 after load, even when corrected to 1970-01-01 T
00:25:01,00000 by 'F9', saved and reloaded, and despite it's mostly correct
represented in the content.xml file as:
<table:table-cell
table:formula="oooc:=(ROUND(RAWSUBTRACT([.A$4]*86400;-ROUND([.B9]*[.A$3];1));1)+0.000000499999999)/86400"
office:value-type="date" office:date-value="1970-01-01T00:25:01">
<text:p>1970-01-01 T 00:25:01,00000</text:p>
--
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
