[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