To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93216 Issue #|93216 Summary|autofilter import: datarange is only the first row Component|Spreadsheet Version|OOo 3.0 Beta 2 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|mroe
------- Additional comments from [EMAIL PROTECTED] Thu Aug 28 15:04:23 +0000 2008 ------- Hello! If a excel document is opened with a defined autofilter the autofilter do not work in calc, because the created named data range "Excel_BuiltIn__FilterDatabase_x" has only the size of on row (the first row of the data range). If the user set the autofilter off and again on it results every time in no autofilter entries, because calc uses always the created datarange. If an autofilter not only defined but active, the the created data range "Excel_BuiltIn__FilterDatabase_x" has the right size and the autofilter works. The problem appears also in 2.x. (Sorry, can't create a sample document because no excel is present.) Solution: Creation of "Excel_BuiltIn__FilterDatabase_x" with the right size of the whole data range or no creation of named data range if the autofilter is not active. --------------------------------------------------------------------- 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]
