https://bugs.freedesktop.org/show_bug.cgi?id=53824
Bug #: 53824
Summary: EDITING: Switch for auto-recalculation
Classification: Unclassified
Product: LibreOffice
Version: 3.5.4 release
Platform: All
OS/Version: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Situation: When working with very large spreadsheet documents (in my case
spanning 75 sheets with 30-2000 rows an 5 to 60 columns each, about half of
which with formulae), LibreOffice is stable but very slow. Data entry is nearly
impossible due to long wait times for recalculation after each cell edit.
Suggested enhancements:
a) Implement switch to manually enable/disable recalculation globally.
b) Switch should be UI-centric, not document-centric. Default is "on" (enable
auto-recalc), and can be configured to be "off".
c) Switch should be accessible using the menu an symbol bars so that it is
easily usable.
d) Switch should be in "alerting" design when deactivated to indicate the
possible inconsistencies resulting in the document.
e) Status bar message "INCONSISTENT DATA-PLEASE RECALCULATE" (in "alerting"
design) when auto-calculation is switched off and a cell has been edited.
f) Recalculation can be started any time by pressing a second button in the
symbol bar or by pressing a predefined key.
Expected use:
Switching off automatic recalculation allows for efficient data entry and data
editing operations. Manually recalculating re-establishes consistency within
the document. Status messages and stark button colors indicate possibly
inconsistent content.
References:
- Bug #47106
- Function "AutoCalculate" which can be disabled but does not seem to have an
effect.
- http://en.libreofficeforum.org/node/1061
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
