[Libreoffice-bugs] [Bug 117924] Pivot Tables Sort Only on First Row or Column, and only after created
https://bugs.documentfoundation.org/show_bug.cgi?id=117924 --- Comment #5 from m.a.riosv --- (In reply to Jim Davis from comment #4) > 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. > Not true. Drag the fields for their title to get the desire order. > 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. > Not true. It is for select the field's order not to sort the whole pt. > These two corrections would keep people from wasting time experimenting with > presented options that are not intended to be functional. > Or you don't want to understand/accept how it works, because it's not what you like. > 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". Yes their is no other way than to rearrange columns, and sort every field. Sorting in the order col2-col3-col1, whit columns in pt positioned as col1,col2,col3, at least looks a few awkward. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 117924] Pivot Tables Sort Only on First Row or Column, and only after created
https://bugs.documentfoundation.org/show_bug.cgi?id=117924 Adolfo Jayme changed: What|Removed |Added Status|VERIFIED|RESOLVED Resolution|WONTFIX |WORKSFORME -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 117924] Pivot Tables Sort Only on First Row or Column, and only after created
https://bugs.documentfoundation.org/show_bug.cgi?id=117924 --- Comment #3 from Jim Davis --- Created attachment 142463 --> https://bugs.documentfoundation.org/attachment.cgi?id=142463=edit pivot table as desired-with broken col/row two sort -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 117924] Pivot Tables Sort Only on First Row or Column, and only after created
https://bugs.documentfoundation.org/show_bug.cgi?id=117924 Jim Davis changed: What|Removed |Added Status|RESOLVED|VERIFIED Resolution|NOTABUG |WONTFIX --- Comment #4 from Jim Davis --- 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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 117924] Pivot Tables Sort Only on First Row or Column, and only after created
https://bugs.documentfoundation.org/show_bug.cgi?id=117924 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 117924] Pivot Tables Sort Only on First Row or Column, and only after created
https://bugs.documentfoundation.org/show_bug.cgi?id=117924 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #2 from m.a.riosv --- Created attachment 142462 --> https://bugs.documentfoundation.org/attachment.cgi?id=142462=edit Sample modified to show how to sort works. Works for me. But I think something is missing here. If you want to sort by the third column, move it to be the first column. Otherwise the sort in menu field, sort the field without change the order of previous columns only sort if the field has several values for the field of column before. On your sample file modified, change the sort order of the second column, and you can see how it works. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 117924] Pivot Tables Sort Only on First Row or Column, and only after created
https://bugs.documentfoundation.org/show_bug.cgi?id=117924 --- Comment #1 from Jim Davis --- Created attachment 142431 --> https://bugs.documentfoundation.org/attachment.cgi?id=142431=edit A pivot table in a spreadsheet (typical, I presume) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs