https://bz.apache.org/bugzilla/show_bug.cgi?id=62275
--- Comment #10 from Dominik Stadler ---
At least the documentation at
https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
indicates that the default is "true", was the statement about Excel using
https://bz.apache.org/bugzilla/show_bug.cgi?id=62275
--- Comment #9 from Javen O'Neal ---
(In reply to dolphin.in.the.sky.51 from comment #7)
> In EXCEL, when the fourth argument of the vlookup function is "empty",
> it operates in the same way as when FALSE is specified.
https://bz.apache.org/bugzilla/show_bug.cgi?id=62275
Dominik Stadler changed:
What|Removed |Added
Resolution|--- |FIXED
Status|REOPENED
https://bz.apache.org/bugzilla/show_bug.cgi?id=62275
dolphin.in.the.sky...@gmail.com changed:
What|Removed |Added
Status|RESOLVED|REOPENED
https://bz.apache.org/bugzilla/show_bug.cgi?id=62275
PJ Fanning changed:
What|Removed |Added
Status|NEW |RESOLVED
Resolution|---
The current code blows up because the 4th param is empty (resulting in a
MissingArgEval issue) - the code will pass is the 4th param is set to the
true (the default for this param)
https://www.techonthenet.com/excel/formulas/vlookup.php
--
Sent from:
https://bz.apache.org/bugzilla/show_bug.cgi?id=62275
--- Comment #5 from dolphin.in.the.sky...@gmail.com ---
It reproduced with the following test case.
public void test62275_bug() throws IOException {
Workbook wb = new XSSFWorkbook();
Sheet sheet =
https://bz.apache.org/bugzilla/show_bug.cgi?id=62275
--- Comment #4 from PJ Fanning ---
Could you provide a full test case?
--
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail:
https://bz.apache.org/bugzilla/show_bug.cgi?id=62275
--- Comment #3 from dolphin.in.the.sky...@gmail.com ---
This bug is not fixed.
Even in the latest nightly build, it is reproduced with the following code.
CreationHelper crateHelper = wb.getCreationHelper();
FormulaEvaluator eval =
https://bz.apache.org/bugzilla/show_bug.cgi?id=62275
--- Comment #2 from PJ Fanning ---
Can you check with the latest nightly build?
https://poi.apache.org/download.html#nightly
I think that we might have added a fix for this already.
--
You are receiving this mail because:
You are the
https://bz.apache.org/bugzilla/show_bug.cgi?id=62275
--- Comment #1 from Taiki Sugawara ---
I also encountered this bug.
I think it will be fixed that if we check the last argument is MissingArgEval
in following classes:
- Var1or2ArgFunction
- Var2or3ArgFunction
- Var3or4ArgFunction
What do
11 matches
Mail list logo