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: [email protected]
Reporter: [email protected]
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: [email protected]
For additional commands, e-mail: [email protected]
