https://bugs.documentfoundation.org/show_bug.cgi?id=125052
Bug ID: 125052
Summary: Data error risk from not calculating on large
spreadsheets
Product: LibreOffice
Version: 6.0.7.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: openfo...@davidpbrown.co.uk
Sheet not calculating, gives misleading results - because that inaction is not
declared.
At some point not obvious it seems a large spreadsheet becomes too large, that
Calc stops being dynamic and does not update at every opportunity.
Ctrl+Shift+F9 works to force recalculation
which is great - IF you know to do that AND IF you know that it's necessary -
because you spot cells are not updated correctly.
I saw this from odd vlookup results and fortunately figured out from a quick
search but it is to be expected many users will not see the change and even
those aware of this, will remain uncertain when and if, this feature has
actioned.. and it's a feature because it's a lot faster on a large spreadsheet
to not calculate complexity. (It would be useful to know how to force this
switch off before it is just too large.)
Expected behaviour: some fundamental change is declared explicitly and/or some
indicator on the bottom toolbar perhaps notes that the sheet requires forced
update.
It's made worse by the opening of that file not apparently triggering
recalculation.. there is no suggestion that is required.
Risk of data errors is obvious, from sheets where this has occurred.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
