DataPilot Tables - Basic Macro - DataPilotField service - how to set running totals function?

asked 2015-01-15 16:46:01 +0200

Tomek gravatar image

Hi!

I'm using LO v3.5.4.2 under Debian Wheezy. I've written a Basic macro, which creates Pivot Table (Calc). I can manually set "Running total in" as a displayed value of Data Fields part (Edit Layout -> any element of Data Fields -> click Options). Automatically I can set a Function only (by using Function=com.sun.star.sheet.GeneralFunction.COUNT property of DataPilotField service/object). Is there a way to set it programmatically instead of manually?

Regards, Tom

edit retag flag offensive close merge delete