Created attachment 142663 [details] Pivot table "Data" in column header If we have a column named "Data" (case matters) when creating a pivot table the aggregates will be shown in a single column. To reproduce the problem do the following: i) Open the attached file ii) Change cell B4 to "Data" (without the quotes) iii) Refresh the pivot table The aggregates will be shown in a single column. If we change back B4 cell to "B" and refresh the table, the aggregates will be shown in three columns. The column labels should not change the pivot table layout.
Using Ubuntu 18.04 with 6.0.3.2 (Ubuntu repo) and 6.1 Beta 1 (daily build dated the 10th) the error happens in both versions. Also tried it with 5.4.7 (rel) on Ubutnu 18.04 and the errant behavior is not present. Setting as regression.
Regression introduced by: author Kohei Yoshida <kohei.yoshida@collabora.com> 2017-05-23 22:09:40 -0400 committer Kohei Yoshida <libreoffice@kohei.us> 2017-06-06 05:00:33 +0200 commit a078328e91ab9cbd78a92608c1abdc2c57ff9ac5 (patch) tree 2d5dbb6ef9456e2ce5fe256f3a0ac76bdbccec49 parent 59c0682c46e52aa18bdbee4c14ef05af9329de33 (diff) tdf#107945: prepare for future multi-threading of pivot cache... It's disabled for now. We need to first make the edit engine and a few other places thread-safe before we can parallelize this code. Bisected with: bibisect-linux64-6.0 Adding Cc: to Kohei Yoshida
Dear Helder Guerreiro, 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 http://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://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Tested this and, I'm afraid, the problem it's still present in LO 6.3.2.2. Version: 6.3.2.2 (x64) Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c CPU threads: 6; OS: Windows 10.0; UI render: default; VCL: win; Locale: fr-FR (fr_FR); UI-Language: en-GB Calc: threaded I've tested also on a slightly older version (LO 6.3.1.2) with the same results: Version: 6.3.1.2 Build ID: 1:6.3.1~rc2-0ubuntu0.19.04.1~lo1 CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: gtk3; Locale: en-US (pt_PT.UTF-8); UI-Language: en-US Calc: threaded
Tested also on: Version: 6.3.2.2 Build ID: 1:6.3.2-0ubuntu0.19.04.1~lo1 CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: gtk3; Locale: en-US (pt_PT.UTF-8); UI-Language: en-US Calc: threaded Same results.
Still there with: Version: 7.1.2.2 (x64) / LibreOffice Community Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-US Calc: (Also tested threaded: no difference)
proposed fix at http://gerrit.libreoffice.org/c/core/+/130386
Justin Luth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b7f654a406b704f469d1df424d83a3d98ae46432 tdf#118117 sc pivottable: STR_PIVOT_DATA is an existing name too It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Justin Luth committed a patch related to this issue. It has been pushed to "libreoffice-7-3": https://git.libreoffice.org/core/commit/268bddd26cc006a7b4a1f9142245aecbff51c173 tdf#118117 sc pivottable: STR_PIVOT_DATA is an existing name too It will be available in 7.3.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.