poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 59132] New: Evaluation of COUNTBLANK() doesn't act as same behavior of Excel
Date Sun, 06 Mar 2016 13:21:38 GMT
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


Mime
View raw message