https://bz.apache.org/bugzilla/show_bug.cgi?id=69147
--- Comment #3 from aarbor...@gmail.com ---
Agreed on using cached values when possible, however in the use case this was
discovered in we are creating the formulas and evaluating them in memory so
there's no cached value to depend on.
During testing I did also see that when a number / date value is passed in it
does seem to work correctly
> Cell date = row.createCell(0);
> date.setCellValue(LocalDate.of(2022, 2, 28));
> Cell formula = row.createCell(1);
> formula.setCellFormula("TEXT(A1, \"MMM\")");
However, 5.2.4 handling is preferable IMO because as you mentioned it matches
the behavior in Excel
--
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
