Issue 14216 - Excel Workbook Sheets won't print/preview sheets without Print Range defined
Summary: Excel Workbook Sheets won't print/preview sheets without Print Range defined
Status: CLOSED DUPLICATE of issue 4063
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-05-07 21:59 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-07 21:59:41 UTC 
When using a Excel XP sheet that had defined "Print Ranges" on some sheets, Open
Office will only print sheets that have defined ranges.  Sheets with no range
defined will not print.

In Excel, if a sheet has no print range defined, it will default to printing the
entire sheet.

Also, existing print ranges cannot be easily removed.
Excel print areas show up as BuiltIn_Print_Area___1, ____2, ____3.  However, you
cannot delete these from the edit menu.  While you can remove assosication with
the sheet with 'Remove' the area remains defined.

How to reproduce:
Create a new Excel XP sheet
On sheet 2 of 3 define a Print Area (File/Print Area.../Set Print Area)
Save, open in OO.
File/File/Page Preview and only sheet 2 will be shown.
Comment 1 daniel.rentz 2003-05-08 12:09:34 UTC 
"print entire sheet": double to issue 4063.
To remove print ranges, you can use Format->PrintRanges->Remove.


*** This issue has been marked as a duplicate of 4063 ***
Comment 2 daniel.rentz 2003-05-08 12:09:47 UTC 
double->closed