[Libreoffice-bugs] [Bug 136465] Cell contains incorrect value from formula

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #18 from BogdanB <buzea.bogdan at libreoffice.org> ---
I played with this now. I made this test:
- I created a file with 1, 4 and the sum of the 2 numbers. Autocalculate is NOT
checked. Change the 4 to 6. The sum is wrong. Save the file and close.
- First scenario: Recalculate still NOT checked. Open the file from above. THe
sum is wrong.
- Second scenario: Recalculate activated. Open the file from above. The sum is
wrong. Select the sum. F9 - the sum is correct. Change the number: the sum is
wrong.

My conclusion: if a formula is created when Autocalculate is NOT checked, this
formula will never became autocalculate, even IF autocalculate is activated. It
is interesting to know what properties this formula or cell have, because I
consider NOT to be ok, to have Autocalculate checked and not to have the real
autocalculate for some cells activated. So, if there is a properties, this
should change depending of the Autocalculate.

-- 
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/20200905/13f90c6a/attachment-0001.htm>