Visit Format -> Print Ranges -> Edit
You can select the range, repeat row(s), repeat column(s) when print this spreadsheet.
Somehow, when you click “OK” to accept the settings, an error – Invalid sheet reference may occurs.
It is strange bug. If you install the official OpenOffice.org from OpenOffice.org
This bug will not appear. (That means this bug comes from Distribution ?)
Then press OK, and this bug is fixed.