poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 56859] New: IF Function evaluation
Date Fri, 15 Aug 2014 09:04:40 GMT

            Bug ID: 56859
           Summary: IF Function evaluation
           Product: POI
           Version: 3.10-FINAL
          Hardware: PC
                OS: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: tina@ublys.com

I have a cell with an IF statement. The condition inside the IF statement uses
2 different unsupported functions.



When I evaluated the cell, only 1 condition was evaluated by POI (which is the
TRUE part of the IF statement). In the example, only the SYD function was

Is there a way that POI will evaluate both conditions of the IF statement so
that both unsupported functions will be detected?

I am using XLSX file so I'm using XSSFWorkbook.

This is my code in evaluating the cell:

XSSFFormulaEvaluator fe = new XSSFFormulaEvaluator(wb);

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

View raw message