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