<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 - the wording around tools - options - LibreOffice Calc - Formula - Recalculation on File Load is questionable"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124784">124784</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>the wording around tools - options - LibreOffice Calc - Formula - Recalculation on File Load is questionable
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</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>newbie-02@gmx.de
</td>
</tr></table>
<p>
<div>
<pre>Description:
while discussing <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Error in the function SUM (LibreOffice Calc)"
href="show_bug.cgi?id=124669">https://bugs.documentfoundation.org/show_bug.cgi?id=124669</a> it
came up that the wording around the setting of tools - options - LibreOffice
Calc - Formula - Recalculation on File Load is questionable, it announces to
work for some special files, but works for others too.
this is irritating for users.
Winfried Donkers asked me to file new bugs since the original problem is
solved,
this request is for "- the comment 'odf spreadsheet (not saved with
libreoffice)' looks outdated, the setting produces different evaluation of the
file even after saving it with a different name from inside calc, thus neither
'excel' nor 'not saved with libreoffice' are matched ... despite that calc
does! do a new calculation of the values with this option set, and doesn't if
not set. someone should check under which conditions recalc is triggered, check
if that's the intended logic, and either correct the handling of files or the
comments in the setting dialog." mentioned there.
Steps to Reproduce:
go to tools - options - LibreOffice Calc - Formula, see the dialog for
Recalculation on File Load there, try with the steps of <a href="show_bug.cgi?id=124784#c7">comment 7</a> of #124669
that the setting does affect files stored with actual calc versions too,
Actual Results:
the setting works on files stored with fresh versions of LO calc,
Expected Results:
either the setting to affect only the files specified in the dialog, or the
dialog announcing clearly that it will affect 'normal' files too.
Reproducible: Always
User Profile Reset: No
Additional Info:
i think the problem is in all versions, the wording in mac and linux versions
may be different</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>