Help with printing a single sheet

[Harlow]

I have recently moved my company away from MS Office and over to OpenOffice, unfortunately one of my users is experiancing a problem with a converted xls file..

The file has 13 sheets, everytime I try to print it will only print sheet 10 & 13

I have tried the Tools / Options / Spreedsheet / Print > Print Only Selected Sheets route but with no joy, I get nothing at all out of the printer?!?!

Even if I use the File / Print > Print Range > Pages and select, say, sheet 11 I get nothing, it is as if all other sheets are locked from being printed !

Any ideas would be greatfully appreciated...

Regards
Adam

btw.. it works perfectly in Excel !!

[8daysaweek.co.uk]

Hello Adam,

IME this only happens with converted files, why I don't know.

To fix try clicking the square between row numbers and column letters (select all) on the sheets you cannot print, then:

Format > Print Ranges > Define

Previous threads on the same subject:
http://www.oooforum.org/forum/viewtopic.php?t=6248&highlight=print+range
http://www.oooforum.org/forum/viewtopic.php?t=8351&highlight=print+range

HTH ,
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site