<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:gtimur@gmail.com" title="Timur <gtimur@gmail.com>"> <span class="fn">Timur</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - FILEOPEN: protected workbook"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=60718">bug 60718</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEW
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>gtimur@gmail.com
</td>
</tr>
<tr>
<td style="text-align:right;">See Also</td>
<td>https://bugs.freedesktop.org/show_bug.cgi?id=63608
</td>
<td>
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - FILEOPEN: protected workbook"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=60718#c25">Comment # 25</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - FILEOPEN: protected workbook"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=60718">bug 60718</a>
from <span class="vcard"><a class="email" href="mailto:gtimur@gmail.com" title="Timur <gtimur@gmail.com>"> <span class="fn">Timur</span></a>
</span></b>
<pre>This bug needed a minimal test case and a simple explanation.
If I understood it well: open <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=79401" name="attach_79401" title="example file">attachment 79401</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=79401&action=edit" title="example file">[details]</a></span> and see sheet: "Acqua condotta
sintesi", cell: B5 which is in MSO:
=VLOOKUP("CodicePerito";_RiservatoAxa_!A1:B210;2;FALSE) with value 20445.
LO opens it as:
=VLOOKUP("CodicePerito";$_RiservatoAxa_.A1:B210;2;0) with value 0 BUT
recalculation also shows 20445.
Recalculation is F9 on that cell or Shift+Ctrl+F9 to recalculate all formulas
in the document.
And from LO 4.0 that we get with: "Menu/Tools/Options/LibreOffice calc/Formula
- Recalculation on file load" setting Excel 2007 and newer to always
recalculate or better prompt user.
Default option is to "Never recalculate". Previously LO 3.6 and earlier it was
"Always" so that's why this bug is repro from 4.0.
So it's not about "Fileopen: protected workbook", it's about "Fileopen: XLSX
needs hard recalculation".
I close this as NotABug with the intention to open a new one with a general
problem about recalculations which are not transparent to the user. Even help
page <a href="https://help.libreoffice.org/Calc/Recalculate">https://help.libreoffice.org/Calc/Recalculate</a> is wrong.</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>