OpenOffice 3.1. - Calc: How to correct or get rid of the "invalid sheet reference"?
sktsee at tulsaconnect.com
Thu Feb 11 01:45:05 GMT 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