Created attachment 86878 [details] phone calls DB for pivot table in Calc Problem description: When editing layout of a pivot table that has a descending sorting orden of a data field, resets the sorting to the row field Steps to reproduce: Select data through 08/31, 4686 lines of data Menu Data – pivot table-create – current selection Pivot table options window Move to page fields Month – year, type move to row field phone move to data area, phone(count), duration (sum), duration (mean) select row field phone, options, options sort by phone(count), descendent Generates Pivot Table_CallsDB_1 then modify table range of data to 10,000 lines, or 5,000 or through 09/30 4782 lines, is the same this action reset the table sort to ascendent order by row field, after that, editing the layout doesn't correct the table Current behavior: editing the layout modifiying the data range causes the table to loose the sorting, editing the layout to correct doesn't function. Expected behavior: Modifiying the range should refresh the table keeping the sorting configured. Editing the sorting should refresh the table with the new layout Operating System: Windows 8 Version: 4.1.1.2 release
Hi riggr , thanks for reporting. Reproducible, even more, modifying the sort or the layout options for the row field, are not preserved when Ok to edit layout. Win7x64Ultimate Version 4.0.5.2 (Build ID: 5464147a081647a250913f19c0715bca595af2f) Regression from 3.5.7.2 (I don0t know 3.6)
Ok. Now I know what causes this. Will have a fix shortly.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7e491281d2ba71490fa22cce1e43ba91f60395e3 fdo#69984: Handle duplicate field names correctly. 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.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ba0204675724ada537db63999d73ac8174b24949&h=libreoffice-4-2 fdo#69984: Handle duplicate field names correctly. It will be available in LibreOffice 4.2. 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'll call this fixed.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2ea5c1b6dd1d8fda41c1c1fdc3cf994c4f9e5895&h=libreoffice-4-1 fdo#69984: Handle duplicate field names correctly. It will be available in LibreOffice 4.1.5. 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.