https://bugs.documentfoundation.org/show_bug.cgi?id=161836
--- Comment #4 from Óvári <[email protected]> --- Created attachment 195054 --> https://bugs.documentfoundation.org/attachment.cgi?id=195054&action=edit Workaround to view formula when formula is hidden (In reply to Regina Henschel from comment #3) > The ODF format does not specify such behavior. "Protection" of a table cell > only prevents editing the cell by users. > > From 19.700.5 <table:table-cell>, part 3, ODF 1.3 > "The table:protected attribute specifies whether a table cell is protected. > Users cannot edit the content of a cell that is marked as protected." > > "Users cannot edit" does not mean that the cell content cannot be used in > other formulas. > > BTW, opening the .ods file in "Protected View" in Excel does not show #N/A > error but shows =1+3. Sorry for the misunderstanding. 1. No formula shown in formula bar as cell A1 has (a) "Hide Formula" enabled (b) "Protect Sheet" enabled with no password 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 #N/A error value? Thank you -- You are receiving this mail because: You are the assignee for the bug.
