https://bugs.documentfoundation.org/show_bug.cgi?id=136465
Alan Jones <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Ever confirmed|0 |1
Resolution|WORKSFORME |---
--- Comment #31 from Alan Jones <[email protected]> ---
Hi, I disagree that pressing F9 or Control Shift F9 do not result in
modification. These recalculations cause all of the dependencies to update.
How can a user have any faith in a product if what is on the display when they
close the file is not saved.
As for the talk of autocalculate on/off. It is and always has been on.
So lets recap, in order to see the correct values in a spreadsheet and save the
values that I see.
I have to load the file, press F9 on cells which I think might be displaying
the wrong values (or press control shift F9), add something to a random cell
(which has nothing to do with the main calculations in the spreadsheet) remove
whatever I added and then save the file.
Alternatively I can turn autocalculate off press control shift F9 turn
autocalculate back on and close the file.
This defense of the undesirable/unexpected/misleading and potentially very
costly behaviour is not conducive to a good product. I don't believe that we
have even figured out how the inconsistency was introduced in the first place,
which makes this even more significant a finding.
I have just opened this file in StarOffice 8 (as a really old benchmark), the
correct values are always displayed. Somewhere along the road, LibreOffice has
introduced this undesirable effect.
--
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
