This is the problem:
- enter some numbers into cells A1:A5
- go into C1 and enter
- and then try to make click on the "A" in the column header, which you can't but which used to be possible.
This is quite annoying because it means if you want to add more values into A6:A10 and have the sum in C1 updated, you must enter a specific larger range into C1 - you can't just specify 'the whole column however far down it is', which would be the intuitive thing to do.
Even more counterintuitively: if you create a Pivot table by
- highlighting multiple columns by clicking on the column headers
- then clicking: Data: Pivot Table: Create
then the Select Source window says "Highlight Selection", which is after all the whole column, but then the Pivot table data range in the next window is really only until the bottommost data point (say, C22) so when you add new data and refresh the Pivot Table, new stuff one may have entered is not included even though I created the Pivot table from the selection, which was the whole column.
Hi kaesezeh, thanks for reporting.
It is how it works, not a bug.
If you like it will be implemented change the importance from normal to enhancement, and change the title in accordance. If you do so I will change the status to new.
I am not sure I understand how this is not a bug. The user tell Calc to use a particular range for a Pivot table, which happens to be range involving whole columns, but Calc doesn't use that range but downsizes it on its own - how is that not a bug?
Maybe I am in an error, but I think it is designed to work in this way.
I agree that it is designed to work that way, but the design is faulty: if the user specifies a range when setting up the pivot table, then the user wants THAT range to be used -- he does not want Calc ignoring the user's range selection and generate one on its own (without even so much as a warning, mind you) that is hundreds of thousands of cells smaller!
Maybe a bug for you but not for others.
And I think it is possible to modify and set up the range editing the PT layout.
Hello Kaesezeh, I guess what you wanted has been requested in Bug 44419. Please mark this as duplicate if you think so.
*** This bug has been marked as a duplicate of bug 44419 ***