You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/10/03 13:34:33 UTC

DO NOT REPLY [Bug 43354] Optional function arguments problems.

https://issues.apache.org/bugzilla/show_bug.cgi?id=43354


Antti Koskimäki <an...@joinex.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |ASSIGNED




--- Comment #2 from Antti Koskimäki <an...@joinex.com>  2008-10-03 04:34:32 PST ---

This does still happen, with r701302. Some earlier versions failed on
parse-phase, thus "hiding" this bug.

Easy to reproduce:

Excel having "=IF(B1=1,5,)" in cell A1

Evaluate it:
cell = sheet.getRow(0).getCell(0);
if(cell.getCellType() == HSSFCell.CELL_TYPE_FORMULA) {
    evaluator.evaluateFormulaCell(cell);
}

Get exception:

java.util.EmptyStackException
        at java.util.Stack.peek(Stack.java:85)
        at java.util.Stack.pop(Stack.java:67)
        at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:300)
        at
org.apache.poi.ss.formula.WorkbookEvaluator.internalEvaluate(WorkbookEvaluator.java:213)
        at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:179)
        at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:272)
        at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCell(HSSFFormulaEvaluator.java:165)


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org