1. Create a pivot table from an internal sheet source range via a defined name. Create it on a new sheet.
2. Move the sheet that has the pivot table on it.
That's all. After the relocation, open the pivot table layout dialog and check its data source, sometimes the range name becomes a raw range reference that the name refers to, and other times it points to the wrong sheet, thereby destroying the layout info completely.
We need to fix this.
I'll fix it.
I should fix this for 3.5.
To reproduce, have a document that has
* source data in sheet 1 and have a name created for the source data.
* empty sheet 2,
* pivot table created from the name as source data.
At this point, the main pivot table dialog shows the name as the source data.
Now, delete the empty sheet 2. Now, when you open the main pivot table dialog, the source data name is replaced with the raw range.
Ok. The range name source issue is now resolved.
Now, a slightly more subtle problem. Calc currently doesn't update the range of the data cache when modifying the sheet structure. I'm looking into that now.
Ok. Now the pivot caches for the internal sheet ranges get properly updated when they move.
On the surface the users won't notice a change by this, but the memory usage will be reduced since we properly keep track of the caches' locations.