[Libreoffice-bugs] [Bug 117924] Pivot Tables Sort Only on First Row or Column, and only after created

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=117924

Jim Davis <jd4x4 at jd4x4.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |VERIFIED
         Resolution|NOTABUG                     |WONTFIX

--- Comment #4 from Jim Davis <jd4x4 at jd4x4.net> ---
If the only sort available after the table is created is to the first column or
row then you should only show the sort option in the dropdown for the first row
or column. 

Additionally, you should remove the sort options from the data field options in
the pivot table layout dialog since it is "expected" that sorts are only
possible on the first row and/or column.

These two corrections would keep people from wasting time experimenting with 
presented options that are not intended to be functional.

It "worksforme" with YOU because you have rearranged the columns. The sample I
attached is in fact not the desired layout, but rather a workaround because
sorts are only possible on the first columns and/or rows. 

The desired table result is as shown in the additional attachment BUT SORTED BY
COLUMN TWO AND ROW TWO. The "Matrix to 3C" sheet is the copy, paste, sort, and
reformat that is required because of the sort limitation, so I'm well aware of
the problem and unfortunate workaround that you say "worksforme".

Anything less requires a "workaround" and unnecessary time spent. 

I sense that you won't acknowledge it as a "bug" so I'll change this report to
"VERIFIED", "WONTFIX".

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180601/89f247f3/attachment.html>