Ubuntu
openoffice.org package

Problem in Print Range 0 Rows to repeat

Asked by Nisha

HI

while selecting row to repeat on top of new page, an error occurred "Invalid Sheet Reference".
 I tried manual insertion of sheet name but results are same.

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 Nisha

This is a known bug. The way to cure it is to do the following:

1. Go to Tools > Options...

2. Select OpenOffice.org Calc > Sort Lists

3. Click at the end of the drop-down list of Formula Syntax to show the full list

4. Select Calc A1 with the mouse (do this even though Calc A1 is already the selected option)

5 Click OK

That should cure the 'Invalid Sheet Reference' problem with Print Ranges.

Tony

PS If this answers your question - please mark it as Solved

Revision history for this message
Nisha (nisha-gupta) said : 		#2

Thanks Tony Pursell, that solved my question.