[Bug 161836] FORMULA() incorrectly shows the formula, instead of the #N/A error value, when the sheet is protected and *Hide Formula* is enabled
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Mon Aug 5 14:54:32 UTC 2024
https://bugs.documentfoundation.org/show_bug.cgi?id=161836
--- Comment #13 from Eike Rathke <erack at redhat.com> ---
(In reply to Óvári from comment #11)
> 2. It is expected that any hidden formula remains hidden and should not be
> seen by the end-user.
That's a false assumption anyway, any formula can be easily seen in the XML
stream of the document, be it .xlsx OOXML or .ods ODF. Hidden formulas are
_not_ a security feature, it's just UI obscurity.
--
You are receiving this mail because:
You are on the CC list for the bug.
More information about the Libreoffice-ux-advise
mailing list