| Summary: | PIVOTTABLE: incorrect aggregation of values (worked in 3.5.5.3) | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Gunther Lenz <gunther.lenz> |
| Component: | Calc | Assignee: | Kohei Yoshida <kohei> |
| Status: | RESOLVED FIXED | ||
| Severity: | critical | CC: | Filip.san.1, gdavis96 |
| Priority: | highest | ||
| Version: | 3.6.0.4 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | BSA target:3.7.0 target:3.6.2 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
file to demonstrate incorrect pivottable behavior
screenshot of data values for pivottable screenshot of pivottable produced by LO 3.6 screenshot of pivottable produced by LO 3.5.5.3 |
||
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 |
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