[Libreoffice-bugs] [Bug 116104] trivial sum() bad value

[bugzilla-daemon at bugs.documentfoundation.org]

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

Winfried Donkers <winfrieddonkers at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |NOTOURBUG

--- Comment #14 from Winfried Donkers <winfrieddonkers at libreoffice.org> ---
When investigating the the document internally, like raal did in comment#12, it
becomes apparent that the document itself is at fault, not Calc. This is a
document created by Google Docs (see comment#7), not by Calc.
Proper ODF documents contain a reference to the application which created/saved
the document, this document does not contain any such reference, so I can't see
which application/version exactly was used to save the document. 

The formulas in the documents are saved incorrectly, with the result that they
appear as formulas, but do not work as such.
It can be demonstrated by recalculating the formulas: select any cell with a
formula (=something) and press F9. Now you see the correct result of the
formula.
For cells D4, D7, D9, D10, D11 and D23 the result seems to be a realignment
from left to right, but in reality it is a change from text (incorrect) to
numeric value (correct). For cell D26, the change is twofold: a change from
text to numeric value and a recalculation with a different value as result
(depending on whether D4, D7, D9, D10, D11 or D23 have been recalculated).
I cannot explain why the formulas in D5 and D6 are saved correctly in the
document.

As my conclusion is that Google Docs created a faulty document, it a Google bug
and not a Calc bug. Setting the status as such.

-- 
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/20180323/6e65b925/attachment-0001.html>