[Libreoffice-bugs] [Bug 96464] FILEOPEN FILESAVE: Add UpdateReferenceOnSort as a property of a sort range

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=96464

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

 Blocks||108386


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108386
[Bug 108386] [META] Calc sorting related bugs and enhancements
-- 
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

[Libreoffice-bugs] [Bug 96464] FILEOPEN FILESAVE: Add UpdateReferenceOnSort as a property of a sort range

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=96464

--- Comment #4 from Robert Lacroix  ---
This case merits consideration as a higher priority defect. The change that
introduced the two sort behaviours as a global user setting has minimial impact
on users who are consumers of their own spreadsheets, but it introduces
ambiguity to any enterprise environment where spreadsheet documents are often
shared between users.

-- 
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

[Libreoffice-bugs] [Bug 96464] FILEOPEN FILESAVE: Add UpdateReferenceOnSort as a property of a sort range

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=96464

Buovjaga  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1
   Severity|normal  |enhancement

--- Comment #3 from Buovjaga  ---
Pinged devs on IRC and it seems this is OK to set to NEW.

-- 
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

[Libreoffice-bugs] [Bug 96464] FILEOPEN FILESAVE: Add UpdateReferenceOnSort as a property of a sort range

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=96464

Buovjaga  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 CC||todven...@suomi24.fi
 Ever confirmed|1   |0

-- 
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

[Libreoffice-bugs] [Bug 96464] FILEOPEN FILESAVE: Add UpdateReferenceOnSort as a property of a sort range

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=96464

Robert Lacroix  changed:

   What|Removed |Added

Summary|FILEOPEN FILESAVE: Add  |FILEOPEN FILESAVE: Add
   |UpdateReferenceOnSort as a  |UpdateReferenceOnSort as a
   |property of a document  |property of a sort range

--- Comment #2 from Robert Lacroix  ---
(In reply to m.a.riosv from comment #1)
Thanks for the tip! Defined ranges do a great job of handling multiple sort
ranges having distinct sort properties (range, keys, sort options).

I've changed the summary according to your suggestion, with each sort range
having its own behaviour of UpdateReferenceOnSort by adding a range property.
And forget the original comment about adding that global option as a new
document property.

So the work to do is:

#1) Move the UpdateReferenceOnSort global option checkbox under
Menu/Tools/Options from the LO Calc General group to the LO Calc Defaults
group. It should appear under a new title "Sort Options" to distinguish it from
default options for New Spreadsheet. As configured during installation, the
default value for the global option will be FALSE, for compatibility with other
spreadsheet software.

This cosmetic UI change tells the user that the checkbox sets the default value
of some other setting, rather than directly controlling some behaviour as it
does now.

#2) Add an UpdateReferencesOnSort range property to sort ranges (a sort range
is a range with option "Operations: Sort" appearing under Menu/Data/Define
Range/Options). The default value for this property is taken from the current
value of the UpdateReferencesOnSort global option.

The last-sorted range without a definition is preserved in the saved document.
This range will have the property too.

#3) Add a checkbox to the Sort Options tab of the Sort dialog to show and set
the UpdateReferenceOnSort range property.

#4) A legacy document doesn't have this property in its sort ranges. When
loading a legacy document, add the property to every sort range using the
default option value as in #2.

This saves the user from manually running every sort in a document to add this
property to all ranges.

#5) The behaviour when sorting a range is determined by the range's
UpdateReferenceOnSort range property.

#6) Saving a document containing one or more ranges preserves the
UpdateReferenceOnSort range property for each sort range.

#7) Loading a document containing one or more ranges

#8) When exporting LO to a document format that does not support the new
UpdateReferenceOnSort range property, the presence of a sorted range in the
document will cause the "potential data loss" warning to be displayed.

== Limitations ==

A sort range property can't be changed by the user without performing the sort.
A user can only click OK to accept changes (and sort), or click Cancel and the
property lose changes. Is that acceptable behaviour?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs