https://bugs.documentfoundation.org/show_bug.cgi?id=157226
Bug ID: 157226
Summary: PIVOTTABLE and Data > Sort function:some suggested
tweaks.
Product: LibreOffice
Version: 7.5.6.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: adrianlope...@hotmail.com
Description:
It comes to my attention that using the 'Data > Sort' function on the menu bar
when a cell within the pivot table area is selected will automatically cover
the whole pivot table. That means any further sorting modification will only
affect fields you are working with which is amazing. Nevertheless, I might
suggest to uncheck by default the 'include formats' option on the Option tab of
the Sort dialog as you may not want to mess with the design of the pivot table
at sorting. Also row/columns that contain total/subtotal labels should not be
rearranged when sorting pivot tables unless you manually do it so by dragging
and dropping them.
Steps to Reproduce:
1- Create a Pivot table
2- Select a table cell
3- Use Data > Sort funtion on the menu bar
4- Sorting
Actual Results:
- 'Include formats' option checked by default
- Sorting Total/subtotal labeled ranges
Expected Results:
- Unchecked 'include formats' option by default when working on a Pivot table.
- Sorting should not mess with Total/subtotal labeled ranges, only data fields.
Reproducible: Always
User Profile Reset: No
Additional Info:
No needed
--
You are receiving this mail because:
You are the assignee for the bug.
