Created attachment 110356 [details] Example of table and pivot table When a column field is filtered in a pivot table and therefore falls outside the filter result table, it is impossible to recover the filtered data, unless re-edit the pivot table and change the order of fields .
Hello , Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it.) How can I eliminate confidential data from a sample document? https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F Thank you
Created attachment 110383 [details] test pivot table I am able to create a test pivot table, see attached. I believe this matches the issue as Juan Luis Gallego described. Steps to reproduce the issue: 1. In column B, filter "b1" only. 2. In column C, filter "c1" only. 3. Try to click the filter arrow for C. --> Unresponsive. This is the same issue as described in bug 58691: > 2. column filter buttons become nonfunctional when they exceed the rectangular cell range of the pivot table Set to NEW. @Juan Luis Gallego: If you find it impossible to recover the filtered data, try to right-click on the pivot table, then click "filter"... Version: 4.3.5.1 Build ID: 8fd0451cc08e6a5310bed8b7ad1c46b93c1c6889 Version: 4.4.0.0.beta1 Build ID: 9af3d21234aa89dac653c0bd76648188cdeb683e Locale: zh_CN
Kevin's comment -> NEW The same problem in LibreOffice 3.5.0 Build ID: d6cde02, changing version
Changed title. (Actually it's possible to recover the filtered data)
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.