[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

Óvári <ovari123 at zoho.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |needsUXEval
                 CC|                            |libreoffice-ux-advise at lists
                   |                            |.freedesktop.org

--- Comment #9 from Óvári <ovari123 at zoho.com> ---
(In reply to Óvári from comment #8)
> (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 then
> > reused elsewhere with a TEXTJOIN() function? And is "#N/A" better than, say,
> > an empty string?
> 
> An empty string seems better than "#N/A", which is the same output as shown
> in the formula bar.
I was wrong, #N/A is better than an empty string as the value is unavailable
(Not Available).

Additionally, this is the behavior of other spreadsheet programs. Please advise
if you require a screenshot of the other spreadsheet program.

(In reply to Stéphane Guillou (stragu) from comment #7)
> I am closing as "not a bug", but if you are not convinced, please feel free
> to ping the UX/Design team for more opinion.
Adding keyword 'needsUXEval' and CC
'libreoffice-ux-advise at lists.freedesktop.org' for input from UX.

Not sure what the convention with the status is at LibreOffice. Please change
the status if needed.

Thank you

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