[Libreoffice-ux-advise] [Bug 149497] Add option to allow sorting content in protected sheets

[bugzilla-daemon at bugs.documentfoundation.org]

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

Heiko Tietze <heiko.tietze at documentfoundation.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |107450
            Summary|CALC Enhancement. Permit    |Add option to allow sorting
                   |"No User Input" as a data   |content in protected sheets
                   |validation which would then |
                   |permit filter sorting       |
                 CC|libreoffice-ux-advise at lists |heiko.tietze at documentfounda
                   |.freedesktop.org            |tion.org
             Status|UNCONFIRMED                 |NEW
           See Also|                            |https://bugs.documentfounda
                   |                            |tion.org/show_bug.cgi?id=57
                   |                            |091
           Keywords|needsUXEval                 |
     Ever confirmed|0                           |1

--- Comment #7 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
We discussed this topic in the design meeting.

To rephrase the request, it should be possible to sort data in protected sheets
(filtering works out of the box). Sorting may affect the data integrity, for
example if a reference changes after sorting. We should also keep in mind that
you can limit sort to ranges. So this option would be a bit dangerous, yet
there might be scenarios where it is acceptable and needed.

Instead of tweaking data validation with "No User Input" we suggest to add an
option at the sheet protection dialog allowing to sort the content. Only
drawback is that you permit it per sheet and not per range. This is kind of a
duplicate to bug 57091 (and apparently working like this in MSO).

(In reply to Maxim Egorushkin from comment #2)
> My use case is analyzing a CSV file by applying different sorts and filters
> to its rows and columns.
Never experienced any protercion issue with CSV. Sheet protection is enabled
manually via Tools > Protect Sheet (the suggested option would be added to this
dialog) and you control per cell if a protection is _not_ applied. See also the
discussion on bug 143349.

> Not completely worthless, though, because such a design and functionality
> can still be used as bad examples in textbooks to contrast with the
> fundamental engineering principle of least astonishment. 
:-)


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=107450
[Bug 107450] [META] Cell and sheet protection bugs and enhancements
-- 
You are receiving this mail because:
You are on the CC list for the bug.