Bug 152345

Summary: Pivot table - visual FORMATTING mistake after sorting by descending order
Product: LibreOffice Reporter: devilfelix
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: trivial CC: miguelangelrv
Priority: medium    
Version: 7.4.2.3 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: output sample
Excel file attached
ODS file attached

Description devilfelix 2022-12-01 17:03:10 UTC 
Description:
after a pivot table is created, and the user wants to sort the values ascending or descending, the table shape does not adjust the visuals, the frame/borders sort as well with the cells, and there fore its not good looking visually. its a cosmetic problem.

Steps to Reproduce:
1.put data and create a pivot table
2.try to order the values in descending order
3.see the frame and borders for the cells and the table.

Actual Results:
table loss the entire formatting/borders setup, while the cells mantains it and therefore are affected by the sorting operation,

Expected Results:
table formatting should keep the borders setup after sorting operation


Reproducible: Always


User Profile Reset: No

Additional Info:
no other info, please feel free to email me back and i can attach a picture
Comment 1 devilfelix 2022-12-01 17:07:03 UTC 
Created attachment 183945 [details]
output sample
Comment 2 m_a_riosv 2022-12-02 01:52:46 UTC 
Please attach a sample file, and details how do you sort?
Comment 3 devilfelix 2022-12-02 08:38:40 UTC 
see attachment: 

https://bug-attachments.documentfoundation.org/attachment.cgi?id=183945
Comment 4 m_a_riosv 2022-12-02 15:28:46 UTC 
An image serves for nothing to reproduce the reported issue.

Please attach an ods sample file, an explain step by step how you do the sort.
Comment 5 devilfelix 2022-12-05 16:48:19 UTC 
Created attachment 184000 [details]
Excel file attached
Comment 6 devilfelix 2022-12-05 16:50:41 UTC 
Created attachment 184001 [details]
ODS file attached
Comment 7 m_a_riosv 2022-12-06 15:53:09 UTC 
I guess you are trying to sort with the general sort of calc, not with the pivot table properties.

Maybe it doesn't work exactly the same in calc and excel, because calc always restart the format of the PT every time it is updated.

But you have an option to update the PT based on result.
While in PT, Right-click - Properties - Double-click on Row field 'Description' - Options - Sort by 'Sum Amount' - Descending - Ok - Ok - Ok.
Comment 8 devilfelix 2022-12-08 20:52:29 UTC 
Got it, this is indeed the answer to the problem

HOWEVER...its too complex, too many steps, go inside this, that, clic, etc.
it should be more agile, simpler.

hope you can incorporate the feedback into the dev discussions.


many thanks for all the support.
Comment 9 m_a_riosv 2022-12-08 22:15:29 UTC 
Then please do a new report as enhancement, explain in it how do you expect it can work.