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 2021/10/03 17:07:22 UTC
svn commit: r1893858 - in
/poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions:
TestWeekNumFunc.java TestWeekdayFunc.java
Author: fanningpj
Date: Sun Oct 3 17:07:22 2021
New Revision: 1893858
URL: http://svn.apache.org/viewvc?rev=1893858&view=rev
Log:
add weekday tests
Modified:
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestWeekNumFunc.java
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestWeekdayFunc.java
Modified: poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestWeekNumFunc.java
URL: http://svn.apache.org/viewvc/poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestWeekNumFunc.java?rev=1893858&r1=1893857&r2=1893858&view=diff
==============================================================================
--- poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestWeekNumFunc.java (original)
+++ poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestWeekNumFunc.java Sun Oct 3 17:07:22 2021
@@ -30,7 +30,7 @@ import static org.junit.jupiter.api.Asse
import static org.junit.jupiter.api.Assertions.fail;
/**
- * Tests WEEKNUM(date[, return_type]) excep function
+ * Tests WEEKNUM(date[, return_type]) excel function
* https://support.microsoft.com/en-us/office/weeknum-function-e5c43a03-b4ab-426c-b411-b18c13c75340
*/
class TestWeekNumFunc {
Modified: poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestWeekdayFunc.java
URL: http://svn.apache.org/viewvc/poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestWeekdayFunc.java?rev=1893858&r1=1893857&r2=1893858&view=diff
==============================================================================
--- poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestWeekdayFunc.java (original)
+++ poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestWeekdayFunc.java Sun Oct 3 17:07:22 2021
@@ -18,13 +18,16 @@
package org.apache.poi.ss.formula.functions;
import org.apache.poi.ss.formula.eval.*;
+import org.apache.poi.ss.usermodel.DateUtil;
import org.apache.poi.util.StringUtil;
import org.junit.jupiter.api.Test;
+import java.time.LocalDate;
+
import static org.junit.jupiter.api.Assertions.*;
/**
- * Tests WEEKDAY(serial_number[, return_type]) excep function
+ * Tests WEEKDAY(serial_number[, return_type]) excel function
* https://support.office.com/en-us/article/WEEKDAY-function-60E44483-2ED1-439F-8BD0-E404C190949A
*/
class TestWeekdayFunc {
@@ -71,6 +74,15 @@ class TestWeekdayFunc {
assertEvaluateEquals(3.0, 39448.0, 17.0);
}
+
+ @Test
+ void testMicrosoftExamples() {
+ double date = DateUtil.getExcelDate(LocalDate.parse("2008-02-14"));
+ assertEvaluateEquals(5.0, date);
+ assertEvaluateEquals(4.0, date, 2);
+ assertEvaluateEquals(3.0, date, 3);
+ }
+
// for testing invalid invocations
private void assertEvaluateEquals(String message, ErrorEval expected, ValueEval... args) {
String formula = "WEEKDAY(" + StringUtil.join(args, ", ") + ")";
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org