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
Philippe, you can not confirm your own bug. Someone else has to confirm it. Please wait.
Reproduced and I see the reasoning, when it is otherwise hidden. Arch Linux 64-bit, X11 Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 41d96a72fc0e0a9fa35b6ac88a389473f8baedaf CPU threads: 8; OS: Linux 6.3; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 16 May 2023