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 2024/06/21 20:03:50 UTC
svn commit: r1918499 - /poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestText.java
Author: fanningpj
Date: Fri Jun 21 20:03:50 2024
New Revision: 1918499
URL: http://svn.apache.org/viewvc?rev=1918499&view=rev
Log:
add test related to bug-69147
Modified:
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestText.java
Modified: poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestText.java
URL: http://svn.apache.org/viewvc/poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestText.java?rev=1918499&r1=1918498&r2=1918499&view=diff
==============================================================================
--- poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestText.java (original)
+++ poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestText.java Fri Jun 21 20:03:50 2024
@@ -23,6 +23,7 @@ import static org.junit.jupiter.api.Asse
import java.text.DateFormatSymbols;
import java.text.DecimalFormatSymbols;
import java.text.SimpleDateFormat;
+import java.time.LocalDate;
import java.util.Arrays;
import java.util.List;
import java.util.TimeZone;
@@ -33,6 +34,7 @@ import org.apache.poi.ss.formula.eval.Er
import org.apache.poi.ss.formula.eval.NumberEval;
import org.apache.poi.ss.formula.eval.StringEval;
import org.apache.poi.ss.formula.eval.ValueEval;
+import org.apache.poi.ss.usermodel.DateUtil;
import org.apache.poi.util.LocaleUtil;
import org.junit.jupiter.api.Test;
@@ -278,6 +280,12 @@ final class TestText {
testText(BoolEval.FALSE, new StringEval("#0.000"), BoolEval.FALSE.getStringValue());
}
+ @Test
+ void testTextMMM() {
+ LocalDate ld = LocalDate.parse("2022-02-28");
+ testText(new NumberEval(DateUtil.getExcelDate(ld)), new StringEval("MMM"), "Feb");
+ }
+
private void testText(ValueEval valueArg, ValueEval formatArg, String expectedResult) {
ValueEval[] args = { valueArg, formatArg };
ValueEval result = TextFunction.TEXT.evaluate(args, -1, -1);
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org