https://bugs.documentfoundation.org/show_bug.cgi?id=154408
Bug ID: 154408
Summary: Changing manual sorting for a pivot table has no
effect
Product: LibreOffice
Version: 7.4.6.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a document with a pivot table. When I want to manually sort one of my
row fields by the data field containing the sum of values in the Data Field
Options dialog, changing this has no effect. Nothing happens and there is no
feedback. When I reopen the Data Field Options dialog for the row field, the
sorting option just reverted from manual back to the descinding, as if the
change never happened. This behavior is already described in bug #124012 from
2019, which also helped me find the workaround. I also included a screencast.
Steps to Reproduce:
1. Open the file I attached and navigate to the second tab with the pivot
table.
2. Open the pivot table's properties.
3. Double click the "Categorie" row field to open the "Data Field" dialog.
4. Choose "Options..." there to open the "Data Field Options" dialog.
5. By default sorting will be set to "Ascending".
6. Change this to "Manual" and sort with "Sum - Kosten" instead of the default
"Categorie".
7. Confirm this change several times so that all the option dialogs are closed.
8. Backtrack to the same "Data Field Options" dialog again and observe that the
sorting is back to "Ascending" and sorting with "Categorie" again, as if
nothing changed.
9. The workaround is to follow steps 1 to 6, but then change sorting to
"Descending" from "Manual". Sort by "Sum - Kosten" will still be active, but is
now greyed out. Then follow step 7 and observe that the change now does take
effect.
Actual Results:
Sorting doesn't change.
Expected Results:
Manual sorting by the sum of values should take effect.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.4.6.2
Build ID: 40(Build:2)
CPU threads: 12; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: nl-NL (en_US.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
