[Libreoffice-bugs] [Bug 49095] New: Pivot Table sort drop down shows inappropriate options

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=49095

             Bug #: 49095
           Summary: Pivot Table sort drop down shows inappropriate options
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.5.2 Release
          Platform: All
        OS/Version: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: pharmankur at gmail.com


Created attachment 60512
  --> https://bugs.freedesktop.org/attachment.cgi?id=60512
on 1st sheet data is created, On 2nd sheet pivot table is present

When a pivot table have multiple levels of data, selecting the Higher level of
data should show appropriate & applicable options only, while selecting lower
(dependent) level of data

Find attached the spreadsheet file with pivot data to understand my point.

There I have created a dummy data for a department store. having headings -->

Counter Position    Item Type    Item Name    Qty

Possible 'Counter Position' are --> Main , Display , Inside
Possible 'Item Type' are --> Fruit, stationary, Vegetable, Crockery

Possible 'Counter Position' wise 'Item Types' are;
Main --> Fruit, stationary, Vegetable
Display --> stationary, Vegetable, Crockery
Inside --> stationary, Crockery

----------------------------------------------------------------------
(What should happen --)
Now, When I make the pivot table of this data & when I first select Counter
Position -- "Main" (From drop down box) ; & then I move further to select Item
Type (drop down box) ; I should see only the 'Item Type' options possible with
my previous selection ("Main") i.e. I should see only the options (In drop down
box) "Fruit, stationary, Vegetable" 

(What is happening --)
On the contrary currently I am seeing all the options (In drop down box) ...
Fruit, stationary, Vegetable, Crockery
But "Crockery" is non applicable option under "Main" thus should not be visible
in drop down. 

As a result, if by mistake I select option "Crockery" & deselect all other
options (under "Main") All of my Pivot table collapses & it is not recovered !
-----------------------------------------------------------------------

Even in pivot table in office 2007, you get to see only applicable options
based on your preselected option.
The bug is not very annoying but definitely its illogical & has to be removed
if we want perfection in Calc.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.