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

sktsee sktsee at tulsaconnect.com
Wed Feb 10 17:04:10 UTC 2010


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

-- 
sktsee





More information about the ubuntu-users mailing list