Apache OpenOffice (AOO) Bugzilla – Issue 118873
Double-click on datapilot (pivot table) cell with grouping does not filter results
Last modified: 2012-02-05 21:59:37 UTC
Created attachment 77186 [details] Double-click on the number 4 to see a wrong record list The attached spreadsheet contains a simple table with: City - Continent - Population in millions and a datapilot (pivot table) created from it, with grouping, to show how many cities in each population range exists in each continent (e.g., how many cities between 18 and 20 million inhabitants exist in Asia). Expected behavior: Double-clicking on a cell should reveal the list of matching data: i.e., clicking on the number "4" in column "Asia" and row "18-20" I should see the 4 cities in Asia with population 18-20 millions. Actual behavior: Double-clicking on the number "4" in column "Asia" and row "18-20" I see the list of all cities in Asia, not only the 4 cities in Asia with population 18-20 millions. Related documentation: http://wiki.services.openoffice.org/wiki/Calc/Features/DataPilot_drill-down_on_data_field and bug 57030 (fixed; the problem here might be related to grouping, since it works with grouping disabled). (Reported by Francesco Forti on the Italian QA mailing list)