OpenOffice 3.1. - Calc: How to correct or get rid of the "invalid sheet reference"? SOLVED!
basroufs at gmail.com
Wed Feb 10 20:36:56 UTC 2010
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!
More information about the ubuntu-users