| Summary: | Pivot table: Column filter not functional when exceeds pivot range | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Juan Luis Gallego <julugasa> |
| Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | QA Contact: | |
| Severity: | normal | ||
| Priority: | medium | CC: | gerard.fargeot, raal, suokunlong |
| Version: | 3.5.0 release | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.freedesktop.org/show_bug.cgi?id=58691 | ||
| Whiteboard: | |||
| i915 platform: | i915 features: | ||
| Attachments: |
Example of table and pivot table
test pivot table |
||
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.
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 .