<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 - calc autocalculate reproducibly fails on cell with formula after editing a copy! of that cell"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123736">123736</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>calc autocalculate reproducibly fails on cell with formula after editing a copy! of that cell
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.7.2 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>newbie-02@gmx.de
</td>
</tr></table>
<p>
<div>
<pre>Description:
hello all,
libreoffice calculates 1 plus 1 to be 3, it's not! a matter of rounding,
i couldn't stand waiting if and when someone will fix <a class="bz_bug_link
bz_status_NEW "
title="NEW - calc autocalculate failing sometimes on editing (move or delete of cells or undo) in ranges referenced in formulas"
href="show_bug.cgi?id=123714">tdf#123714</a>, thus played
and 'stressed' some sheets to narrow down where errors evolve,
i found one effect that i consider more than critical:
reproducible in plenty situations the following happens:
after making a copy of a cell with a formula, and editing that copy, the
originating cell is excluded from autocalculate,
no matter what you do with the copy, you may even delete it from the sheet, the
'broken' source cell will always need 'F9' or 'crtl-shift-F9' to be
recalculated after changes in the values of the cells referenced in the
formula, thus you can see: 1 + 1 = 3 for the sum function '=SUM(A1:B1)' in C1
with '1' in A1 and changing B1 from '2' to '1'.
formula, formatting, everything else is correct, even calculating works correct
*when* it's initiated by F9, the only 'fault' is: the cell is excluded from
autocalculate!
you can make a new copy of the cell with the 'first formula', and it - the
source - will be included in autocalculate again,
until you edit the new copy, then autocalculating for the source cell will be
broken again,
(i don't know if it's affecting only distinct formulas and cells, i have the
impression formulas calculating ranges fail ('=SUM(Xi:Yj)', '=MAX(A1:A15)')
while formulas calculating distinct cells work ('=A1+B2' or similar) just play
with it, below is one general description and under 'steps' one failing sample
with concrete values)
general:
- check that autocalculate is on,
- put a formula in one cell,
- make a copy of that cell,
- put some data in the sheet to be calculated by he formulas,
- check the results,
- change something in the area / cells used in the formula,
- check that the results change correctly,
- edit something in the copied formula while leaving the cell with the 'source
formula' untouched,
- watch that from now on changes in the area / cells used in the formulas were
not! anymore reflected in correct results in the 'source-formula-cell', while
the 'copied-formula-cell' still calculates correctly,
that's definitively *not* how a reliable spreadsheet should work, changes
producing erroneous results in cells not even touched by the change.
if the above description works correct in your case pls. check the
concrete sample in 'steps to reproduce'.
my Version: 5.4.7.2 (x64)
Steps to Reproduce:
1. check that autocalculate is on,
2. put '=SUM(A1:B1)' in C1,
3. copy C1 with 'ctrl-c',
4. insert that copy in C2 with 'ctrl-v',
5. put '1' in A1 and A2 and '2' in B1 and B2,
6. check that C1 and C2 calculate '3',
7. edit C2 from '=SUM(A2:B2)' to '=SUM(A2:B3)', do not! touch C1,
8. change B1 from '2' to '1',
9. check the value of C1, in my case it still shows '3' while calculating 1+1,
10. watch that from now on changes in the area / cells used in the formulas are
not! anymore reflected in correct results in the 'source-formula-cell' C1,
while the 'copied-formula-cell' C2 still calculates correctly,
Actual Results:
C1 isn't updated on changes of A1 or B1
Expected Results:
C1 should be updated by autocalculate in the same manner as C2
Reproducible: Always
User Profile Reset: No
Additional Info:
maybee that's the source of plenty similar bugs, maybee it can be triggered
late after 'construction' of these 'shared formulas' ('landmines' in sheets
causing destructions in areas far away?), maybee it's not the real fundamental
fault but only an effect in a shell around it ... but, not negotiable, it
should be checked and fixed as fast as possible ...
Version: 5.4.7.2 (x64)
Build ID: c838ef25c16710f8838b1faec480ebba495259d0
CPU threads: 8; OS: Windows 6.1; UI render: default;
Locale: de-DE (de_DE); Calc: group
i had to choose an 'earliest affected' version, could only tell about my actual
install, i'd bet it's in since 4.2</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>