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 2014/08/15 11:04:40 UTC
[Bug 56859] New: IF Function evaluation
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
[Bug 56859] IF Function evaluation
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56859
Tina Parro <ti...@ublys.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|P2 |P1
CC| |tina@ublys.com
--
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
[Bug 56859] IF Function evaluation
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56859
--- Comment #2 from Tina Parro <ti...@ublys.com> ---
I tried downloading the 3.11 beta 1 version but the download page is returning
an error
Not Found
The requested URL /pub/apache/poi/dev/bin/poi-bin-3.11-beta1-20140808.zip was
not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an
ErrorDocument to handle the request.
I also tried the other mirror servers but it has the same error.
(In reply to Nick Burch from comment #1)
> Can you try with 3.11 beta 1? There were some formula parsing changes in
> that, would be good to confirm if they've affected it or not
--
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
[Bug 56859] IF Function evaluation
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56859
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
Can you try with 3.11 beta 1? There were some formula parsing changes in that,
would be good to confirm if they've affected it or not
--
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
[Bug 56859] IF Function evaluation
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56859
--- Comment #3 from Nick Burch <ap...@gagravarr.org> ---
Looks like a typo in the link on the download page, sorry :(
Can you try now?
--
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
[Bug 56859] IF Function evaluation
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56859
Tina Parro <ti...@ublys.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--
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
[Bug 56859] IF Function evaluation
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56859
--- Comment #4 from Tina Parro <ti...@ublys.com> ---
I already installed 3.11 beta 1 but the result is still the same. I still got
NotImplementedFunctionException but it only returned SYD as the cause of the
error.
This is the returned error:
Exception: NotImplementedFunctionException
Cause: org.apache.poi.ss.formula.eval.NotImplementedFunctionException: SYD
Detail cause: Error evaluating cell Schedule!H9
--
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