diff options
| -rw-r--r-- | poi/src/test/java/org/apache/poi/ss/formula/functions/TestProduct.java | 24 | ||||
| -rw-r--r-- | poi/src/test/java/org/apache/poi/ss/formula/functions/TestWorkdayFunc.java | 52 |
2 files changed, 76 insertions, 0 deletions
diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestProduct.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestProduct.java index 7f5bc5a1dc..fa6b705753 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestProduct.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestProduct.java @@ -16,6 +16,11 @@ ==================================================================== */ 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.HSSFSheet; +import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.formula.eval.BoolEval; import org.apache.poi.ss.formula.eval.MissingArgEval; import org.apache.poi.ss.formula.eval.NumberEval; @@ -23,6 +28,9 @@ import org.apache.poi.ss.formula.eval.StringEval; import org.apache.poi.ss.formula.eval.ValueEval; import org.junit.jupiter.api.Test; +import java.io.IOException; + +import static org.apache.poi.ss.util.Utils.assertDouble; import static org.junit.jupiter.api.Assertions.assertEquals; import static org.junit.jupiter.api.Assertions.assertTrue; @@ -65,6 +73,22 @@ class TestProduct { assertEquals(12, ((NumberEval)result).getNumberValue(), 0); } + @Test + void test2Booleans() throws IOException { + try (HSSFWorkbook wb = new HSSFWorkbook()) { + HSSFSheet sheet = wb.createSheet(); + HSSFRow row0 = sheet.createRow(0); + HSSFRow row1 = sheet.createRow(1); + row0.createCell(0).setCellValue(true); + row0.createCell(1).setCellValue(true); + HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb); + HSSFCell cell = row1.createCell(0); + assertDouble(fe, cell, "PRODUCT(TRUE,TRUE)", 1.0, 0.000001); + assertDouble(fe, cell, "PRODUCT(A1:B1)", 0.0, 0.000001); + assertDouble(fe, cell, "PRODUCT(A1,B1)", 0.0, 0.000001); + } + } + private static Function getInstance() { return AggregateFunction.PRODUCT; } diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestWorkdayFunc.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestWorkdayFunc.java new file mode 100644 index 0000000000..96260443f6 --- /dev/null +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestWorkdayFunc.java @@ -0,0 +1,52 @@ +/* ==================================================================== + Licensed to the Apache Software Foundation (ASF) under one or more + contributor license agreements. See the NOTICE file distributed with + this work for additional information regarding copyright ownership. + The ASF licenses this file to You under the Apache License, Version 2.0 + (the "License"); you may not use this file except in compliance with + the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, software + distributed under the License is distributed on an "AS IS" BASIS, + WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + See the License for the specific language governing permissions and + limitations under the License. +==================================================================== */ + +package org.apache.poi.ss.formula.functions; + +import org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator; +import org.apache.poi.hssf.usermodel.HSSFWorkbook; +import org.apache.poi.ss.usermodel.Cell; +import org.apache.poi.ss.usermodel.DateUtil; +import org.apache.poi.ss.usermodel.Row; +import org.apache.poi.ss.usermodel.Sheet; +import org.junit.jupiter.api.Test; + +import java.io.IOException; +import java.time.LocalDate; + +import static org.apache.poi.ss.util.Utils.assertDouble; + +/** + * Tests WORKDAY(start_date, days, [holidays]) excel function + * https://support.microsoft.com/en-us/office/workday-function-f764a5b7-05fc-4494-9486-60d494efbf33 + */ +class TestWorkdayFunc { + @Test + void testCellRefs() throws IOException { + try (HSSFWorkbook wb = new HSSFWorkbook()) { + Sheet sheet = wb.createSheet(); + Row row0 = sheet.createRow(0); + Cell cellA1 = row0.createCell(0); + Cell cellB1 = row0.createCell(1); + cellA1.setCellValue(LocalDate.parse("2024-10-29")); + cellB1.setCellValue(5); + Cell cellResult = sheet.createRow(1).createCell(0); + HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb); + assertDouble(fe, cellResult, "WORKDAY(A1,5)", DateUtil.getExcelDate(LocalDate.parse("2024-11-05"))); + } + } +} |