Created attachment 145375 [details] Screen shots of the pivot table layout and result of the stuck filter To recreate: Create a pivot table in a new sheet using data in the same file. My table has 5 row fields: year, month, YearMonth, Category, 'regular or discretionary' and one column :data, being the sum of an amount field. The regular or discretionary field has 4 options, R, D, S and X. If I filter on YearMonth and then select a regular or discretionary where there is data present, the filtering works correctly, but if I select one where there is no data present for the YearMonth selected, the table 'collapses' and only displays the year and data headings, with one row with a completely empty result. I have tried Edit - Undo and have tried unhiding rows, but nothing I do will bring back the pivot table to a useable state. Because the YearMonth and regular or discretionary headings have disappeared, I cannot remove the filtering on them. I have discovered that if I edit the pivot table to remove the regular or discretionary row this will clear the 'stuck' filter and the data will reappear, then I can put the row back into the table.
Thank you for reporting the bug. Could you please add an example document? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the issue is still present
I have made a sanitised copy of my file so you can play with it. On the Pivot Table By Category sheet, select YearMonth 20189 then select 'regular or discretionary' S. The columns will disappear. You can select Edit-Undo and the last filter will be removed, but you will be unable to modify the month, YearMonth or Category filters. You can select a different year, but then the columns will disappear again. If you Edit - Undo this will make the columns come back, but the filter arrows will still be disabled. The only way to free them again is to modify the layout and save it, then modify it again to undo your changes.
Created attachment 145394 [details] Example spreadsheet containing a pivot table
i can confirm this bug with lo 6.1.2.1: selecting a non existing value from attached spreadsheet in column 'regular or discretionary' (e.g. 'S') makes pivot table unusable.
Created attachment 145430 [details] pivot filter problem
Created attachment 145431 [details] a simple example where the filter problem does not occur adding an attachment with a simple example, where i cannot confirm the problem: - select column: year: '2018' - select column: category: 'C' - select column: year: 'ALL' - select column: category: 'ALL'
Also reproduced in Version: 5.2.0.0.alpha0+ Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53 Threads 4; Ver: 4.10; Render: default; Version: 4.3.0.0.alpha1+ Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
@Tamás Zolnai, I thought you could be interested in this issue...
Dear besancon4me, 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
Dear besancon4me, 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 https://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://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug