Bug 98947 - PIVOTTABLE: Drilling after sorting returns unsorted "drill" results
Summary: PIVOTTABLE: Drilling after sorting returns unsorted "drill" results
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.3 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2016-03-29 05:07 UTC by datakid
Modified: 2022-10-10 04:04 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Sort this by postcode count descending, then drill on the top number. (63.57 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-03-29 05:07 UTC, datakid
Details

Note You need to log in before you can comment on or make changes to this bug.
Description datakid 2016-03-29 05:07:08 UTC
Created attachment 123910 [details]
Sort this by postcode count descending, then drill on the top number.

If you do a simple PIVOTTABLE with a list of indices and a count (for eg) and then sort the count (either direction) and then drill into, for eg, the one with the greatest count, you will get the result for a different field. 

Initially the results I was seeing in the drill down were for the unsorted indices, but now I see random results.
Comment 1 raal 2016-03-29 09:19:32 UTC
I can confirm with Version 4.0.0.3 and 5.2Master; windows
Comment 2 QA Administrators 2017-05-22 13:20:31 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2019-12-03 14:59:53 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2022-10-09 03:50:34 UTC Comment hidden (obsolete)
Comment 5 datakid 2022-10-10 02:23:33 UTC
Sorry, I didn't properly test, but I have now, and can confirm that the issue remains:

Version: 7.4.1.2 (x64) / LibreOffice Community
Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0
CPU threads: 8; OS: Windows 10.0 Build 22623; UI render: Skia/Raster; VCL: win
Locale: en-AU (en_AU); UI: en-US
Calc: threaded