Since my upgrade to OpenOffice.org 3.1.1, I have not explored Calc much. When I tried to print a spreadsheet that ran across 40 pages. I tried to have the first 2 rows repeat as headers in every page, an error appeared "Invalid Sheet Range".
- Open the Calc spreahsheet.
- In the menu choose Tools ->Option ->OpenOffice.org Calc ->Formula
- In Formula Syntax, it shows "Calc A1". Click on the dropdown box and choose "Calc A1".
- Click "Ok".
Some trigger must have failed to detect the values as "Calc A1". Thank you Arnel for giving the solution in Oct 2009.