At 14:46 24/07/2008 +0000, Steve Noname wrote:
I posted this to the OO.org forum, but have gotten no replies. It
appears to be a bug with Calc. It appears that one cannot print a
newly added worksheet in Calc if the file originated in Excel. Note
that I have Calc set to save files in xls format so I can handle
work files at home.
I am a new user of OoO, but not new to spreadsheets. I have worked a
lot in Excel and have converted all my Excel sheets to OoO Calc
format. I am having problems printing individual sheets in a
workbook. Here are symptoms:
1-Spreadsheet workbook created in Excel with multiple worksheets
2-Converted to Calc and set program to save as an XLS file.
3-Entered Calc, copies a sheet in workbook to use as a template for
some new data
4-Edited copied sheet and attempt to print
5-Print option is set to print selected sheet
6-What prints is one of the original worksheets, not the new sheet I
copied and modified. What goes to printer is the worksheet I copied
to create the new one.
7-This also happens if I just create a new blank worksheet and try
to print it.
8-It appears I cannot print any new worksheet if it is in a workbook
that originated in Excel.
9-I can print the new sheet IF I create a new Calc workbook file,
return to the Excel-Calc file and copy the sheet I copied/modified
in the old file into the new one.
Is there some setting I'm missing that is causing this problem?
This is only a guess, but does your copied original sheet have a
print range defined? In Calc, any defined print range operates for
the entire spreadsheet - all its sheets, that is. So if you define a
print range somewhere in your document, only that part or those parts
will ever print. If there is a print range defined on your copied
sheet but not on your new, modified one, you cannot print the new
one. Either add (part of?) the new sheet to your print range or else
delete the existing defined range (using Format | Print Ranges > |
Remove - from the relevant sheet).
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
