https://bz.apache.org/bugzilla/show_bug.cgi?id=59132
Bug ID: 59132
Summary: Evaluation of COUNTBLANK() doesn't act as same
behavior of Excel
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: sunnylau175@gmail.com
Created attachment 33634
--> https://bz.apache.org/bugzilla/attachment.cgi?id=33634&action=edit
the excel file of my example
I have found an issue about evaluation of COUNTBLANK() via POI. In excel, when
I assign a blank string "" to a cell and use COUNTBLANK() to count, it would
count a blank string cell as a blank cell.
However, when I use POI to evaluate the same cell which contain formula
COUNTBLANK(), the result of evaluation is that the blank string　"" cell is not
counted.
For example:
[Column A] [Column B]
=IF(ISBLANK(B1),"",B1) Peter
=IF(ISBLANK(B2),"",B2) Tom
=IF(ISBLANK(B3),"",B3) Alice
=IF(ISBLANK(B4),"",B4) Zoe
=COUNTBLANK(A1:A4)
When I delete "Alice" and use
FormulaEvaluator evaluator =
workbook.getCreationHelper().createFormulaEvaluator();
evaluator.evaluateFormulaCell(cell);
to evaluate cell A5, the result is 0. But when I use excel to do the same
thing, the result is 1.
I think it is a bug because POI should not act as different behavior than
excel.
--
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
|