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

Bas Roufs basroufs at
Wed Feb 10 20:36:56 UTC 2010

Hello  Sktsee!

Thank  you very much for your input!

> 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.

It appeared to be the same bug as you thought already. Your
'workaround' works perfectly well.

> ..... 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.

By doing so, I managed to solve the problem! That is perfectly OK for now!


On the other hand - it can be useful to mention that this workaround
is still needed, so that the bug itself did not yet vanish seemingly.
That's why, I have added a comment to the bugreport mentioned above.

However it may be - thanks everybody!
Respectfully yours,

More information about the ubuntu-users mailing list