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

[sktsee]

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.
>> 
>> https://bugzilla.novell.com/show_bug.cgi?id=502641#c12
>> 
>> 
> 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, 
~/.openoffice.org/3/user/registry/data/org/openoffice/Office/Calc.xcu, 
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.

-- 
sktsee