Ubuntu
openoffice.org package

printing row headings

Asked by Lee Templeton

I can not print the row containing column headings on pages after Pg. 1. This is a brand new problem with the version of OOo I downloaded on February 19, from Ubuntu.

3.1.1
build 9420
openoffice.org -core 1:3.1.1-5 ubuntu 1.1
Frid Feb 19 23-52:09 UTC 2010

I chose Format - Print Ranges - Edit
I then click the icon on the right and select the rows I want to print on every page.
Then I click OK, at which point a panel pops up and announces: Invalid Sheet Reference

This has not been a problem before. When I go back to older spread sheets and follow the routine above, the same error message pops up, even though they printed perfectly when created in times past.

Thanks, Lee Templeton.

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Tony Pursell
Solved:
Last query:
Last reply:
Revision history for this message
Best Tony Pursell (ajpursell) said : 		#1

Hi Lee,

This is already reported as a bug. There is a work around for it which works for me,

1. Select Tools/Options... from the menu
2. In the left tree navigate to OpenOffice.org Calc/Formula
3. Click on the Arrow right to "Calc A1" to see the list of possible grammars
and select "Calc A1" explicitly from the drop-down list (even if it was already
selected)
4. Press "OK" to save

Tony

Revision history for this message
Lee Templeton (pilgrim-ishmael) said : 		#2

Thanks Tony Pursell, that solved my question.