<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 - enhancement request: UI - warn user if sheet contains 'unrecalculated outdated values'"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124783">124783</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>enhancement request: UI - warn user if sheet contains 'unrecalculated outdated values'
</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>enhancement
</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
come up that it's possible to have values stored in a file which do not match
with the result of the formula in the cell by saving a file with data -
calculate - autocalculate: off.
this is a correct behaviour of the program, but may cause errors at least when
users have to work with files created and stored by other persons.
it would be nice to have any, some or all of:
- a warning when opening a file where autocalculate is off,
- a clear visible sign somewhere in the status- or toolbar 'autocalculate is
off',
- a warning when a file contains values which deviate from the result of the
formula in that cell,
- a 'flag' on each cell where the shown value deviates from the result of the
formula in that cell,
Winfried Donkers asked me to file new bugs since the original problem is
solved,
this request is for '- it would be nice to have a warning towards the user
whenever (s)he's dealing with files that contain deviations between formula and
formerly stored values' mentioned there.
Steps to Reproduce:
follow the steps in #124669 <a href="show_bug.cgi?id=124783#c7">comment 7</a> to produce a file with a value having a
'false result' in a cell.
Actual Results:
no hint to the user
Expected Results:
anything warning the user or helping him to understand the situation,
(otherwise he might ask 'silly questions' in 'ask' or 'bugs').
Reproducible: Always
User Profile Reset: No
Additional Info:
i think the problem is around in all versions,</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>