diff options
author | PJ Fanning <fanningpj@apache.org> | 2022-05-28 13:53:30 +0000 |
---|---|---|
committer | PJ Fanning <fanningpj@apache.org> | 2022-05-28 13:53:30 +0000 |
commit | 1b0fac992cf2f9128707d278f0e01999ab79b378 (patch) | |
tree | d6550a3b5298a2cda9c2d847040bdc65f33f914a /poi/src/test | |
parent | e5b936f8041bec05a393d4b2a98c83f587a1843d (diff) | |
download | poi-1b0fac992cf2f9128707d278f0e01999ab79b378.tar.gz poi-1b0fac992cf2f9128707d278f0e01999ab79b378.zip |
fix issue with AVERAGEA function and how it handles string cells
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1901351 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'poi/src/test')
-rw-r--r-- | poi/src/test/java/org/apache/poi/ss/formula/functions/TestAverageA.java | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestAverageA.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestAverageA.java index 75bf4718af..b78eb6ce7c 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestAverageA.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestAverageA.java @@ -55,6 +55,16 @@ public class TestAverageA { } } + @Test + void testStringsWithNums() throws IOException { + try (HSSFWorkbook wb = initWorkbook3()) { + HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb); + HSSFCell cell = wb.getSheetAt(0).getRow(0).createCell(12); + assertDouble(fe, cell, "AVERAGEA(A2:A7)", 4.666666666666667, 0.00000000001); + assertDouble(fe, cell, "AVERAGE(A2:A7)", 7, 0.00000000001); + } + } + private HSSFWorkbook initWorkbook1() { HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet(); @@ -80,4 +90,17 @@ public class TestAverageA { addRow(sheet, 6, false); return wb; } + + private HSSFWorkbook initWorkbook3() { + HSSFWorkbook wb = new HSSFWorkbook(); + HSSFSheet sheet = wb.createSheet(); + addRow(sheet, 0, "Data"); + addRow(sheet, 1, 10); + addRow(sheet, 2, 7); + addRow(sheet, 3, 9); + addRow(sheet, 4, 2); + addRow(sheet, 5, "4.5"); + addRow(sheet, 6, "14"); + return wb; + } } |