https://bugs.documentfoundation.org/show_bug.cgi?id=162969
Eyal Rozenberg <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|enhancement |minor Depends on|162968 | --- Comment #5 from Eyal Rozenberg <[email protected]> --- (In reply to m_a_riosv from comment #3) > If I change the order for the 'Status' field, it is updated on the pivot > chart. Only if you use the PivotTable control for doing so, not if you sort the data, and probably not if you otherwise change the order. > PT has their own way to sort, so sorting out of the PT do nothing, because > nothing is changed in the PT, and nothing change for the PT-Chart. That could have been true, except that LibreOffice is willing to take a Data > Sort... request from within a PT - and moreover, selects the PivotTable, indicating that it recognizes the action: "Oh, you must want to change the PivotTable sort order; let us do that then". Now, you could say: I would rather the Sort command just fail outright for PTs. And that would at least guarantee consistent behavior and not confuse the user. However, it is not currently possible (correct me if I'm wrong) to sort the PT based on data columns; or to control a complex sort order at once (as opposed to setting the sort order separately for each column. So there is need/benefit for using the sort dialog - and it is better IMNSHO to make sure it behaves properly and the resort results propagate. Note that even though bug 162968 mentions rows and columns and data series, it's about something quite different; they are independent: Even if one could change the sort order, that does not mean one can have charts with row rather than column data series, and vice-versa. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=162968 [Bug 162968] When inserting PivotChart, can't choose data series in rows/columns -- You are receiving this mail because: You are the assignee for the bug.
