https://bugs.documentfoundation.org/show_bug.cgi?id=149497
Heiko Tietze <heiko.tie...@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@lists |heiko.tietze@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.tie...@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.
