array formulas

[kix <g....@gmx.net>]

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org