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

[NoOp]

On 02/10/2010 05:45 PM, sktsee wrote:
> 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.
> 

Even more interesting... Just checked on a base karmic install (64bit)
and (U)OOo 3.1 Tools|Options|Openoffic.org Calc|Formula doesn't even
exist. There is no 'Formula' option
Nor does it on a standard OOo 3.2.0.
Note: had to check the other machines since I have multiple OOo's
installed on this machine and have used for testing from 1.x.

I then checked on a lucid & it does out of the box. I then checked on a
32bit karmic (even removing ~/.openoffice.org) and it does exist there
as well.
So... on this machine I renamed my ~/.openoffice.org as well (karmic
32bit) and let it rebuild my (U)OOo profile just to see if the Formula
syntax setting appears in Tools|Options|Openoffic.org Calc|Formula, and
it's there. Of course Calc.xcu no longer appears in that
~/.openoffice.org folder - only in the installed folder:

$ locate Calc.xcu
/usr/lib/openoffice/basis3.1/share/registry/data/org/openoffice/Office/Calc.xcu

So now I try Bas' spreadsheet again (on the new profile for (U)OOo 3.1
karmic, and I do indeed get the error. And: Tools|Options|Openoffic.org
Calc|Formula is now present, as is:

/home/gg2xp/.openoffice.org/3/user/registry/data/org/openoffice/Office/Calc.xcu

Very educational... thanks sktsee.