I'm using POI 3.2 FINAL and I'm trying to run xsl2csvmra but I am getting an IndexOutOfBoundsException for the HSSFFormulaParser.toFormulaString. I cannot figure out what is wrong.
The file is simple, nothing more than a few numbers, named ranges, and formulas. It works if I don't try and get the formulas, but I need the formulas for what I am doing. The formula it crashes at is: =(2*N*(d_1*d_1+d_2*d_2)*(d_1+d_2)) Exception in thread "main" java.lang.IndexOutOfBoundsException: Index: 6, Size: 0 at java.util.ArrayList.RangeCheck(ArrayList.java:547) at java.util.ArrayList.get(ArrayList.java:322) at org.apache.poi.hssf.model.LinkTable.getNameRecord(LinkTable.java:264) at org.apache.poi.hssf.model.Workbook.getNameRecord(Workbook.java:1994) at org.apache.poi.hssf.usermodel.HSSFEvaluationWorkbook.getNameText(HSSFEvaluationWorkbook.java:110) at org.apache.poi.hssf.record.formula.NamePtg.toFormulaString(NamePtg.java:70) at org.apache.poi.ss.formula.FormulaRenderer.toFormulaString(FormulaRenderer.java:92) at org.apache.poi.hssf.model.HSSFFormulaParser.toFormulaString(HSSFFormulaParser.java:66) at XLS2CSV.processRecord(XLS2CSV.java:203) at org.apache.poi.hssf.eventusermodel.MissingRecordAwareHSSFListener.processRecord(MissingRecordAwareHSSFListener.java:157) at org.apache.poi.hssf.eventusermodel.FormatTrackingHSSFListener.processRecord(FormatTrackingHSSFListener.java:64) at org.apache.poi.hssf.eventusermodel.EventWorkbookBuilder$SheetRecordCollectingListener.processRecord(EventWorkbookBuilder.java:170) at org.apache.poi.hssf.eventusermodel.HSSFRequest.processRecord(HSSFRequest.java:137) at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents(HSSFEventFactory.java:143) , at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents(HSSFEventFactory.java:98) at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processWorkbookEvents(HSSFEventFactory.java:63) at XLS2CSV.process(XLS2CSV.java:126) at XLS2CSV.main(XLS2CSV.java:323) -- Michael Gray Phoenix Integration
