hi, I observed that if an excel sheet contains an array formula, a RecordFormatException will be thrown when cell[i].getValue() is executed. This exception contains the text "Expected ExpPtg to be converted from Shared to Non-Shared Formula". In my sense this message is misleading. I think it would clarify some things if you could change the message text. Are you going to support array formulas in future??
http://www.nabble.com/file/p12277474/array-formula.xls array-formula.xls org.apache.poi.hssf.record.RecordFormatException: Coding Error: Expected ExpPtg to be converted from Shared to Non-Shared Formula at org.apache.poi.hssf.record.formula.ExpPtg.toFormulaString(ExpPtg.java:78) at org.apache.poi.hssf.model.FormulaParser.toFormulaString(FormulaParser.java:886) at org.apache.poi.hssf.model.FormulaParser.toFormulaString(FormulaParser.java:868) at org.apache.poi.hssf.usermodel.HSSFCell.getCellFormula(HSSFCell.java:630) at at.rzb.lib.poi.Cell.evaluateInCell(Cell.java:264) at at.rzb.lib.poi.Cell.getValue(Cell.java:192) at at.rzb.lib.poi.ExcelTest.testWorkbooks(ExcelTest.java:73) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60) at java.lang.reflect.Method.invoke(Method.java:391) at junit.framework.TestCase.runTest(TestCase.java:154) at junit.framework.TestCase.runBare(TestCase.java:127) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:436) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:311) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) -- View this message in context: http://www.nabble.com/array-formulas-tf4312412.html#a12277474 Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
