Hi,
I have created a data pilot for a range on another page.
For some reasons (check if all source data is still included in the pilot, adding rows and or columns) I want to check and maybe modify the data source of the pilot.
Where/How can I see/modify the source of a data pilot?
Thanks
Change Range of Data Source of a Data Pilot
Change Range of Data Source of a Data Pilot
OpenOffice 3.1.1 / Windows 7 (64bit)
Re: Change Range of Data Source of a Data Pilot
You can't. But scenarios offer a more elegant solution. trigonometricScenarios.ods
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Change Range of Data Source of a Data Pilot
There are two options to do this:
-Update to 3.2, lets to change the source range.
-Install the extension: DataPilotTools, this lets change the source range and recalculate all datapilots in the file at same time.
-Update to 3.2, lets to change the source range.
-Install the extension: DataPilotTools, this lets change the source range and recalculate all datapilots in the file at same time.
LibreOffice 3.5.4 AOo-3.4 on Win 7 Ultimate