https://bz.apache.org/bugzilla/show_bug.cgi?id=68960
Bug ID: 68960 Summary: The TEXT function in Excel is not parsing a date into the desired format as expected. Product: POI Version: unspecified Hardware: Macintosh OS: Mac OS X 10.1 Status: NEW Severity: blocker Priority: P2 Component: POI Overall Assignee: dev@poi.apache.org Reporter: akshatnama1...@gmail.com Target Milestone: --- When using the TEXT function in Excel to format a date into a different format, the provided date is not being parsed into the desired format. For example, when using the formula TEXT("01/02/2021","yyyy-mm-dd"), the expected outcome is to have the date "01/02/2021" formatted into the format "yyyy-mm-dd". However, instead of getting the desired formatted date, the function returns the same date that was provided without any changes. This behavior is inconsistent with the expected functionality of the TEXT function, which should format the provided date into the specified format. As a result, users are unable to achieve the desired date formatting using the TEXT function, leading to potential issues in data presentation and analysis. This bug significantly impacts the usability and reliability of the TEXT function in Excel, especially for users who rely on precise date formatting for their data analysis and reporting needs. Therefore, it is essential to address this issue promptly to ensure the accurate functioning of the TEXT function and improve the overall user experience. -- 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