https://bugs.documentfoundation.org/show_bug.cgi?id=172337
--- Comment #4 from Kevin Suo <[email protected]> --- Created attachment 207332 --> https://bugs.documentfoundation.org/attachment.cgi?id=207332&action=edit More complicated example Attached is some real data generated from the ERP accounting system that I should use Calc to do analysis. As you can see: 1. For Material Code "010302004", although there are many many different Document Numbers, the pivot table result is correct: only one row is generated and the GR quantity is correctly aggregated in the value field. Note that the Material Name for this material code is "双酚S“, without any parentheses. 2. For Material Code "010304002”, 15 rows are generated, each row has its own aggregated sum of "Actual GR Quantity" in the value field. This is wrong. The same wrong behaviour exists for many other Material Codes, e.g. 010304004, 010304017, etc. The only difference between these codes and the code mentioned in 1 above is they have parentheses. 3. And, surprisingly, if you refresh the pivot table (right-click then click "Refresh"), the data in “Sum - Actual GR Quantity” changes! And each time you refresh, you get quite different sum, and it I really don't see any pattern of how it changes, it is all random by chance. This bug is really dangerous. This is the very basic function of pivot table, but I really can't trust it in my work - I don't know what other special characters may trigger this bug. -- You are receiving this mail because: You are the assignee for the bug.
