Issue 118873 - Double-click on datapilot (pivot table) cell with grouping does not filter results
Summary: Double-click on datapilot (pivot table) cell with grouping does not filter re...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 3.4.0 Beta (OOo)
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-02-05 21:59 UTC by Andrea Pescetti
Modified: 2012-02-05 21:59 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Double-click on the number 4 to see a wrong record list (10.75 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-02-05 21:59 UTC, Andrea Pescetti 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Andrea Pescetti 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)