https://bugs.documentfoundation.org/show_bug.cgi?id=104824
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
CC| |[email protected]
Resolution|--- |WONTFIX
--- Comment #4 from Eike Rathke <[email protected]> ---
The actual cause is that in the document some (not all) formula results in
column F are stored as type string and strings are ignored while calculating
SUM, hence..
Affected cells in the December range are F343, F349, F350 and F364.
Might be some earlier version had a bug that for a formula such as
=IF((C349&D349)="","",(D349-C349-7))
if it resulted in an empty string the string type somehow was persistent even
if later a numeric value was calculated, which doesn't explain for F343 though
where the formula is =D343-C343. Then, even in subsequent versions, as long as
the affected formula cells were not recalculated the type was kept and saved
again.
There's not much we can do unless during import we wanted to check if any
string type result could be a numeric result instead.. Once the document is
recalculated (e.g. using Shift+Ctrl+F9 or after load using the Tools-Options
setting already mentioned) and saved again the values are correct.
--
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
