Issue 118873

Summary:

Double-click on datapilot (pivot table) cell with grouping does not filter results

Product:

Calc

Reporter:

Andrea Pescetti <pescetti>

Component:

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Normal

Priority:

Version:

3.4.0 Beta (OOo)

Target Milestone:

---

Hardware:

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Double-click on the number 4 to see a wrong record list	none

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)