<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 - Version 7.0.2.2: Not all cells in Calc are automatically recalculating."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137941">137941</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Version 7.0.2.2: Not all cells in Calc are automatically recalculating.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.2.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>mikehaag314@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Not all cells are recalculating. In particular, cells that depend on summary
cells (for example, "grand total" cell that depends on two or more "sub-total"
cells) fails to automatically recalculate.
Steps to Reproduce:
1. Set up a simple spreadsheet:
A1 = 1000
A2 = 1000
A3 = SUM(A1:A2)
A5 = 1000
A6 = 1000
A7 = SUM(A5:A6)
A9 = SUM(A3,A7)
2. Assure Data > Calculate > AutoCalculate is checked.
3. Observe A3 = 2000, A7 = 2000, and A9 = 4000
Actual Results:
1. Change A1 to 2000 and <Enter or Return>
2. Observe A3 updates to 3000, but A9 is still 4000.
3. Push F9, save the file, or click to another desktop window (so the
spreadsheet loses focus) and observe that A9 updates to 5000.
Expected Results:
Expect all cells to recalculate when AutoCalculate is checked.
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Version: 7.0.2.2
Build ID: 00(Build:2)
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.0.2-0ubuntu1
Calc: threaded</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>