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
https://issues.apache.org/bugzilla/show_bug.cgi?id=56859

            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.

example: 

IF($J$5=1,SYD($B16,$D16,$C16,F$12),SLN($B16,$D16,$C16))

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
detected.

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);
fe.evaluateFormulaCell(cell);

-- 
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