OpenOffice 3.1. - Calc: How to correct or get rid of the "invalid sheet reference"?

sktsee sktsee at
Thu Feb 11 01:45:05 UTC 2010

On Wed, 10 Feb 2010 09:36:00 -0800, NoOp wrote:

> On 02/10/2010 09:04 AM, sktsee wrote:
>> Yeah, its a bug that's apparently been around a little while.
>> Fortunately, there's an easy workaround if its the same bug I think
>> you're running into.
>> 1. From the menu, go to Tools->Options->OpenOffice Calc->Formula 2.
>> Click on the Formula syntax dropdown and select "Excel A1". Click it
>> again and change it back to "Calc A1" 3 Click OK button.
>> Now you should be able to set user-defined repeating row/column
>> printing range values.
>> Here's the link to the commenter in a novell bug report who explains
>> what the isse is and provides the workaround.
> Interesting... I had no issues with Bas' spreadsheet - perhaps because
> my default setting was already at 'Calc A1'. My local is: $ locale

As I understand it, the problem occurs usually if you have a newly 
created profile, and you haven't made any config changes in the Calc 
options. In which case the file that contains the Formula syntax setting, 
never gets created. When OO goes to look for the formula syntax, it 
doesn't have a default defined and throws up the error Bas got. I can 
recreate the bug if I rename that file and open a spreadsheet that 
doesn't have a print range already defined then try to set a repeating 
row print range.


More information about the ubuntu-users mailing list