Created attachment 92772 [details] Sample file with 4 PT, 3 from the same data, 1 from a second data. Steps to reproduce: Open attached file. 3 PTs in: Sheet1.D1 Sheet1.D16 Pivot Table_Sheet1_1.A1 have the same data source in Sheet1.A1:B7 the PT in: Sheet1.K1 have their data source in Sheet1.H1:I7 Go to Sheet1.D4 F12 or Menu/Data/Group/Group. Select Month for group and Ok. grouping is applied to the three first PTs, not for the fourth. Ctrl+F12 to ungroup. ungrouping is applied to the three first PTs. Go to Sheet1.K4 F12. Select Month for group and Ok. grouping is applied only to this PT, not for the rest. Ctrl+F12 to ungroup. Ungrouping is applied only to this PTs. The bug: The group is applied to all PTs with the same data source in the same field even if the field name have been changed, or the PT is in other sheet. Win7x64Ultimate. Versión: 3.6.7.2 (ID de compilación: e183d5b) Version: 4.0.6.2 (Build ID: 2e2573268451a50806fcd60ae2d9fe01dd0ce24) Version: 4.1.6.0.0+ Build ID: 873be8f3ff28fd06b531b17d2c7cc41cbc1385e Version: 4.2.0.3 Build ID: c63c03decdf780d8fb80823950665b782ec9ecd0 Version: 4.2.1.0.0+ Build ID: 23221e48495262d0384c9169a0d8a01db8a5dab5 Version: 4.3.0.0.alpha0+ Build ID: 77637324abc193d831bb4a0fa6f9a91ef3601960 TinderBox: Win-x86@39, Branch:master, Time: 2014-01-22_16:19:04 regression from: LibreOffice 3.5.7.2 Build ID: 3215f89-f603614-ab984f2-7348103-1225a5b
I confirm the behavior in 4.2.0.3 on Ubuntu
Still reproducible. Version: 4.3.0.0.alpha0+ Build ID: 12ae7672f285da1d4c730315e8db23b3396b71cc TinderBox: Win-x86@39, Branch:master, Time: 2014-03-14_00:18:00
3.6.0.1 has the bug, changing version field accordingly.
BTW, the group data is stored in the pivot cache itself, so if multiple pivot tables share the same data source i.e. linked to the same pivot cache backend, they do share the group fields. So this is by design. Previous versions didn't do it, which was incorrect and caused all sorts of issues because the pivot tables were out of sync with the cache.
Created attachment 107859 [details] Sample file with several named ranges on the same source range. I don't hesitate it must be so, but changes of behavior are always a source of confusion. In any way, an easy workaround/solution seems to be, that there is no problem using named ranges (different named ranges on the same source range) for every PT. Please @Kohei could you confirm that using named ranges, is a right solution? Maybe would not hurt, add a comment in the help.
Using named ranges and assign different names to the same source will work, for now. Though unfortunately I cannot give you a guarantee that it will continue to work in the future. I would have to check on how Excel's file format handles pivot cache data for different named ranges referencing the same source.
Ah, good news. Excel stores different pivot caches for different named ranges even when they share the same source. So, we can expect that to work for Calc too.
So, let me close this as a not-a-bug, because it is not a bug. :-)
*** Bug 91173 has been marked as a duplicate of this bug. ***
*** Bug 91165 has been marked as a duplicate of this bug. ***