[Libreoffice-bugs] [Bug 112407] New: VIEWING: cells with formular referencing pivot tables contain stale / incorrect values until manual refresh

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112407

            Bug ID: 112407
           Summary: VIEWING: cells with formular referencing pivot tables
                    contain stale / incorrect values until manual refresh
           Product: LibreOffice
           Version: 5.4.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: tv at fuzzy.cz

Created attachment 136259
  --> https://bugs.documentfoundation.org/attachment.cgi?id=136259&action=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170915/c653298b/attachment.html>