[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 #10 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
(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.

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