Bug 140509 - Pivot table changes the case (upper/lower) of the PivotTable sheet from the original sheet
Summary: Pivot table changes the case (upper/lower) of the PivotTable sheet from the o...
Status: RESOLVED DUPLICATE of bug 140510
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
5.4.7.2 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-02-18 15:08 UTC by Kana Masai
Modified: 2021-02-18 15:58 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Kana Masai 2021-02-18 15:08:12 UTC
Description:
1) Pivot table function replaced the case (upper/lower) of the original cell data.
2) Pivot table function took the first value of the original data and replaced it with all subsequent data which was similar (ignoring case sensitivity).

Steps to Reproduce:
1.Fill in 2 columns of data (my example is provided below) into LibreOffice-CALC

Num	Values
X1	aaabbb123
X2	aaabbB123
X3	aaabBB123
X4	aaaBBB123
X5	aaABBB123
X6	aAABBB123

2. Select cells A1:B7
3. Insert > Pivot Table
4. Selection = Current Selection
5. Select the available fields (Num, Values) into Row Fields

The Pivot table is now created.
The results are as displayed in Actual Results (below) 

Actual Results:
Below is the actual result. The Pivot Table has changed the case of the original data. My values are case-sensitive; 
thus aaabbb123 ≠ aaabbB123 ≠ aaabBB123 ≠ aaaBBB123  ... etc

=================
Num	Values
X1	aaabbb123	
X2	aaabbb123	
X3	aaabbb123	
X4	aaabbb123	
X5	aaabbb123	
X6	aaabbb123	
	


Expected Results:
The expected result ( should be the same as the original data)

Num	Values
X1	aaabbb123
X2	aaabbB123
X3	aaabBB123
X4	aaaBBB123
X5	aaABBB123
X6	aAABBB123

My values are case-sensitive; 
thus aaabbb123 ≠ aaabbB123 ≠ aaabBB123 ≠ aaaBBB123  ... etc

LibreOffice-CALC 
Pivot Table function should have preserved the values (case sensitivity ) of my original data.



Reproducible: Always


User Profile Reset: No



Additional Info:
OS = MS Windows 10 Home single Language (64 bit)
Version = 1909
OS build = 18363.1379
Comment 1 Timur 2021-02-18 15:58:08 UTC

*** This bug has been marked as a duplicate of bug 140510 ***