Bug 112138 - in a pivot table if i order for total field also the name of field are sorted
Summary: in a pivot table if i order for total field also the name of field are sorted
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-08-31 09:53 UTC by danterosati
Modified: 2017-09-01 13:55 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
layout pivot no sort option (25.34 KB, image/png)
2017-09-01 09:06 UTC, danterosati 		Details
example data with pivot (14.49 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-09-01 09:11 UTC, danterosati 		Details
Screenshot editing field sort (102.92 KB, image/png)
2017-09-01 10:55 UTC, m_a_riosv 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description danterosati 2017-08-31 09:53:08 UTC 
Description:
Created a pivot and move in total cell, after select a cell in total column and order ascending, the pivot is ordered but also the name of field has been moved and sorted, this is wrong this is a bug.

Steps to Reproduce:
1.create a pivot
2.select any cell data in total column
3.clic order ascending
4.bad result cause also title and category has been sorted and moved

Actual Results:  
1.create a pivot
2.select any cell data in total column
3.clic order ascending
4.bad result cause also title and category has been sorted and moved

Expected Results:
bad result cause also title and category has been sorted and moved


Reproducible: Always

User Profile Reset: yes

Additional Info:
tested in 5.4.0.3 and 5.3.3.2


User-Agent: Mozilla/5.0 (Windows NT 10.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36 Edge/15.15063
Comment 1 m_a_riosv 2017-08-31 21:18:16 UTC 
I thinke here are a mistake, using Menu/Data/Sort option, or the Icons on a Pivot table sorts data as any other cells.

Pivot table sorts are done editing layout and then editing fields options.

To edit by a data field, edit a row or column field and in their options select Sort by Ascending or Descending, now you can select the field for sort.

Resolved as not a bug, please if you are not agree, reopen it.
Comment 2 danterosati 2017-09-01 09:06:38 UTC 
Created attachment 135923 [details]
layout pivot no sort option

i don't find sort option in layout
Comment 3 danterosati 2017-09-01 09:11:29 UTC 
Created attachment 135924 [details]
example data with pivot

if you are able order data for total column H leaving field in the first row, in other if is possible give me a link to see how order for total column
Comment 4 m_a_riosv 2017-09-01 10:55:22 UTC 
Created attachment 135925 [details]
Screenshot editing field sort

Double click on 'Product' field, Options/Sort By
Comment 5 danterosati 2017-09-01 13:40:28 UTC 
THANK YOUUUU, so difficult to find but now ok.

in excel is only one click,in pivot table after you select a cell of total column you can click on sort descending and you receive a sorted pivot in other when the data will be updated the order remain.

In this mode LO is similar old spreadsheet and i'd like have speed sort option as excel.

Do you know in ver 6.0 will be this speed function?

After info i close the status
Comment 6 m_a_riosv 2017-09-01 13:55:19 UTC 
I think not.
Thanks for feedback. I you like create a new bug report as enhancement about it.