Bug 114120 - PIVOT TABLE : dimension bug
Summary: PIVOT TABLE : dimension bug
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2017-11-28 15:46 UTC by rking
Modified: 2024-02-04 07:14 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
datasheet that exhibit the bug (64.59 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-11-28 16:01 UTC, rking
Details

Note You need to log in before you can comment on or make changes to this bug.
Description rking 2017-11-28 15:46:35 UTC
Description:
Pivot table usage
When the pivot table is create on a set of data.
the selection of a particular field in the pivot table doesn't produce the 
right output.

Steps to Reproduce:
1.Launch libre office on windows
(enable drill to details)
2.open the given sheet in french
3.select the pivot table 
4.double click on the cellule B19 or C19

Actual Results:  
creates a sheet that contains two rows that doesn't respect the filtering of the fields 

Expected Results:
should generate only one row as a result


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0
Comment 1 rking 2017-11-28 16:01:22 UTC
Created attachment 138044 [details]
datasheet that exhibit the bug
Comment 2 Xisco Faulí 2017-12-01 12:15:50 UTC
Hi rking,
Do you plan to work on this issue?
Is it also reproduced in master?
Have you checked if the issue has been already reported in another ticket ?
Comment 3 Xisco Faulí 2018-03-02 09:18:32 UTC
Dear rking,
This bug has been in ASSIGNED status for more than 3 months without any
activity. Resetting it to NEW.
Please assigned it back to yourself if you're still working on this.
Comment 4 Xisco Faulí 2018-03-02 09:19:03 UTC
Also reproduced in

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Comment 5 rking 2018-03-02 09:55:13 UTC
I'm still working on it.
Comment 6 Xisco Faulí 2018-03-02 09:56:39 UTC
Ok, glad to hear.
Setting version to the earliest one...
Comment 7 Kevin Suo 2020-09-05 04:54:59 UTC
rking: Are you still working to fix this issue by yourself?
Comment 8 Arnaud Versini 2023-11-25 16:51:24 UTC
Support from Linagora is gone for à white, setting to new again
Comment 9 Dhiraj Holden 2024-02-03 17:24:08 UTC
Still present in:

Version: 7.4.7.2 (x64) / LibreOffice Community
Build ID: 723314e595e8007d3cf785c16538505a1c878ca5
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 10 Dhiraj Holden 2024-02-04 07:14:30 UTC
From what I can tell, the problem is that the "Data" column field is the first column field and not "methode". A similar thing happens if "Data" is moved to the first row field. I am not sure what the intended behavior is here.