[Libreoffice-ux-advise] [Bug 149497] CALC Enhancement. Permit "No User Input" as a data validation which would then permit filter sorting

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from Colin <that.man.colin at gmail.com> ---
(In reply to Heiko Tietze from comment #4)
> Please provide an example to follow your steps. It's a quite complicated
> topic.

Hi Heiko,
I assume you're referring to Maxim's comments.
Perhaps I found it easier to follow them because I raised the issue but I think
the simple version is;

1. Permit the use of a validation/cell protection "NO USER INPUT" which will
obviously have zero impact on any cell calculation anywhere. It's a simple
mechanism to avoid a user inadvertantly overwriting a calculated cell.

2. Permit the setting for an entire selected column, row or matrix.

3. Ensure this permits AUTOFILTER sorting functionality which is currently
prohibited with protection for the specious reasons given in the extract from
the help file.

I say specious, because LoCalc can already retain links between cells in both
the current sheet and other referenced sheets when sorting and filtering, so
why this should be an issue if a user is prohibited from modifying a computed
value eludes me.

I've left it as need info but you may need to target Maxim's email as he's NOT
attached to the CC list. If it's targeted at me then please advise if further
information is required

-- 
You are receiving this mail because:
You are on the CC list for the bug.