From 9193c4171e65903cc96d8ae63574088e21fcc3ed Mon Sep 17 00:00:00 2001 From: Nick Burch Date: Fri, 8 Apr 2011 15:25:17 +0000 Subject: [PATCH] Bit more testing for 51024 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1090295 13f79535-47bb-0310-9956-ffa450edef68 --- src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java b/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java index cb1ba7da91..2dfe1a01ae 100644 --- a/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java +++ b/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java @@ -2099,10 +2099,17 @@ if(1==2) { c.setCellFormula("VLOOKUP(\"v A1\", A1:B2, 1, 1)"); assertEquals("v A1", eval.evaluate(c).getStringValue()); + c.setCellFormula("VLOOKUP(\"v A1\", A1:B2, 1, )"); + assertEquals("v A1", eval.evaluate(c).getStringValue()); + + c.setCellFormula("HLOOKUP(\"v A1\", A1:B2, 1)"); assertEquals("v A1", eval.evaluate(c).getStringValue()); c.setCellFormula("HLOOKUP(\"v A1\", A1:B2, 1, 1)"); assertEquals("v A1", eval.evaluate(c).getStringValue()); + + c.setCellFormula("HLOOKUP(\"v A1\", A1:B2, 1, )"); + assertEquals("v A1", eval.evaluate(c).getStringValue()); } } -- 2.39.5