I was testing the formula support with POI.1.7 and When I try to use R1C1 style formulas I get the following error.
String index out of range: 0 java.lang.StringIndexOutOfBoundsException: String index out of range: 0 at java.lang.String.charAt(String.java:507) at org.apache.poi.hssf.util.CellReference.<init>(CellReference.java:78) at org.apache.poi.hssf.record.formula.ReferencePtg.<init>(ReferencePtg.java:90) at org.apache.poi.hssf.record.formula.FormulaParser.Ident(FormulaParser.java:25 8) at org.apache.poi.hssf.record.formula.FormulaParser.Factor(FormulaParser.java:3 09) at org.apache.poi.hssf.record.formula.FormulaParser.Term(FormulaParser.java:353 ) at org.apache.poi.hssf.record.formula.FormulaParser.Expression(FormulaParser.ja va:398) at org.apache.poi.hssf.record.formula.FormulaParser.Arguments(FormulaParser.jav a:285) at org.apache.poi.hssf.record.formula.FormulaParser.Ident(FormulaParser.java:24 5) at org.apache.poi.hssf.record.formula.FormulaParser.Factor(FormulaParser.java:3 09) at org.apache.poi.hssf.record.formula.FormulaParser.Term(FormulaParser.java:353 ) at org.apache.poi.hssf.record.formula.FormulaParser.Expression(FormulaParser.ja va:398) at org.apache.poi.hssf.record.formula.FormulaParser.parse(FormulaParser.java:43 6) at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula(HSSFCell.java:705) at POITest.createI18NExcel(POITest.java:167) at POITest.main(POITest.java:183) Does anyone know if R1C1 style is supported? Thanks in advance. Sam -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
