From 08aa6d1730c121f29a5e0cc70d331628a354954a Mon Sep 17 00:00:00 2001 From: PJ Fanning Date: Tue, 17 Oct 2023 14:27:25 +0000 Subject: [PATCH] [bug-67784] add test for divide error git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1913064 13f79535-47bb-0310-9956-ffa450edef68 --- .../poi/ss/formula/functions/TestErrors.java | 26 +++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 poi/src/test/java/org/apache/poi/ss/formula/functions/TestErrors.java diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestErrors.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestErrors.java new file mode 100644 index 0000000000..877f9c17a1 --- /dev/null +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestErrors.java @@ -0,0 +1,26 @@ +package org.apache.poi.ss.formula.functions; + +import org.apache.poi.hssf.usermodel.HSSFCell; +import org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator; +import org.apache.poi.hssf.usermodel.HSSFRow; +import org.apache.poi.hssf.usermodel.HSSFWorkbook; +import org.apache.poi.ss.usermodel.FormulaError; +import org.junit.jupiter.api.Test; + +import java.io.IOException; + +import static org.apache.poi.ss.util.Utils.assertError; + +final class TestErrors { + @Test + void testTextDivide() throws IOException { + try (HSSFWorkbook wb = new HSSFWorkbook()) { + HSSFRow row = wb.createSheet().createRow(0); + HSSFCell cell = row.createCell(0); + cell.setCellValue("text"); + HSSFCell evalCell = row.createCell(1); + HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb); + assertError(fe, evalCell, "A1/2", FormulaError.VALUE); + } + } +} -- 2.39.5