It is not yet supported (to the best of my knowledge). I don't even
think we yet expose the flag to the
usermodel. The changes will require:
1. changes to the utility used to grok references to row/cell numbers
2. additional work on formulae
3. minor work in the high and low level model to enable the underlying
flags to change. (this should hint the
formula stuff on what mode to use)
-Andy
[EMAIL PROTECTED] wrote:
>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]>
>
>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
