Issue 14245 - Imported Excel Print Areas BuiltIn_Print_Area are not deleted when removed
Summary: Imported Excel Print Areas BuiltIn_Print_Area are not deleted when removed
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-05-08 15:04 UTC by linuxkrn
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

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

Attachments
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 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