Producing PDFs from OpenOffice spreadheets

[Tony Arnold]

This is probably not the best list to ask this question, so feel free to
tell me to go away if it inappropriate!

I'm Using Ubuntu Hoary.

I have a spreadsheet with 4 work sheets in it and I am trying to produce
a PDF file containing all 4 sheets. Problem is that whenever I produce a
PDF it only prints the first worksheet regardless of what is selected!
In addition, if I try printing all worksheets to my printer, I only get
the first sheet.

This is really an OpenOffice issue, not an Ubuntu one, but if anyone has
any ideas on how to get round the problem, I'd appreciate it.

Many thanks in advance.

Regards,
Tony.
-- 
Tony Arnold, IT Security Coordinator, University of Manchester,
Manchester Computing, Kilburn Building, Oxford Road, Manchester M13 9PL.
T: +44 (0)161 275 6093, F: +44 (0)870 136 1004, M: +44 (0)773 330 0039
E: tony.arnold at manchester.ac.uk, H: http://www.man.ac.uk/Tony.Arnold