https://bugs.documentfoundation.org/show_bug.cgi?id=172337
Bug ID: 172337
Summary: Pivot Table Produces Duplicated Rows
Product: LibreOffice
Version: 26.2.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 207326
--> https://bugs.documentfoundation.org/attachment.cgi?id=207326&action=edit
test ods file
The attached simple ods files contains data in Sheet1 and pivot table in tab
"Pivot". The pivot table uses columns "Product Code" and "Product Name" as row
labels. For product code "010304017“, currently it generates two rows in pivot
table. It should have generated one row, as the product name is identical.
Steps to Reproduce:
1. Open the attached ods file. Observe that for product code "010304017", there
are 9 rows of records, but all of them are with the identical product name
"苯并三氮唑（BTA)".
2. Go to the pivot table tab. Observe that for this product code, 2 rows are
generated, as if there were 2 different product names.
Current Behaviour:
Two rows are generated for product code 010304017 in the pivot table.
Expected:
Only one row should be generated for this product code, as the product name is
the same.
More info: I suspect the mix-use of Chinese parentheses "（" and the ASCII
parentheses ")" may have some impact on this bug.
I noticed this bug in the then-latest version of Calc in June 2025, I thought I
may have filed a bug report for this, but today when I search I realized that I
didn't file, so I file it now.
--
You are receiving this mail because:
You are the assignee for the bug.
