https://bugs.documentfoundation.org/show_bug.cgi?id=161836
--- Comment #11 from Óvári <[email protected]> --- (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 the assignee for the bug.
