[Libreoffice-bugs] [Bug 140509] New: Pivot table changes the case (upper/lower) of the PivotTable sheet from the original sheet

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=140509

            Bug ID: 140509
           Summary: Pivot table changes the case (upper/lower) of the
                    PivotTable sheet from the original sheet
           Product: LibreOffice
           Version: 5.4.7.2 release
          Hardware: Other
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: LibreOffice
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: wengng5 at yahoo.com.au

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210218/1b50f931/attachment.htm>