Created attachment 65949 [details] file to demonstrate incorrect pivottable behavior Problem description: When creating a pivottable from data in spreadsheet, the vertical aggregation/grouping is incorrect - it contains multiple equal entries. Steps to reproduce: 1. create a simple data table according to attached file. 2. create pivottable with vertical aggregation values from column "x-axis", horizontal aggregation values from "y-axis" and sum-values from "z-axis" 3. look at created table Current behavior: vertical aggregation contains multiple equal entries Expected behavior: unique vertical aggregation values (open attached file in LO 3.5.5.4 and actualize pivottable) Platform (if different from the browser): Win7 x64, LO 3.6 Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:14.0) Gecko/20100101 Firefox/14.0.1
Created attachment 65950 [details] screenshot of data values for pivottable
Created attachment 65951 [details] screenshot of pivottable produced by LO 3.6
Created attachment 65952 [details] screenshot of pivottable produced by LO 3.5.5.3
Confirming & taking it.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1afd1e5ca8872253c491af76c70397fb9e00f900 fdo#53929: Pivot table uses case insensitive string comparison.
Fixed on master. Request for 3.6 backport has been sent out.
back-ported; thrilled to see the unit test so it can never recur :-)
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0ee1609ddc04f01e7398fab08d74529c301600e6&g=libreoffice-3-6 fdo#53929: Pivot table uses case insensitive string comparison. It will be available in LibreOffice 3.6.2.
*** Bug 53963 has been marked as a duplicate of this bug. ***
@Kohei question please: does that mean you (re)-introduced case-sensifity in a aggregation-function? (Hope not) Martin