I compare LibO 3.3.0 with OOo 3.2.1 First: I don't like that by default a Pivot table is made on a new sheet. It should be on the sheet with the data. Second: When I am working on Sheet2 (Dutch: Blad2) and want to make a Pivot table and choose for: Results to -Not defined- (Dutch: Resultaten naar -Niet gedefineerd-) and then write for instance cell F1 (without mentioning the sheet) the Pivot table is not made on Sheet2 but on Sheet1 starting in cell F1. I would expect that without mentioning the sheet, the pivot table is made on the sheet one is working on.
thanks for writing the issue Joop. wrt First: this behavour differs from that in OOo wrt Second: that is the same in OOo and LibO Assigned to Kohei.
The first change is intended, as the majority of cases it's more intuitive to create a table in a new sheet. The second change is due to the fact that the field expects a full absolute reference including the sheet name ($Sheet.$A$1). So a relative reference such as F1 without the sheet name the sheet defaults to the first sheet in the document.
I'll look into the second case to see if we can default to the current sheet, in case the sheet name is not explicitly given.
Thank you for providing me with this information. I think it is more intuitive to put the pivot table on the current sheet when no sheet name is given. I took me some time to find out that in a big document with several sheets, my pivot table for the data on sheet 10 had been made on sheet 1. I first thought that there was a bug and that no pivot table had been made at all (and returned to OOo 3.2.1 to make one). Later working in another document, I got the warning that the pivot table that I wanted to make would overwrite data and that was impossible since the cells I selected for the pivot table were all empty. Maybe is best that when -not defined- is chosen, the name of the current sheet is already in the box and that the cell where the pivot table must start can be added. Regards, Joop 2011/2/11 <bugzilla-daemon@freedesktop.org> > > https://bugs.freedesktop.org/show_bug.cgi?id=34107 > > --- Comment #3 from Kohei Yoshida <kyoshida@novell.com> 2011-02-11 08:10:33 PST --- > I'll look into the second case to see if we can default to the current sheet, > in case the sheet name is not explicitly given. > > -- > Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email > ------- You are receiving this mail because: ------- > You reported the bug.
Hello Joop, *, I stumbled upon this issue during my manual test of LO 3.4.0beta3 ... ;) Additionally to your information I found out, that – if you create a pivot table and choose "New table" – DataPilot does not create a new table (which I would expext), but replaces the current table sheet ... :( Tested with Debian Testing AMD64, LO 3.4.0beta3 (with Germanophone lang- as well as helppack) ... HTH Thomas.
This is old report and I do not see how it is valid. Default option is new sheet, but in "Source and Destination" we may change to "Selection". We need to select or type the cell. This idea to "put pivot table on current sheet" when Selection is clicked would be an enhancement ,if we would know where. In which cell? We already have data selected, so not in the current cell. Seems to me this should be closed.