[Libreoffice-bugs] [Bug 123638] Pivot Refresh to be included in the Recalculate Hard(CTRL+SHIFT+F9)

[bugzilla-daemon at bugs.documentfoundation.org]

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

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oliver.brinzing at gmx.de

--- Comment #3 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
(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

-- 
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/20190223/cec0aa95/attachment.html>