Subject: openoffice.org: Spreadsheet DataPilot filter does not work Package: openoffice.org Severity: normal *** Please type your report below this line *** The filter option on a spreadsheet datapilot table does not work correctly. After creating a "pivot table" using the Data/DataPilot menu item, click the top left "Filter" cell to add a filter. When there is no filter selected, or a filter item is selected and "-not empty-" is chosen, then the table pivot table displays correctly. However, if a value is chosen for the filter (e.g., "=" and "1"), then the whole table collapses to only two cells in size, instead of displaying the filtered data. I have attached a very simple spreadsheet that allows the bug to be replicated. Load the file and left click cell A30 to add a filter. In "field name" select A. In "value" select 1. In "condition" select =. When "OK" is clicked, the data pilot table shrinks to only two cells in size. It should remain the same size and display the numbers 1 to 9 in the central portion of the table. -- System Information: Debian Release: 3.1 Architecture: i386 (i686) Kernel: Linux 2.6.8-2-686 Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Attachment:
datapilot_bug_example.sxc
Description: Zip archive