2015 11 30 Pivot Table Drill to details doesn’t work First tested with Version: 5.1.0.0.beta1-buildfix1 Build ID: 13010a13177025f633c9b85adcb3edf6920e44e3 Threads 2; Ver: Windows 5.1; Render: default; Locale: es-MX (es_MX) on Windows SP SP3 and Windows 10 Problem description: In a pivot table with the option “Enable drill to details” activated, and previously configured detail, double clicking in the first row category will pop up a window to select a field, instead of expand the detail. Also, when the detail is present, double clicking in the first row category will not hide the detail, but opens a dialog to select fields, as if it wants to expand. The same happens when double clicking in the first category column. Double clicking in the second row or column field will perform as expected, expanding or contracting the details. Steps to reproduce: Open test file 2015 11 30 Drill Test 3.ods Go to Pivot Table_Sheet5_1 Double click in any of the first row categories (field6) The “Show Detail” window displays Cancel the dialog Double click in any of the second row categories (field1) The details expands or contracts as expected. In the same way Double click in any of the first column categories (field4) The “Show Detail” window displays Cancel the dialog Double click in any of the second column categories (field7), especially in the “09” value, because is more evident. The details expands or contracts as expected. The drill to details was already defined, and is present in the Pivot Table layout, and in the Show Detail window, the second row field is not listed. Last tested with Version: 5.1.0.1.0+ Build ID: 2c6e8e4142493dd135003aff16a1709d6e3a29d0 CPU Threads: 2; OS Version: Windows 5.1; UI Render: default; TinderBox: Win-x86@62-merge-TDF, Branch:libreoffice-5-1, Time: 2016-01-06_12:56:07 Locale: es-MX (es_MX) on Windows XP SP3 and Windows 10
Created attachment 121826 [details] Calc test file
Created attachment 121827 [details] screenshoots and descriptions
Hello: Just tested it on 2016 01 15 with RC2 Version: 5.1.0.2 Build ID: ecd3574d51754b043f865cf5bafee286d24db7cc CPU Threads: 2; OS Version: Windows 5.1; UI Render: default; Locale: es-MX (es_MX) Windows XP SP3 and Windows 10 Reproducible
I don't get the Show Detail window. Maybe try renaming profile just to be sure https://wiki.documentfoundation.org/UserProfile#Resolving_corruption_in_the_user_profile Win 7 Pro 64-bit Version: 5.1.0.2 (x64) Build ID: ecd3574d51754b043f865cf5bafee286d24db7cc CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; Locale: fi-FI (fi_FI) Version: 5.2.0.0.alpha0+ Build ID: 000df1832b54ba8f48c7f1c4c1cd92b70f6402da CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@39, Branch:master, Time: 2016-01-18_01:08:28 Locale: fi-FI (fi_FI)
(In reply to Beluga from comment #4) > I don't get the Show Detail window. > > Maybe try renaming profile just to be sure > https://wiki.documentfoundation.org/ > UserProfile#Resolving_corruption_in_the_user_profile > Hello. I have renamed the profiles, both in the administrative RC2 installations and the Dev of 5.1 installation in a PC with Window XP SP3 and my Laptop with Windows 10 and the problem is still present. The RC2 is Version: 5.1.0.2 Build ID: ecd3574d51754b043f865cf5bafee286d24db7cc CPU Threads: 8; OS Version: Windows 6.2; UI Render: GL; Locale: es-MX (es_MX) The Dev was 5.1.0.1.2016-01-12-11.37.42. After that, installed the Version: 5.2.0.0.alpha0+ Build ID: 000df1832b54ba8f48c7f1c4c1cd92b70f6402da CPU Threads: 8; OS Version: Windows 6.19; UI Render: default; TinderBox: Win-x86@39, Branch:master, Time: 2016-01-18_01:08:28 Locale: es-MX (es_MX) And found the same problem. I am attaching screenshoots of each test. Notice the highligthed field with yellow, where the double click is applied to expand/colapse details.
Created attachment 122094 [details] Screenshoot LO 51 rc2
Created attachment 122095 [details] Screenshoot LODev51 13.01.16
Created attachment 122096 [details] Screenshoot LO RC2 Win 10
Created attachment 122097 [details] Screenshoot LO 52 Win 10
Hi. I have tested this issue with Version: 5.1.1.0.0+ Build ID: 64b23ff688fc4ba3fc0205094380f072fd98b5b5 CPU Threads: 8; OS Version: Windows 6.2; UI Render: default; TinderBox: Win-x86@62-merge-TDF, Branch:libreoffice-5-1, Time: 2016-01-25_07:41:39 Locale: es-MX (es_MX) On Windows XP SP3 and Windows 10 With the test file provided as with some personal and work files that use pivot tables. I am attaching a screenshoot of this.
Created attachment 122232 [details] Screenshoot of Pivot table drill to detail
Hello. I have tested again with the RC3 Reseted the profiles in both Windows XP SP3 and Windows 10 With the same problem. I am attaching the screenshoots
Created attachment 122288 [details] ScreenShoot RC3 WXP
Created attachment 122289 [details] ScreenShoot RC3 Windows 10
Created attachment 122598 [details] Test with LO 5.1 release
Hello. I have tested the drill to detail in the test file with LO 5.1 just released these week, and the problem is still present. I have some other files with pivot tables that behave in the same way in home and work.
Created attachment 123412 [details] Calc Screenshoot
Hi. Tested this problem with the Pivot table. Version: 5.1.1.3 Build ID: 89f508ef3ecebd2cfb8e1def0f0ba9a803b88a6d CPU Threads: 8; OS Version: Windows 6.2; UI Render: default; Locale: es-MX (es_MX) On windows 10 and XP SP3
Hi. I suppose that this bug submission is waiting for some one else to confirm what I have found. Nonetheless I will keep updating it. I have been testing this issue, forced by the use my pivot tables. In version 5.0.5, drill to details, expand or collapse the details in the first row field level, as in version 4.4.7. But in 5.1.2 last released, it will not, double clicking in the first row field, will bring a window to select fields to display details, but the layout is already configured. I’m attaching a new test file and a screen shoot, that I hope will help to see what I have found.
Created attachment 124200 [details] Screen shoot LO Dev 5.2
Created attachment 124201 [details] New test file pivot table
This seems to have begun at the below commit. Adding Cc: to Michael Stahl; Could you possibly take a look at this one? Thanks e40e3a5bd939731ecfc63f9fb2c2f17720a618f5 is the first bad commit commit e40e3a5bd939731ecfc63f9fb2c2f17720a618f5 Author: Norbert Thiebaud <nthiebaud@gmail.com> Date: Sat Nov 7 06:19:47 2015 -0800 source 37856f59d2351951b95cf5eb3a5e4f0c011a8762 source 37856f59d2351951b95cf5eb3a5e4f0c011a8762 author Michael Stahl <mstahl@redhat.com> 2015-11-06 16:03:25 (GMT) committer Michael Stahl <mstahl@redhat.com> 2015-11-06 19:37:39 (GMT) commit 37856f59d2351951b95cf5eb3a5e4f0c011a8762 (patch) tree 55777665cff7b7145c5b54cf7503aab5db33ca34 parent ce6401c263b9f098c1fad636656749db6c6f22a1 (diff) sc: replace boost::ptr_vector with std::vector<std::unique_ptr>
oops, accidentally changed one of those loops that was previously going in reverse but now goes forward... fixed on master
Michael Stahl committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=470f16acc2a798f0ae1ebe9ce2080084ab167e80 tdf#96996 sc: fix the data pilot It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Michael Stahl committed a patch related to this issue. It has been pushed to "libreoffice-5-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=dba0cc1edc6d778805ca8ed4b77800f1e9a95408&h=libreoffice-5-1 tdf#96996 sc: fix the data pilot It will be available in 5.1.3. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I found this bug after encountering some strange behaviour with Pivot Tables on LibreOffice 5.1.2.2 on Ubuntu. I can't tell if what I experienced matches up 100% to the problem described on this bug report but after I updated to LibreOffice 5.1.3.2 and the pivot table definitely worked better.