Hi. If you can make head and tail of printing spreadsheets in Calc, you
may have the admiration of all Calc users.
There is a concurrent discussion on the sc-users' list and these are
some excerpts:
"When I try to print a 9 sheet CALC document, and if I select "all" from
the FILE->PRINT menu all prints fine. BUT, if I select "PAGES" and list
the pages 2-9 to print, then the print fails completely. If I select
"PAGES" and leave the default to page 1-9 then page #1 ONLY prints, and
2-9 fail. I am using 2.0.4RC1 ....
can someone explain to me why the issue
http://www.openoffice.org/issues/show_bug.cgi?id=69576 that I opened
keeps repeatedly being closed by QC? ....
"Pages" in the print dialog refers to printed pages, not sheets.
... you must understand the difference of "sheets", "pages", and
"selection". Plus there are the "print ranges" and the "print only
selected sheets" box that you found on the Print Options dialog.
The sheets are selectable near the left bottom of the Calc window. Use
Ctrl+Click to select multiple sheets, but only if you know what you are
doing (because now everything you enter on one sheet will most likely be
entered on all selected sheets), so normally you will not want to select
multiple sheets, and you will not enable the "print only selected
sheets" box.
Every sheet can consist of many printed paper pages. This obviously
depends on the paper size, font size, and so on.
The Print Ranges that you define on the Format menu must also be
considered. If you have set a print range to print sheet 2 and nothing
else, you will only see printed output from sheet 2 or no output at all,
depending on the settings on the File-Print dialog.
... I see the technical difference.
But, in the example file attached to the issue, each of the nine sheets
contain only data in cell A1, which is composed in sheet one of "Sheet
1" and in sheet two of cell A1 "Sheet 2" and so on. Thus, in the
example file, there is no difference at all between printed "sheets" and
printed "pages" and the calc behavior should produce the same output for
each. It does not.
When I first encountered this problem, I had a complicated spreadsheet
that had print ranges established for each sheet. ****** Each sheet had
been set to adjust its width / height to print on one page. But
investigation of the problem even with the simple test file described in
the paragraph above fails to perform to expectations. ****** [marking
added]
In short, CALC is not taking account of page settings on each sheet
during the printing process."
If you want to look at the discussion, messages from that list (for Calc
users but not very active) are published at
http://sc.openoffice.org/servlets/SummarizeList?listName=users
Donald H Locker wrote:
Thanks, Sandy.
My problem is that all indications are that the printed and screen
presentations should be the same, but the "optimal row height" is not
correct for the printed page (I see I wasn't clear on that.)
The printed page (and the page preview) don't have sufficient space
for the rows that have wrapped. Only 0.29 inches are provided, where
0.17 * 2 would be appropriate (I think).
Donald.
SandyU wrote:
Not sure I understand. The font has not changed, only the row height.
I would expect that to make a difference when printing. If the rows
have a greater height, you will fit fewer of them on the page.
Donald H Locker wrote:
OOo 2.0.3; Solaris 8
I set default font to Lucidatypewriter, regular, 10 pt. I set my
default alignment to Wrap Text Automatically. Vertical and
Horizontal Text Alignment are Default. Row Height->Default Value
returns with 0.17" but for rows where the text actually wraps, the
"Row Height" with "Optimal Row Height" set to Default is 0.29", so
my wrapped lines don't fit within the space allocated on the printed
page and on the Page Preview.
If I set the Optimal Row Height to add 0.1" it appears OK and prints
OK. (I tried 0.05, but that was rounded up to 0.1, 0.04 rounded down
to 0.0)
Wrinkle - actually, they do fit on the screen display, but not on
the Page Preview and not on the printed page. The Cell Style
Default Font says "The same font will be used on both your printer
and your screen."
Is it an issue? Am I messing up somewhere?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
If you're seeking, check out http://www.rci.org.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
