Issue 21509 - Calc not previewing/printing some sheets
Summary: Calc not previewing/printing some sheets
Status: CLOSED DUPLICATE of issue 4063
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: PC Windows XP
: P2 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: ms_interoperability, oooqa
Depends on:
Blocks:
 
Reported: 2003-10-21 15:49 UTC by Unknown
Modified: 2003-10-22 09:54 UTC (History)
2 users (show)

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

Attachments
Excel spreadsheet, multiple tabs, won't preview/print all tabs (242.50 KB, application/octet-stream)
2003-10-21 15:54 UTC, Unknown 		no flags Details
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 Unknown 2003-10-21 15:49:19 UTC 
Hi Folks,
   I have imported an Excel spreadsheet, with 13 tabs (sheets). I can 
go to any of the sheets, and enter data, but sheets 1 - 7 and 11 - 13 
will not appear in preview, or print, even if I select the sheet using 
the select options in print. I cannot find any protection on these 
sheets, and can't find any built-in or user imposed limitations of the 
printing of these sheets, or on the number of sheets in a spreadsheet. 
Properties show 13 sheets, 6379 cells, and 8 pages. If I run preview, 
and go thru the 8 pages, sheets 8 and 9 take up 6 pages (3 each), with sheet 10 
using 2 pages, with the third page missing from the preview.
   If I open the same spreadsheet in Excel, and follow the same 
criteria, the sheets preview/print just fine.
   I am running OpenOffice 1.1.0, on Windows XP Pro.
   I have attached the spreadsheet.
   Any help would be greatly appreciated.
Comment 1 Unknown 2003-10-21 15:54:53 UTC 
Created attachment 10519 [details]
Excel spreadsheet, multiple tabs, won't preview/print all tabs
Comment 2 utomo99 2003-10-22 08:13:07 UTC 
I can Reproduce the problem on 
OpenOffice 1.1 (default Install, US), Win XP Pro Sp1. 
(And MS Office XP Sp2). 
It is real problem
I change the version to OOo 1.1 as reported by reporter and I try
using 1.1

if we open the file, and page preview. 
we will not see sheets 1 - 7 and 11 - 13 in the preview. it start with
July in the preview. 
I didnt try to print it, but if in print preview is not available
probability is not printed too
Comment 3 john.marmion 2003-10-22 09:46:58 UTC 
This is a duplicate of issue 4063. Excel prints all sheets but
Calc prints only those sheets containing a defined print range. There
are three defined print ranges in this document - see
Calc->Insert->Names->Define.

There is a fix in progress, meanwhile there are two workarounds:

a. remove the print ranges in Excel (File->Print Area->Clear)
b. add a print range to all sheets in Calc

*** This issue has been marked as a duplicate of 4063 ***
Comment 4 john.marmion 2003-10-22 09:54:09 UTC 
closed