Comment 13 for bug 374708

Revision history for this message
mfn (mfn) wrote : Re: Invalid sheet reference

Is it possible to include this workaround https://bugzilla.novell.com/show_bug.cgi?id=502641#c12 in the package?

--- snip ---
The problem is that the syntax check in areasdlg.cxx fails if there is no
formula grammar specified in the user configuration. In that case
lcl_CheckRepeatOne() just returns "false" instead of trying with the default
grammar. As a workaround try the following:

1. Select Tools/Options... from the menu
2. In the left tree navigate to OpenOffice.org Calc/Formula
3. Click on the Arrow right to "Calc A1" to see the list of possible grammars
and select "Calc A1" explicitely from the dropdown list (even if it was already
selected)
4. Press "OK" to save