https://bugs.documentfoundation.org/show_bug.cgi?id=161836
Bug ID: 161836
Summary: FORMULA() shows the formula when the sheet is
protected
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
FORMULA() should *not* show the FORMULATEXT when the cell protection is enabled
in a protected sheet.
Steps to Reproduce:
1. In cell A1 type: =1+3
2. In cell C1 type: =FORMULA(A1)
3. In cell D1 type: =FORMULA(A1)
4. Right-click on D1, Format Cells…, Cell Protection, unselect Protected and
unselect Hide Formula
5. Right-click on sheet Sheet1, select Protect Sheet…
6. Click OK (no password) (Sheet 1 is protected)
Actual Results:
1. Click on cell A1, formula bar is empty (correct)
2. Click on cell C1, the value of the cell is "=1+3" (incorrect)
3. Click on cell D1, the value of the cell is "=1+3" (incorrect)
Expected Results:
1. Click on cell A1, formula bar is empty (correct)
2. Click on cell C1, the value of the cell should return the #N/A error value
3. Click on cell D1, the value of the cell should return the #N/A error value
Reproducible: Always
User Profile Reset: No
Additional Info:
FORMULA() should *not* show the value returned by the FORMULATEXT() function
when the cell protection is enabled. The FORMULATEXT() function should show the
#N/A error value.
Thank you
--
You are receiving this mail because:
You are the assignee for the bug.
