Problem in Print Range 0 Rows to repeat

Asked by Nisha


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

English Edit question
Ubuntu Edit question
No assignee Edit question
Solved by:
Tony Pursell
Last query:
Last reply:
Revision history for this message
Best Tony Pursell (ajpursell) said :

Hi Nisha

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

1. Go to Tools > Options...

2. Select 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.


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

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

Thanks Tony Pursell, that solved my question.