Bug 162966 - Ability to order pivot toable rows arbitrarily
Summary: Ability to order pivot toable rows arbitrarily
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table Sorting
  Show dependency treegraph
 
Reported: 2024-09-14 19:03 UTC by Eyal Rozenberg
Modified: 2024-09-27 09:39 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Eyal Rozenberg 2024-09-14 19:03:34 UTC
I would like to be able to set, myself and using row/cell dragging or a similar mechanism, the order of rows in my pivot table.

Motivation:

I have a pivot table of bugs: 

| status/resolution | count |
| DUPLICATE         |  7    |
| FIXED             | 36    |
| NEEDINFO          |  1    |
| NEW               | 62    |
| NOTABUG           |  3    |
| NOTOURBUG         |  0    |
| REOPENED          |  2    |
| UNCONFIRMED       | 15    |
| WONTFIX           |  1    |
| WORKSFORME        |  3    |

and I dislike both the ascending and descending order. I want to put "REOPENED" next to "NEW", "WONTFIX" next to "NOTOURBUG" etc. This ordering would be - as far as Calc is concerned - arbitrary. Also, I might change my mind while ordering.

Right now - I can't do that, except by copying the pivot table to a non-pivot-table. But the pivot table could "tolerate" my reordering - at least until the data changes so that new rows appear (and they could be inserted in whichever way, I don't mind).
Comment 1 Regina Henschel 2024-09-14 20:41:14 UTC
Not a drag solution, but flexible. Put the desired order as sort list into Tools > Options > Calc > Sort List. Then in the Pivot Table select "Custom Sort" from the sort rule drop-down list and in next step select your new created sort list.
Comment 2 Eyal Rozenberg 2024-09-14 20:51:59 UTC
(In reply to Regina Henschel from comment #1)
> Not a drag solution, but flexible. Put the desired order as sort list into
> Tools > Options > Calc > Sort List.

So, that is a workaround, but it's super kludgy... Tools > Options is for whole-app settings (except not really, but that's a bug); the user would not think of going there; one would need to go there repeatedly for every change in the sort order, with these changes decided on dynamically and gradually; and there may be a lot of elements in my pivot table, which I don't want to copy.
Comment 3 Regina Henschel 2024-09-14 21:36:00 UTC
(In reply to Eyal Rozenberg from comment #2)
> (In reply to Regina Henschel from comment #1)
> > Not a drag solution, but flexible. Put the desired order as sort list into
> > Tools > Options > Calc > Sort List.
> 
> So, that is a workaround, but it's super kludgy... Tools > Options is for
> whole-app settings (except not really, but that's a bug); ...

Of cause it is a only workaround. But if you need a different order now, its better to have a week workaround, then waiting until such feature is implemented in some years.

You want an option "manual sort order" in the drop-drown list, that allows when selected, to drag (or move by arrow key or other simple means) the values of the field to the desired order. Correct?
Comment 4 Eyal Rozenberg 2024-09-27 09:39:27 UTC
(In reply to Regina Henschel from comment #3)
> You want an option "manual sort order" in the drop-drown list, that allows
> when selected, to drag (or move by arrow key or other simple means) the
> values of the field to the desired order. Correct?

Something like that, yes. I'm not "bikeshedding" the specific for now: Dragging on the sheet itself, arranging in a dialog, support for row cut-and-pasting - any of those is already much better than now.