[Libreoffice-bugs] [Bug 140571] New: Hide Formula NOT compatible with FORMULA function name

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=140571

            Bug ID: 140571
           Summary: Hide Formula NOT compatible with FORMULA function name
           Product: LibreOffice
           Version: 3.3.0 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: philippe.rocher at outlook.com

Description:
When I check 'Hide formula' in the 'Cell Protection' tab of a formula cell and
select 'Protect Sheet' from the 'Tools' menu Then using the FORMULA function
name with reference to the formula cell (in a new sheet to the spreadsheet
file) will display the formula as a text string.

Steps to Reproduce:
1. Check 'Hide formula' in the 'Cell Protection' tab of any formula cell
2. Select 'Protect Sheet' from the 'Tools' menu
3. Call the FORMULA function name with reference to the formula cell above (in
a new sheet to the spreadsheet file)
4

Actual Results:
FORMULA function name displays the formula of the formula cell as a text
string.

Expected Results:
The cell protection ('hide formula') should prevent the FORMULA function name
from displaying the content of the formula cell.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.0.3 (x64) / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210220/f8e11950/attachment.htm>