Comment 5 for bug 157474

Found the solution. The default since OpenOffice.org 2.3 is that it only prints the selected (work)sheets. But if you look at the print example (how it would look if you print it, "afdrukvoorbeeld" in Dutch) you'll see all the sheets. So suppose you want to print sheet 4, it will (probably) appear as page 4 on your print example, but you'll have to print it as page 1. Otherwise OOo won't print anything. So it's actually a bug in OOo: OOo should show a different print example.

Unfortunately my solution won't work out for the original poster.