Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Auto Filter - Functionality does not work | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | rajkirann <rajkirann> | ||||
Component: | viewing | Assignee: | spreadsheet <spreadsheet> | ||||
Status: | CLOSED DUPLICATE | QA Contact: | issues@sc <issues> | ||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | issues | ||||
Version: | OOo 2.3 | ||||||
Target Milestone: | --- | ||||||
Hardware: | All | ||||||
OS: | Windows XP | ||||||
Issue Type: | FEATURE | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
rajkirann
2007-10-30 09:45:49 UTC
Created attachment 49264 [details]
Autofilter - Does not work
Hi, the problem is the filter range set by Excel. If Excel sets the Filter range (needed for filter operations) to only one row, e.g. the developer of the spreadsheet applied an autofilter just before some data was entered, Excel automatically adds the new data to the range but did not store it with the file. Therefore Calc and maybe other Applications can not set the Autofilter range correctly. So you have two choices : 1.) Go to Data-Define range, select the Build in Autofilter range and modify the values to the correct one. In your case to $I$111 2.) Remove the autofilter in Excel and apply it again. This Issue is a double to Issue 55141 Frank *** This issue has been marked as a duplicate of 55141 *** closed double |