Make sure that the Page mode is set to landscape and that the columns fall within the margins/boundaries, otherwise this is why there will be blank pages (Print Preview will show you this too).........
openoffice calc landscape printing problem
OpenOffice.org 3.2.1
OOO320m19 (Build:9505)
ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1.
It's not extending the printing and margins all the way to the edge even when setting the Page and print settings to Landscape
Solution (incorrect margins set under Page):
*Check the margins, my right margin was like 14cm!........