<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 - WORK: EDIT: issues left in fixing shared-formula / autocalculate problems?"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=128975">128975</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>WORK: EDIT: issues left in fixing shared-formula / autocalculate problems?
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>4.2.0.4 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:
short try: load file from next comment, delete value in B10, observe C10,
D8:D12 and E6:E14 changing. copy row 20 and paste over rows 1:20 - it's the
same content as before!, delete value in B10, observe only C10 reacting to it,
while D8:D12 and E6:E14 show wrong - unchanged - values.
hard recalc (shift-ctrl-F9) corrects the view, but it is not sustainable, not
thorough, when changing other cells in column B, again the cells in D and E are
excluded from refresh
long story: i think the problem is 'related' to plenty bugs and reports
regarding shared formulae blocking autocalculate, e.g.
<a class="bz_bug_link
bz_status_VERIFIED bz_closed"
title="VERIFIED FIXED - Changing a reference in a formula cell of a shared formula group may not rebuild all dependencies of the then split group."
href="show_bug.cgi?id=123736">https://bugs.documentfoundation.org/show_bug.cgi?id=123736</a>, i was asked there
to file a new bug,
on checking old fault descriptions i stumbled on
<a href="https://ask.libreoffice.org/en/question/12165/calc-auto-recalc-does-not-work/">https://ask.libreoffice.org/en/question/12165/calc-auto-recalc-does-not-work/</a>,
the procedure mentioned there by Budi B L:
"Still having similar problem Version: 4.4.0.3. This is my case: B10= number,
data for these formula C10= formula: =IF(IFERROR(B10,0),1,0) D10= formula:
=SUM(C8:C12) E10= formula: =SUM(D8:D12) And those cells copied to B1:B20 The
result: ONLY the col C that changed by input or edit the cell in col B. NO
changes in col D and com E, related option already been set."
fails in ver 6.4.0.0.alpha1+ for linux, x64, build id ends with 3d60d7.
it does not! fail loading a saved file with the formulae, but it does! fail if
you create the sheet from scratch, or take one row in that sheet and copy it to
a range of rows, e.g. 1:20
the following versions failed too (for win german, lo englisch, german locale,
i had to change the delimiter in the formula from ',' to ';':
Version: 6.2.8.2 (x64)
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee
CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win;
Locale: de-DE (de_DE); UI-Language: en-US
Calc:
Version: 6.4.0.0.alpha1 (x64)
Build ID: cc57df8f942f239d29cb575ea5a7cb01405db787
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:
Version: 6.4.0.0.alpha1+ (x64)
Build ID: d456ca6efb98d707427228e8131dfe8a5f27e2f6
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:
have fun in debug and coding, thanks for any help to get finally rid of this
problem
Steps to Reproduce:
see above description and 'script' by Budi B L
Actual Results:
under special circumstances some cells are excluded from automatic
recalculation,
Expected Results:
recalc - autocalculate should work for all! cells,
Reproducible: Always
User Profile Reset: No
Additional Info:
see above,</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>