Bug 123638 - Pivot Refresh to be included in the Recalculate Hard(CTRL+SHIFT+F9)
Summary: Pivot Refresh to be included in the Recalculate Hard(CTRL+SHIFT+F9)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency tree / graph
 
Reported: 2019-02-22 04:55 UTC by perie_gut
Modified: 2019-10-14 17:30 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
sample (14.84 KB, application/x-zip-compressed)
2019-02-22 04:55 UTC, perie_gut 		Details
file with two pivot tables (9.04 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-02-22 18:18 UTC, raal 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description perie_gut 2019-02-22 04:55:47 UTC 
Created attachment 149502 [details]
sample

I have a Base connected in my Calc via Multiple Pivot Tables and it is too taxing updating each pivot tables. Is it possible to include the "Refresh" of all pivot tables on the Recalculated Hard process.



Version: 6.2.0.3 (x64)
Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-PH (en_PH); UI-Language: en-US
Calc: threaded
Comment 1 raal 2019-02-22 18:17:51 UTC 
Is it really regression? It worked in previous version?

I think it's valid enhancement. Now it's not possible refresh all pivot tables in one run. Similar bug 61793 PIVOTTABLE: Enhancement request: auto refresh pivot table after changes in source - but it won't work for connection to external database, so we need still some trigger for refresh all pivots.
Comment 2 raal 2019-02-22 18:18:23 UTC 
Created attachment 149535 [details]
file with two pivot tables
Comment 3 Oliver Brinzing 2019-02-23 10:00:28 UTC 
(In reply to raal from comment #1)
>but it won't work for connection to external database

are you sure this works with internal data?
if i open your "file with two pivot tables", change data on "Sheet1"
and do a hard recalc, the pivot table will not update.

seems every pivot table needs a refresh via menu 
"Data/Pivot Table/Refresh" or sometihng like:

oDoc = ThisComponent
oDoc.calculateAll()
For i = 0 To oDoc.getSheets().getCount()-1
  oDataPilotTables = oDoc.getSheets().getByIndex(i).getDataPilotTables()
  For j = 0 To oDataPilotTables.getCount()-1
   oDataPilotTables.getByIndex(j).refresh()
  Next j
Next i
Comment 4 raal 2019-02-23 13:23:17 UTC 
(In reply to Oliver Brinzing from comment #3)
> (In reply to raal from comment #1)
> >but it won't work for connection to external database
> 
> are you sure this works with internal data?
No, it don't work. For internal data we have bug 61793.