[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 #12 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
(In reply to Óvári from comment #11)
> 1. A protected spreadsheet, with hidden formulae, is provided to an end-user...
But if the sheet designer wants to hide a formula s/he would not explicitly
expose it with =FORMULA(). It mean you want to show the calculation - inside
the sheet. The hide option does correctly affect the formula bar and something
like A1=1+2 / B1=FORMULA(A1) would not be shown in the formula bar but in the
sheet for B1.

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