Bug 82263

Summary: PIVOTTABLE: letter case modifications when extracting data from pivot table
Product: LibreOffice Reporter: David Sinquin <8.1david.51>
Component: CalcAssignee: m_a_riosv <miguelangelrv>
Status: RESOLVED WORKSFORME    
Severity: minor CC: jmadero.dev
Priority: medium    
Version: Inherited From OOo   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Exemple of problem with letter case in data extracts from pivot tables
Screenshot
Pivot Table Demonstration (Good)

Description David Sinquin 2014-08-06 20:05:30 UTC
Created attachment 104175 [details]
Exemple of problem with letter case in data extracts from pivot tables

When there are multiple lines in the data for a pivot table which differ only by letter case, extracting data from the pivot table gets data with the same case as the first row containing the same values.

A basic exemple can be produced creating a pivot table with this data :
"Data
a
A".
When creating a pivot table on this (with Data in the lines and Sum-Data (or anything else) in the data field) and double clicking on the (empty) cell for data sum, you should get this (surprising) result :
"Data
a
a".

I found this bug on Apache OpenOffice 4.0.1 on RHEL 6 x86-64 and I could reproduced it on LibreOffice 4.2.5.2 on Debian Jessie x86_64 but I did not test any other version of LO and AOO nor any other operating system.
I did not repport this bug to AOO yet.
Comment 1 m_a_riosv 2014-08-06 20:23:23 UTC
Created attachment 104177 [details]
Screenshot

Works for me with 4.2.6.1
Comment 2 Joel Madero 2014-09-04 09:30:44 UTC
Also can't confirm:

Bodhi Linux 2.x
LibreOffice 4.3.1.2

Attaching what I see and closing this as WFM. @David - please take a look at my pivot table - if you see that it's not right set the bug back to UNCONFIRMED and explain why. Thanks!
Comment 3 Joel Madero 2014-09-04 09:32:13 UTC
Created attachment 105730 [details]
Pivot Table Demonstration (Good)