Issue 14216

Summary:	Excel Workbook Sheets won't print/preview sheets without Print Range defined
Product:	Calc	Reporter:	linuxkrn <gwatson>
Component:	code	Assignee:	oc
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.1 Beta
Target Milestone:	---
Hardware:	PC
OS:	Windows 2000
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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