Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Saving as Excel with Autofilter enabled prevents filtering from working after spreadsheet is reloaded | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | swolf <swolf> | ||||||
Component: | ui | Assignee: | oc | ||||||
Status: | CLOSED FIXED | QA Contact: | issues@sc <issues> | ||||||
Severity: | Trivial | ||||||||
Priority: | P3 | CC: | issues | ||||||
Version: | OOo 1.0.1 | ||||||||
Target Milestone: | --- | ||||||||
Hardware: | PC | ||||||||
OS: | Windows 2000 | ||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||
Developer Difficulty: | --- | ||||||||
Attachments: |
|
Description
swolf
2003-01-27 19:53:25 UTC
To be added: Removing internal database ranges "BuiltIn_AutoFilter___*" created on Excel import. Started This is not as simple as it first appears. See also issue 11594. The user creates an AutoFilter(AF) without a DataBase(DB) range (invisible) in Excel. If the AF is removed, the temporary DB range is deleted. But the Calc Excel import filter creates a named DB range using the BuiltIn_AutoFilter__ naming convention and this is not deleted as this range is needed because there may be several AFs in the Excel file. It is also complicated by the fact that in Excel, you can use this AF range in a formula. There is a mechanism in Calc to support this. This would involve using the "unnamed" DB range for the invisible AF. The problem at the moment is that Calc only supports one such unnamed range per document, while Excel supports one per sheet. Until this is resolved in Calc, no total solution is possible. The only alternative is to do puruse what Daniel suggested in issue #11594, and that is create the unnamed range if and only if one AF is present in the imported Excel document. This would satisfy the sample AF in this bug and would go some way is resolving an irritating problem owner->John started Created attachment 4833 [details]
Proposed patch to fix this
Created attachment 4898 [details]
Update Patch - remove need for OUString
Checked in this patch today. reopen to assign to QA assign to QA reset to fixed veified on cws calc06 using Solaris and Windows found integrated on srx644m10s1 using Linux, Solaris and Windows |