Bug 133173 - Calc creates a wrong result when I use "Drill to details" option in Pivot table
Summary: Calc creates a wrong result when I use "Drill to details" option in Pivot table
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2020-05-19 14:03 UTC by Roman Kuznetsov
Modified: 2023-04-19 14:33 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
File with Pivot table (31.89 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-05-19 14:03 UTC, Roman Kuznetsov
Details
Comparize results in Calc and Excel (192.61 KB, image/png)
2020-05-19 14:04 UTC, Roman Kuznetsov
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2020-05-19 14:03:06 UTC
Description:
Calc creates a wrong result when I use "Drill to details" option in Pivot table.

Steps to Reproduce:
1. Open file from attach
2. Make sure that Pivot tables's "Enable drill to details" option is enabled 
3. Double click on D8 cell (intersection of "томат"  and "Маша" with 233760 value)
4. Calc creates a new sheet with details for "томат" and ALL people instead for "томат" and "Маша" only

I checked that behavior in Excel with the same file. And I got a correct data on a new sheet only for "томат" and "Маша" only

Actual Results:
Calc creates a wrong result for "Drill to details" option in Pivot table

Expected Results:
Calc creates a correct result for "Drill to details" option in Pivot table


Reproducible: Always


User Profile Reset: No



Additional Info:
I checked it down to 4.1 version
Comment 1 Roman Kuznetsov 2020-05-19 14:03:35 UTC
Created attachment 161007 [details]
File with Pivot table
Comment 2 Roman Kuznetsov 2020-05-19 14:04:28 UTC
Created attachment 161008 [details]
Comparize results in Calc and Excel
Comment 3 Telesto 2020-05-19 19:01:21 UTC
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 4 QA Administrators 2022-10-09 03:49:45 UTC Comment hidden (obsolete)
Comment 5 Roman Kuznetsov 2022-10-16 10:55:52 UTC
Still repro in

Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 5a1f41a0d3aab15c113651f2edc9d4137ae99063
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: threaded