Description: Not the same as Bug 108834 which claims a failure when the filter is set to show ONLY empty cells. This is the exact opposite. When deselecting empty values they are still shown so there is no effective way to simply show the first level Steps to Reproduce: Create a data table with perhaps four columns Column 1 is a name - ensure you have more than one name Column 2 is a category - ensure you have more than one category Column 3 is a date - ensure you have a busy diary Column 4 is a sum of money - ensure you spend loads of dough on your date ;) Perhaps even get a refund so there are some credits as well as debits Create the pivot table with columns 1, 2 & 3 as the Row Fields: entries and column 4 as the Data Fields: summed entry. Ensure your PT display includes blank spaces in columns 1 & 2 Try to exclude blanks by deselecting the blanks check box in the column filter on column 1 or 2 Actual Results: Screen full of empty cells and every value is shown Expected Results: Whichever column has been selected to exclude blanks should exclude the blanks but far more importantly it should produce a sub total for the appropriate consolidation of column 1, 2 & 3 items. Therefore, if you date the same companion on multiple occasions at many of the places you attend then there should be appropriate subtotals at the day level, the venue level and the companion level. Of course, if you prefer to sell different groceries from different market stalls on different days for variable sums of money you would probably still want the same subtotals. If I tell a PT filter to not display an empty item it means the same as in an ordinary filtered array - I don't care what is further along the line exclude it AND ensure the appropriate subtotals are maintained. Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: Version: 7.3.5.2 (x64) / LibreOffice Community Build ID: 184fe81b8c8c30d8b5082578aee2fed2ea847c01 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: sv-SE (en_GB); UI: en-GB Calc: threaded
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 182472 [details] Screen Dump As can be seen, the filter to exclude all blanks had been activated but all the blank lines in that column are still visible. I would expect it to collapse all the blank rows in that column and produce sub-totals as appropriate - just like a pivot table would. In this guise, it's more like an inferior Autofiltered array without the benefit of SUBTOTAL() to include or exclude values in the "hidden" rows. A pivot table should of course consolidate the values into subtotals at the appropriate levels of collapse.
(In reply to Colin from comment #0) > Steps to Reproduce: > Create a data table with perhaps four columns > Column 1 is a name - ensure you have more than one name > Column 2 is a category - ensure you have more than one category > Column 3 is a date - ensure you have a busy diary > Column 4 is a sum of money - ensure you spend loads of dough on your date ;) > Perhaps even get a refund so there are some credits as well as debits > Create the pivot table with columns 1, 2 & 3 as the Row Fields: entries and > column 4 as the Data Fields: summed entry. > > Ensure your PT display includes blank spaces in columns 1 & 2 Please attach an example document. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document.
Created attachment 185088 [details] Sample pivot table Try to exclude the EMPTIES with the filter on column 1 "Name" Observe that nothing changes all the empties are still producing values in columns 2,3 & 4 Exclude or re-include any of the other Names in column 1 and observe how the other columns respond approriately. I would expect a subtotal anywhere there are groups say "tender" or "Juicy"
Hello Colin, Thank you for reporting the bug. I can confirm that the bug is present in master. Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d9031bd83ffe718a80da9ecbdbeb485e35fbabee CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded
Dear Colin, 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
Version: 25.2.2.2 (X86_64) / LibreOffice Community Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: sv-SE (en_SE); UI: en-GB Calc: threaded Still there And even more nefarious Try removing ALL entries from the Name slicer and it refuses - sensible Now remove everything but Amanda - not quite so sensible
Clearly, there is an issue when there are multiple blanks which "May" be associated with the name immediately preceding those blanks