星期三, 9月 08, 2010

openoffice calc pop invalid sheet reference

openoffice.org-calc 在選取列印範圍時,會跳出 "Invalid Sheet reference." 的錯誤訊息。

在 http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=527535 提到暫時解決方法:

http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=527535#37

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

即可。

我的環境為
Debian squeeze/sid
OpenOffice.org 3.2.1 , Debian package 1:3.2.1-6

沒有留言: