[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    NPE in HSSFFormulaEvaluator.evaluateFormulaCell()
From:       Mike Evans <mike.evans () rapid-mobile ! com>
Date:       2008-02-26 13:55:44
Message-ID: 47C41A60.6080500 () rapid-mobile ! com
[Download RAW message or body]

Hi All

I am getting a null pointer exception from 
HSSFFormulaEvaluator.evaluateFormulaCell() when I try to run the 
following code, similiar to that from the page 
http://poi.apache.org/hssf/eval.html on my spreadsheet.  The formulae 
are not complicated; if I catch the exception and print out the formulae 
that are failing I get the list below, although most of the formulae on 
the sheets are evaluated correctly.

Can anyone shed any light on this problem?  Is there something wrong 
with the format of the cells perhaps?

many thanks in advance
Mike Evans

        for(int sheetNum = 0; sheetNum < wb.getNumberOfSheets(); sheetNum++) {
            HSSFSheet sheet = wb.getSheetAt(sheetNum);
            HSSFFormulaEvaluator evaluator = new HSSFFormulaEvaluator(sheet, wb);

            for(Iterator<?> rit = sheet.rowIterator(); rit.hasNext();) {
                HSSFRow r = (HSSFRow)rit.next();
                evaluator.setCurrentRow(r);

                for(Iterator<?> cit = r.cellIterator(); cit.hasNext();) {
                    HSSFCell c = (HSSFCell)cit.next();
                    if(c.getCellType() == HSSFCell.CELL_TYPE_FORMULA) 
                        evaluator.evaluateFormulaCell(c);
                    }
                }
            }
        }


java.lang.NullPointerException

	org.apache.poi.hssf.record.formula.eval.ValueEvalToNumericXlator.xlateRefEval(ValueEvalToNumericXlator.java:165)
  org.apache.poi.hssf.record.formula.eval.ValueEvalToNumericXlator.attemptXlateToNumeric(ValueEvalToNumericXlator.java:91)
  org.apache.poi.hssf.record.formula.functions.NumericFunction.singleOperandEvaluate(NumericFunction.java:95)
  org.apache.poi.hssf.record.formula.functions.MultiOperandNumericFunction.getNumberArray(MultiOperandNumericFunction.java:142)
  org.apache.poi.hssf.record.formula.functions.MultiOperandNumericFunction.getNumberArray(MultiOperandNumericFunction.java:95)
  org.apache.poi.hssf.record.formula.functions.Sum.evaluate(Sum.java:55)
	org.apache.poi.hssf.record.formula.eval.FuncVarEval.evaluate(FuncVarEval.java:43)
	org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.internalEvaluate(HSSFFormulaEvaluator.java:395)
  org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCell(HSSFFormulaEvaluator.java:241)
                
	...



SUM(C7:C15)
SUM(D7:D15)
D16/C16
SUM(F7:F15)
SUM(G7:G15)
G16/F16
SUM(I7:I15)
SUM(J7:J15)
J16/I16
SUM(L7:L15)
SUM(M7:M15)
M16/L16
SUM(P7:P15)
SUM(Q7:Q15)
Q16/P16
SUM(C7:C15)
SUM(D7:D15)
D16/C16
SUM(F7:F15)
SUM(G7:G15)
G16/F16
SUM(I7:I15)
SUM(J7:J15)
J16/I16
SUM(L7:L15)
SUM(M7:M15)
M16/L16
SUM(O7:O15)
SUM(P7:P15)
P16/O16
SUM(R7:R15)
SUM(S7:S15)
S16/R16
SUM(U7:U15)
SUM(V7:V15)
V16/U16
SUM(Y7:Y15)
SUM(Z7:Z15)
Z16/Y16
SUM(C20:C28)
SUM(D20:D28)
D30/C30
SUM(F20:F28)
SUM(G20:G28)
G30/F30
SUM(I20:I28)
SUM(J20:J28)
J30/I30
SUM(L20:L28)
SUM(M20:M28)
M30/L30
SUM(O20:O28)
SUM(P20:P28)
P30/O30
SUM(R20:R28)
SUM(S20:S28)
S30/R30
SUM(U20:U28)
SUM(V20:V28)
V30/U30
SUM(Y20:Y28)
SUM(Z20:Z28)
Z30/Y30
SUM(C34:C42)
SUM(D34:D42)
D44/C44
SUM(F34:F42)
SUM(G34:G42)
G44/F44
SUM(I34:I42)
SUM(J34:J42)
J44/I44
SUM(L34:L42)
SUM(M34:M42)
M44/L44
SUM(O34:O42)
SUM(P34:P42)
P44/O44
SUM(R34:R42)
SUM(S34:S42)
S44/R44
SUM(U34:U42)
SUM(V34:V42)
V44/U44
SUM(Y34:Y42)
SUM(Z34:Z42)
Z44/Y44
SUM(C7:C9)
SUM(D7:D9)
D10/C10
SUM(F7:F9)
SUM(G7:G9)
G10/F10
SUM(I7:I9)
SUM(J7:J9)
J10/I10
SUM(L7:L9)
SUM(M7:M9)
M10/L10
SUM(O7:O9)
SUM(P7:P9)
P10/O10
SUM(R7:R9)
SUM(S7:S9)
S10/R10
SUM(U7:U9)
SUM(V7:V9)
V10/U10
SUM(Y7:Y9)
SUM(Z7:Z9)
Z10/Y10
-- 
Mike Evans
Rapid Mobile Ltd.
93 George St. Edinburgh EH2 3ES
Tel: +44 131 243 2502

-- 
Rapid Mobile Media Limited registered in Scotland No SC263541. 
Registered for VAT number GB 852 9018 19. 
Registered office 19A Canning Street, Edinburgh, EH3 8HE.
Contact number: +44(0)131 243 2502
For further information visit our website www.rapid-mobile.com


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


[prev in list] [next in list] [prev in thread] [next in thread]