Issue 10995 - Saving as Excel with Autofilter enabled prevents filtering from working after spreadsheet is reloaded
Summary: Saving as Excel with Autofilter enabled prevents filtering from working after...
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.0.1
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-01-27 19:53 UTC by swolf
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Proposed patch to fix this (5.37 KB, patch)
2003-02-21 15:38 UTC, john.marmion 		no flags Details | Diff
Update Patch - remove need for OUString (5.32 KB, patch)
2003-02-25 18:15 UTC, john.marmion 		no flags Details | Diff
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description swolf 2003-01-27 19:53:25 UTC 
Here's a set of steps to reproduce the problem:
Create a sheet with two columns like so:
Gender | Name
Male   | Aaron
Female | Erin
Male   | Christopher
Female | Christina

Turn on AutoFilter - note that it works for Male and Female
Save as an Excel Spreadsheet & Close it then Reopen the File
Turn off the AutoFilter
Add two new lines:
Male   | Patrick
Female | Patricia

Turn the AutoFilter back on
The new entries appear now matter what is filtered for the Gender column

This works properly if saved in the OpenOffice format.  It will also work 
properly if it is saved as Excel without the AutoFilter turned on.
Comment 1 daniel.rentz 2003-01-29 07:53:44 UTC 
To be added: Removing internal database ranges
"BuiltIn_AutoFilter___*" created on Excel import.
Comment 2 daniel.rentz 2003-01-29 07:53:59 UTC 
Started
Comment 3 john.marmion 2003-02-18 15:47:27 UTC 
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
Comment 4 daniel.rentz 2003-02-19 11:54:39 UTC 
owner->John
Comment 5 john.marmion 2003-02-19 12:29:33 UTC 
started
Comment 6 john.marmion 2003-02-21 15:38:46 UTC 
Created attachment 4833 [details]
Proposed patch to fix this
Comment 7 john.marmion 2003-02-25 18:15:56 UTC 
Created attachment 4898 [details]
Update Patch - remove need for OUString
Comment 8 john.marmion 2003-02-25 18:22:55 UTC 
Checked in this patch today.
Comment 9 john.marmion 2003-04-03 15:24:59 UTC 
reopen to assign to QA
Comment 10 john.marmion 2003-04-03 15:25:23 UTC 
assign to QA
Comment 11 john.marmion 2003-04-03 15:25:47 UTC 
reset to fixed
Comment 12 frank 2003-04-07 11:08:46 UTC 
veified on cws calc06 using Solaris and Windows
Comment 13 frank 2003-04-16 11:48:51 UTC 
found integrated on srx644m10s1 using Linux, Solaris and Windows