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

NoOp glgxg at sbcglobal.net
Wed Feb 10 17:36:00 UTC 2010


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
LANG=en_US.UTF-8
LANGUAGE=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

and Ubuntu/go-oo OOo version:
$ cat /usr/lib/openoffice/program/versionrc
[Version]
AllLanguages=en-US
BuildVersion=openoffice.org-core 1:3.1.1-5ubuntu1, Thu Oct 22 20:13:41
UTC 2009
buildid=310m19(Build:9420)
ExtensionUpdateURL=http://updateext.services.openoffice.org/ProductUpdateService/check.Update
OOOBaseVersion=3.1
ProductBuildid=9420
ProductMajor=310
ProductMinor=19
ProductSource=OOO310
UpdateID=OpenOffice.org_3_en-US
UpdateURL=
UpdateUserAgent=<PRODUCT> (${buildid}; ${_OS}; ${_ARCH};
BundledLanguages=${AllLanguages})
Vendor=Debian and Ubuntu

No issues either with standard OOo 3.2.0 buildid=320m12(Build:9483).






More information about the ubuntu-users mailing list