| 发表于：2008-02-14 11:32:31 楼主 |
程序如下：
formula formula= new formula（4, 4,"countif（b2:b6,\"传输\")");
formula.setcellformat（format);
sheet.addcell（formula);
异常：
[08-2-14 11:12:54:296 cst] 0000006a systemerr r java.lang.arrayindexoutofboundsexception
[08-2-14 11:12:54:296 cst] 0000006a systemerr r at jxl.biff.formula.yylex.yylex（yylex.java:378)
[08-2-14 11:12:54:296 cst] 0000006a systemerr r at jxl.biff.formula.stringformulaparser.gettokens（stringformulaparser.java:268)
[08-2-14 11:12:54:296 cst] 0000006a systemerr r at jxl.biff.formula.stringformulaparser.parse（stringformulaparser.java:102)
[08-2-14 11:12:54:296 cst] 0000006a systemerr r at jxl.biff.formula.formulaparser.parse（formulaparser.java:98)
[08-2-14 11:12:54:296 cst] 0000006a systemerr r at jxl.write.biff.formularecord.initialize（formularecord.java:166)
[08-2-14 11:12:54:296 cst] 0000006a systemerr r at jxl.write.biff.formularecord.setcelldetails（formularecord.java:249)
[08-2-14 11:12:54:296 cst] 0000006a systemerr r at jxl.write.biff.writablesheetimpl.addcell（writablesheetimpl.java:821)
如果将程序修改为：
formula formula= new formula（4, 4,"countif（b2:b6,\"> 10\")");
formula.setcellformat（format);
sheet.addcell（formula);
则没有异常，请知道的人讲解一下是什么原因 非常感谢！！ |
|
|
|
|
