[Libreoffice-bugs] [Bug 140722] calc: calculate: load: some cells shown as '0' after file load, update with values only after hard recalc

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from b. <newbie-02 at gmx.de> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210427/a649bf40/attachment-0001.htm>