https://bugs.documentfoundation.org/show_bug.cgi?id=98481
Flint O'Brien <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Version|5.1.0.2 rc |5.2.1.2 release
--- Comment #5 from Flint O'Brien <[email protected]> ---
The model I have in my mind is that all values for all formulas are always
correct. No exceptions. I don't understand why recalculate-on-load is an option
(and off by default).
I changed the preference to recalculate on file load and it does calculate
correctly when the file is loaded and it properly calculates equations entered
after the file is loaded. If I turn this option off (which is the default), the
problem fields are not calculated correctly on load and adding new expressions
are also not calculated correctly. As mentioned in the original bug report,
this is for expressions referencing other sheets and expressions on the current
sheet that reference cells on another sheet.
Regarding the previous comment to just throw this bug out...
Let met start with saying that I do appreciate all the work everyone is putting
in on this project.
I don't know why I have to provide this information since it's not necessary to
recreate this bug. The bug exists using the default options of a clean install.
I'm disheartened if you're not willing to fix bugs that have been thoroughly
reported with a complete and minimal example. A spreadsheet program that you
can't trust to do proper calculations 100% of the time is not very useful.
The reason I reported the bug was to try to help the community for people who
are unsuspecting and have no reason to turn on recalculate-on-load. With a
large spreadsheet, it's not always obvious the numbers aren't being calculated
correctly. I really trusted the values to be correct and was quite surprised to
find this bug (and doubly surprised it hasn't been high priority to be fix).
--
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
