https://bz.apache.org/bugzilla/show_bug.cgi?id=66904
Bug ID: 66904 Summary: Function DAYS not parsing German or French string dates Product: POI Version: 5.2.3-FINAL Hardware: PC Status: NEW Severity: normal Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: mguille...@yahoo.fr Target Milestone: --- The function _days_ works fine with cells containing dates as numbers but not with cells containing dates as strings with for instance a German (dd.mm.yyy) or French (dd/mm/yyyy) pattern. The root of the problem is probably in org.apache.poi.ss.usermodel.DateUtil.parseDateTime. Trying to parse with DateTimeFormatter.ISO_LOCAL_DATE first would mitigate the problem but according to my tests, a German version of Excel parses string dates in different formats. -- 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