You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2024/04/30 11:52:50 UTC
[Bug 68960] New: The TEXT function in Excel is not parsing a date into the desired format as expected.
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: akshatnama1999@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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 68960] The TEXT function in Excel is not parsing a date into the desired format as expected.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=68960
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
The code for this is:
https://github.com/apache/poi/blob/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/TextFunction.java
If you're able to fix this, please open a PR!
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 68960] The TEXT function in Excel is not parsing a date into the desired format as expected.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=68960
Akshat Nama <ak...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |akshatnama1999@gmail.com
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 68960] The TEXT function in Excel is not parsing a date into the desired format as expected.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=68960
PJ Fanning <fa...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Severity|blocker |normal
Hardware|Macintosh |All
OS|Mac OS X 10.1 |All
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org