https://bugs.documentfoundation.org/show_bug.cgi?id=161836
--- Comment #10 from Heiko Tietze ---
(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.
https://bugs.documentfoundation.org/show_bug.cgi?id=161836
Óvári changed:
What|Removed |Added
Keywords||needsUXEval
CC|
https://bugs.documentfoundation.org/show_bug.cgi?id=161836
--- Comment #8 from Óvári ---
(In reply to Stéphane Guillou (stragu) from comment #7)
> - why should a cell's setting propagate to other cells? I think this opens a
> can of worms. For example, what happens if the contents of cell D1 are
https://bugs.documentfoundation.org/show_bug.cgi?id=161836
Stéphane Guillou (stragu) changed:
What|Removed |Added
Status|UNCONFIRMED |RESOLVED
https://bugs.documentfoundation.org/show_bug.cgi?id=161836
--- Comment #6 from Eike Rathke ---
To me this is not a bug. A protected cell is prevented from being edited and
showing its formula, it's a UI feature, that's all. Not anything inheriting to
whatever might access its formula, be it the
https://bugs.documentfoundation.org/show_bug.cgi?id=161836
--- Comment #5 from ady ---
FWIW...
(In reply to Óvári from comment #4)
> 2. D1 shows formula from cell A1.
> (a) Is this inconsistent with the behavior of the formula bar when cell A1
> is selected?
> (b) Should the value in D1 be the
https://bugs.documentfoundation.org/show_bug.cgi?id=161836
--- Comment #4 from Óvári ---
Created attachment 195054
--> https://bugs.documentfoundation.org/attachment.cgi?id=195054=edit
Workaround to view formula when formula is hidden
(In reply to Regina Henschel from comment #3)
> The ODF
https://bugs.documentfoundation.org/show_bug.cgi?id=161836
Óvári changed:
What|Removed |Added
Summary|FORMULA() incorrectly shows |FORMULA() incorrectly shows