https://bugs.documentfoundation.org/show_bug.cgi?id=123638
Oliver Brinzing <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #3 from Oliver Brinzing <[email protected]> ---
(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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
