Open Office, Software

Fix OpenOffice.org Calc Row(s) / Column(s) Repeat Printing Problem

fix-openoffice-org-calc-rows-columns-repeat-printing-problem

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.
Fix OpenOffice.org Calc Row(s) / Column(s) Repeat Printing Problem

We discovered that which is a bug reported from Launchpad (#374708) and Debian (#527535)

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 ?)

Nevermind. Let’s fix this bug first.
Visit Tools -> Options
Fix OpenOffice.org Calc Row(s) / Column(s) Repeat Printing Problem

Visit OpenOffice.org Calc -> Formula
Fix OpenOffice.org Calc Row(s) / Column(s) Repeat Printing Problem

Re-select Calc A1 at Formula Syntax
Fix OpenOffice.org Calc Row(s) / Column(s) Repeat Printing Problem

Then press OK, and this bug is fixed.