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
*** This bug has been marked as a duplicate of bug 140510 ***