<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 CALCULATING: autocalculate with 'shared formulas' still broken if a shared formula has #REF! problem"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=129541">129541</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>calc CALCULATING: autocalculate with 'shared formulas' still broken if a shared formula has #REF! problem
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>4.2 all versions
</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:
shortest:
load attachment from next comment,
click button to provoke error,
calculate cells B2 and B3 manualy,
displayed values are wrong,
short:
A3: 3 '(any number will fit),
B3: =SUM(A2:A4) 'similar formulas will fail too,
A3:B3: copy
A1:B3: paste
observe B1: '#REF!' - correct,
play with values in A1:A3, B2:B3 cut off from autocalculation - not correct,
alternative:
A1:B1 must not! be filled with the same formula,
A3:B3: copy '
A2:B4: paste
play with values in A2:A4, B2:B4 should react correctly,
long:
there have been several cases where autocalculate was broken for 'shared
formulas', delete or insert in referenced ranges, changing formulae, inserting
columns and so on,
some have been patched in the nearby past, this one remains,
i think it's already adressed in another case treating nested formulas,
may be this is the essence causing the errors there,
have fun,
merry x-mas
b.
P.S:
call me crazy ... i only want this program to become reliable again - if
possible,
bug flooding? - imho the original bug is only one, something 'bigger', more
fundamental, in the past (4.1 -> 4.2), as of now and as of how bugs are
handeled there's nothing i can do than observe and report,
forum trolls: pls. do NOT! ask if i have / had <data-calculate-autocalculate>
enabled, also resetting user profile won't help,
will provide testsheet with macro to produce the error in next comment,
Steps to Reproduce:
see above
Actual Results:
cells cut off from auto recalculation
Expected Results:
all cell should be recalculated correctly in any case,
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 6.5.0.0.alpha0+ (x64)
Build ID: 209fc9fd7fa433947af0bf86e210d73fa7f5a045
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win;
Locale: de-DE (de_DE); UI-Language: en-US
Calc:
last verson i've seen without this bug: 4.1.6.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>