Friday, February 5, 2010

Print repeat header in Calc

Calc is a great electronic spreadsheet and have lots of functions to create a diverse range of apps.

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".

Solution:

  1. Open the Calc spreahsheet.
  2. In the menu choose Tools ->Option ->OpenOffice.org Calc ->Formula
  3. In Formula Syntax, it shows "Calc A1". Click on the dropdown box and choose "Calc A1".
  4. Click "Ok".
Link
Some trigger must have failed to detect the values as "Calc A1". Thank you Arnel for giving the solution in Oct 2009.

No comments: