Issue 14245

Summary:	Imported Excel Print Areas BuiltIn_Print_Area are not deleted when removed
Product:	Calc	Reporter:	linuxkrn <gwatson>
Component:	code	Assignee:	oc
Status:	CLOSED NOT_AN_OOO_ISSUE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.1 Beta
Target Milestone:	---
Hardware:	PC
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description linuxkrn 2003-05-08 15:04:23 UTC

When you import an Excel XP sheet with Print Areas and try to remove them with
Print Ranges/Remove they remain in the list of ranges and cannot be deleted.

Ranges are named 'BuiltIn_Print_Area___1', _2, etc. and are still in the list
after being removed from the page.  

How to reproduce:
Create a new workbook in Excel and Define a print area on sheet 1.
Open in OO and goto the sheet 1 and use Tools/Print Ranges/Remove.
The range is removed from the sheet but remains in the list of ranges.

Comment 1 daniel.rentz 2003-05-21 16:22:25 UTC

This is intended behaviour.
In Excel you can use the print range in formulas. For instance:

=SUM(Print_Area)

In Calc this is not possible directly. Therefore the import filter
creates the print area itself *and* a database range, which is used in
the formulas. When you select Tools->PrintRanes->Remove, you remove
the print range, but not the database range.

Comment 2 daniel.rentz 2003-05-21 16:22:46 UTC

invalid->closed