You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by pratik sharma <sh...@gmail.com> on 2012/02/20 06:13:50 UTC
How to decode format code with numfmtid given is "44" for excel 2007
Anyone has any idea How to decode format code with numfmtid given is "44"
for excel 2007 ?
Re: How to decode format code with numfmtid given is "44" for excel
2007
Posted by Nick Burch <ni...@alfresco.com>.
On Mon, 20 Feb 2012, pratik sharma wrote:
> Anyone has any idea How to decode format code with numfmtid given is
> "44" for excel 2007 ?
Assuming you've got a cell style, just call getDataFormatString() rather
than getDataFormat():
http://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/CellStyle.html#getDataFormatString%28%29
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: How to decode format code with numfmtid given is "44" for excel
2007
Posted by Pratik <sh...@gmail.com>.
How to parse the format string with numfmtid="44".
Format code whcih i am getting is :_("$"* #,##0.00_);_("$"*
\(#,##0.00\);_("$"* "-"??_);_(@_).
Input is excel is :$24.00 .
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-decode-format-code-with-numfmtid-given-is-44-for-excel-2007-tp5498173p5501119.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org