<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Hide Formula NOT compatible with FORMULA function name"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=140571">140571</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Hide Formula NOT compatible with FORMULA function name
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>3.3.0 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>philippe.rocher@outlook.com
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>