[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]

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

--- Comment #11 from Óvári <ovari123 at zoho.com> ---
(In reply to Heiko Tietze from comment #10)
> (In reply to Óvári from comment #9)
> > Additionally, this is the behavior of other spreadsheet programs.
> Tested with MSO365 and a cell with =formulatext(a1) shows the formula with
> protection enabled. Both Calc and Excel hides the formula "=formulatext()"
> or "=formula()" from the formula bar if the hide option is enabled.
> 
> (In reply to Stéphane Guillou (stragu) from comment #7)
> > - if you don't want a cell's formula to be shown, in what use case would you
> > _also_ have other cells whose job is explicitly and exclusively to expose
> > such formula?
> This needs to be answered.
1. A protected spreadsheet, with hidden formulae, is provided to an end-user.
2. It is expected that any hidden formula remains hidden and should not be seen
by the end-user.
3. An end-user can easily reverse engineer a formula in LibreOffice Calc as the
FORMULA() exposes the hidden formula. Excel 2021 LTSC stops this happening with
#N/A error.

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