[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#318308: openoffice.org: Spreadsheet DataPilot filter does not work

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

Reply to: