You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by fa...@apache.org on 2022/06/05 19:16:54 UTC
svn commit: r1901684 - /poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestCorrel.java
Author: fanningpj
Date: Sun Jun 5 19:16:54 2022
New Revision: 1901684
URL: http://svn.apache.org/viewvc?rev=1901684&view=rev
Log:
support string cells in correl function
Modified:
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestCorrel.java
Modified: poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestCorrel.java
URL: http://svn.apache.org/viewvc/poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestCorrel.java?rev=1901684&r1=1901683&r2=1901684&view=diff
==============================================================================
--- poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestCorrel.java (original)
+++ poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestCorrel.java Sun Jun 5 19:16:54 2022
@@ -37,7 +37,7 @@ final class TestCorrel {
//https://support.microsoft.com/en-us/office/correl-function-995dcef7-0c0a-4bed-a3fb-239d7b68ca92
@Test
void testMicrosoftExample1() throws IOException {
- try (HSSFWorkbook wb = initWorkbook1(false)) {
+ try (HSSFWorkbook wb = initWorkbook1()) {
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow row = sheet.getRow(0);
HSSFCell cell = row.createCell(100);
@@ -48,7 +48,7 @@ final class TestCorrel {
@Test
void testBlankValue() throws IOException {
- try (HSSFWorkbook wb = initWorkbook1(true)) {
+ try (HSSFWorkbook wb = initWorkbook1(null)) {
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow row = sheet.getRow(0);
HSSFCell cell = row.createCell(100);
@@ -57,18 +57,29 @@ final class TestCorrel {
}
}
- private HSSFWorkbook initWorkbook1(boolean blankRow4) {
+ @Test
+ void testStringValue() throws IOException {
+ try (HSSFWorkbook wb = initWorkbook1("string")) {
+ HSSFSheet sheet = wb.getSheetAt(0);
+ HSSFRow row = sheet.getRow(0);
+ HSSFCell cell = row.createCell(100);
+ HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb);
+ assertDouble(fe, cell, "CORREL(A2:A6,B2:B6)", 0.9984884738, 0.0000000005);
+ }
+ }
+
+ private HSSFWorkbook initWorkbook1() {
+ return initWorkbook1(Double.valueOf(15));
+ }
+
+ private HSSFWorkbook initWorkbook1(Object row4Data2) {
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet();
addRow(sheet, 0, "Data1", "Data2");
addRow(sheet, 1, 3, 9);
addRow(sheet, 2, 2, 7);
addRow(sheet, 3, 4, 12);
- if (blankRow4) {
- addRow(sheet, 4, 5);
- } else {
- addRow(sheet, 4, 5, 15);
- }
+ addRow(sheet, 4, 5, row4Data2);
addRow(sheet, 5, 6, 17);
return wb;
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org