[Solved] Autorefresh plus formatting of pivot report

[gkick]

Hi all,

This should be in Calc, but no idea in which subforum to post this.

My reportmenu in base has a button which calls up a calc file containing a linked pivot amongst other stuff.
Is it possible to first do a autorefresh and then apply a standard format since the refresh kills the original format.
If so in calc would one do that with recording a macro ?

Thanks

[Villeroy]

Pivot table number formats are broken when data come from database queries. No way to configure anything.
Anything else (font, size, color) can be configured through styles.

I use this with my report spreadsheet to refresh all database ranges and all pivot tables.:

Code: Select all

Sub Main
	for each dbr in ThisComponent.DatabaseRanges
		dbr.refresh()
	next dbr
	for each sh in ThisComponent.getSheets()
		for each dp in sh.DataPilotTables
			dp.refresh()
		next dp
	next sh
End Sub

[gkick]

Thank you, oh well at least we have a pivot. Very interesting, hardly any of the heavy duty dbs seem to support pivots, exception being H2 (not sure if that one is heavy duty though.