https://bz.apache.org/bugzilla/show_bug.cgi?id=69147
Bug ID: 69147
Summary: TEXT Function Regression
Product: POI
Version: unspecified
Hardware: PC
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: dev@poi.apache.org
Reporter: aarbor...@gmail.com
Target Milestone: ---
Hello, I think https://bz.apache.org/bugzilla/show_bug.cgi?id=67475 has added a
regression for the TEXT function.
In 5.2.4 and previous, TEXT("02/28/2024", "MMM") returns "Feb". However, in
5.2.5, TEXT("02/28/2024", "MMM") returns "02/28/2024".
Here is a reproducer
> @Test
> void testTextFunction() throws Exception {
> try (HSSFWorkbook workbook = new HSSFWorkbook()) {
> Row row = workbook.createSheet().createRow(0);
> Cell formula = row.createCell(0);
> formula.setCellFormula("TEXT(\"02/28/2022\", \"MMM\")");
> FormulaEvaluator evaluator =
> workbook.getCreationHelper().createFormulaEvaluator();
> DataFormatter formatter = new DataFormatter(Locale.getDefault());
> evaluator.clearAllCachedResultValues();
> String result = formatter.formatCellValue(formula, evaluator);
> assertEquals(result, "Feb");
> }
> }
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
