<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 - VIEWING: cells with formular referencing pivot tables contain stale / incorrect values until manual refresh"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=112407">112407</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>VIEWING: cells with formular referencing pivot tables contain stale / incorrect values until manual refresh
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.1.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>tv@fuzzy.cz
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=136259" name="attach_136259" title="spreadsheet demonstrating the stale data after opening">attachment 136259</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=136259&action=edit" title="spreadsheet demonstrating the stale data after opening">[details]</a></span>
spreadsheet demonstrating the stale data after opening
I have a spreadsheet with formulas comparing data from pivot tables. After
opening the document, some of the data is stale, and I have to manually refresh
the pivot tables to get correct results. Unfortunately saving the file does not
make the refresh persistent, and I have to repeat every time.
Attached is an example spreadsheet, demonstrating the issue. I've tried to make
it smaller, but it seems to make the problem go away.
The spreadsheet contains data from a benchmark (timing of database queries),
and there are three types of sheets:
* raw data (query, info about database settings, timing of executions)
* pivot tables (summarizes raw data)
* comparison of the pivot tables (first sheet)
So essentially the flow is "raw -> pivot -> comparison".
To demonstrate the issue, look at cells D3, K3 and Y3 on the "comparison"
sheet. The cells have values 65, 64 and 1.04 (104%). However Y3 = K3/D3, and
clearly 64/65 is not 1.04, in fact it's less than 1.0.
Now, go to "master default pivot" sheet, with one of the pivot tables, and
refresh it manually (right-click + refresh). If you go back to the "comparison"
sheet, you'll see that D3 and K3 did not change, but Y3 is now 0.99.
The initially shown data may be coming from some older version of the
spreadsheet, with data from previous runs (I've only replaced the raw data,
expecting the pivot tables and comparison to update itself).
I've noticed this on LO 5.2, but updating to 5.4 did not fix the issue.</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>