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
Created attachment 169866 [details] PivotTable changes my case sensitive data The attachment contains a csv file of a sample data used to illustrate my report
*** Bug 140509 has been marked as a duplicate of this bug. ***
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 170827 [details] sample file
Reproduced in Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: 3453f2f8fce9e69cd9f2a2c6f3d7171b6e59f674 CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
also reproduced in Version: 4.3.0.0.alpha1+ Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e
Created attachment 170832 [details] PivotTable changes my case sensitive data The pivot function has removed the case sensitivity from the raw data.
Dear Kana Masai, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Repro 26.8+.
(In reply to Timur from comment #10) > Repro 26.8+. 1) The bug exists as was originally reported in 2021. 2) I have re-tested with latest version of libreoffice calc Version: 26.2.3.2 (X86_64) Build ID: 70e089b17412e4cb7773e41413306b17a2328c34 CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: en-MY (en_MY); UI: en-US Calc: CL threaded