https://bugs.documentfoundation.org/show_bug.cgi?id=96464
Bug ID: 96464
Summary: FILEOPEN FILESAVE: Add UpdateReferenceOnSort as a
property of a document
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
This feature request is a quick fix to mitigate the risk of silently damaging
formulas in many documents by inadvertently having the wrong setting for the
UpdateReferenceOnSort global option.
OL-Calc has 2 UpdateReferenceOnSort behaviours available through a global
option, which has mooted the argument about which behaviour is broken. Both
behaviours have valid use cases, and the preponderance of legacy spreadsheets
has settled the default value of this option for compatibility.
>From a document safety consideration however, each document needs it's own
persistent property for UpdateReferenceOnSort, with initial value determined by
the current state of the global UpdateReferenceOnSort option. Presently,
Murphy's law guarantees that the wrong global setting will be used while
sorting ranges in existing documents, silently mangling cell references.
In principle one document could have multiple sort ranges needing different
behaviours and sort options, but OL-Calc does not support multiple persistent
sort ranges in a document at this time - this could be the subject of a future
feature request.
--
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
