To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103976 Issue #|103976 Summary|Autofilter and Standard Filter... not working correct Component|Spreadsheet Version|OOO310m11 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|editing Assigned to|spreadsheet Reported by|mrmaceurope
------- Additional comments from [email protected] Mon Aug 3 16:35:51 +0000 2009 ------- I have started to use OpenOffice as my primary Office Suite and I'm using Calc a lot... While using the AutoFilter function (Data -> Filter -> Autofiler) I discovered a few bugs, which I think are related. Scenario: (see attachment) If you create a sheet1 with only column headers - e.g. HEADER1...HEADER3 and active Autofiler - no problems. Issue/Bug: If you then create a sheet2 with a sheet header, e.g. 'My Budget' and then in row 2 adds HEADER1...HEADER3 as above and the turn on AutoFilter. Problems! First of all, the AutoFilter dialogs on sheet1 are turned off and on sheet2 your are able to choose a specific value to filter, but you can't really use the 'Standard Filter' function, as the headers no longer are recognized, the Standard Filter dialog shows only the ColumnA...X as field names not the column header titles. Workaround: I found, that if I add a empty Row between the sheet header, 'My Budget' and the first column header e.g. in row 3, no issues. ??? --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
