Edit a DataPilot table

Discuss the spreadsheet application

Edit a DataPilot table

Postby swoop » Tue Jan 15, 2008 1:05 pm

Hi

I'm new to DataPilot and I'm trying to edit an already existing table.

My problem is no matter how I'm trying to edit the table I only get a new wizard. According to the chapter 6 in the Calc guide it should be possible by either:

- right click on a cell and select Start or
- select a cell and select Data / DataPilot / Start

Both ways give me a clean DataPilot wizard and not the current layout I expected.

Any help is very much appreciated.
swoop
 
Posts: 3
Joined: Tue Jan 15, 2008 12:59 pm
Location: Denmark

Re: Edit a DataPilot table

Postby Villeroy » Tue Jan 15, 2008 11:44 pm

Select any cell in the pilot (not in the source table) and call "Refresh" from the context-menu or from Menu:Data>Pilot>Refresh
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28851
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Edit a DataPilot table

Postby swoop » Wed Jan 16, 2008 3:15 pm

Thanks a lot for your reply.

Unfortunately your suggestion doesn't give me the opportunity to modify my pilot. In fact if I choose the refresh command it clears my pilot completely and only shows me: (empty)
swoop
 
Posts: 3
Joined: Tue Jan 15, 2008 12:59 pm
Location: Denmark

Re: Edit a DataPilot table

Postby Villeroy » Wed Jan 16, 2008 5:23 pm

You removed the data from where you derived the pilot? A pilot is a representation of another table. You edit the other table and refresh the pilot, so it reflects the changes in the source table. Editing a pilot makes no sence since it is ther result of another table. You would not want to change the result of =SUM(A1:A10) and when you remove or clear A1:A10 SUM(A1:A10) will not work anymore.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28851
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Edit a DataPilot table

Postby swoop » Fri Jan 18, 2008 10:22 am

I haven't made any changes / removal are done to the data in the source table.
swoop
 
Posts: 3
Joined: Tue Jan 15, 2008 12:59 pm
Location: Denmark

Re: Edit a DataPilot table

Postby Villeroy » Fri Jan 18, 2008 11:17 am

Please upload the file.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28851
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 29 guests