http://jakarta.apache.org/poi/hssf/quick-guide.html#DataFormats
Seran, Sathiyan wrote:
Andy,
The format string that uses euro is "[$EUR-2] #,##0.00".
Is there is any sample poi code that uses user defined data formats. If so
where can I find so?
-Sathiyan
-----Original Message-----
From: Andrew C. Oliver [mailto:acoliver@;apache.org]
Sent: Wednesday, November 06, 2002 3:03 PM
To: POI Users List
Subject: Re: HSSFDataFormat and accounting formats?
Follow the instructions I noted. select a format that uses the euro,
then click okay, then go back to the formatting window and select
custom. The correct format string will be highlighted... Then post
that here if you don't mind!
If that doesn't work please post us a sheet that uses the euro in
bugzilla with [RFE] prepended to the subject. The particular version
of Excel I have does not make it obvious how one would select a Euro
based string...then again I'm not even sure how to pop one up outside of
Excel either! :-)
BTW sheets with the Euro probably won't work in "stock" Excel
97...because well...There ain't no euro in Excel 97 ;-)
-Andy
Seran, Sathiyan wrote:
Andy,
How to use euro symbol instead of dollar?
Thanks
-Sathiyan
-----Original Message-----
From: Andrew C. Oliver [mailto:acoliver@;apache.org]
Sent: Wednesday, November 06, 2002 2:31 PM
To: POI Users List
Subject: Re: HSSFDataFormat and accounting formats?
select accounting, click ok. Go back to the cell and click custom....
you get:
"_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)"
Now why couldn't you guess that string off the top of your head? haha ;-)
-Andy
Amon, Jennifer wrote:
Thanks, but I don't know how to find that. From within Excel, it just
shows
a $ and separately lets me specify a number of decimal places. I have no
idea what that format would look like.
Jennifer
-----Original Message-----
From: Andrew C. Oliver [mailto:acoliver@;apache.org]
Sent: Wednesday, November 06, 2002 5:08 PM
To: POI Users List
Subject: Re: HSSFDataFormat and accounting formats?
Yes, basically find the format string you would use in excel, and use
that for HSSF.
-Andy
Amon, Jennifer wrote:
I can find the currency formats, but not the accounting formats
in the javadoc for HSSFDataFormat. The doc also says that
user defined formats may be used. One way or
another, can I get the dollar signs and decimal points to line
up in the column?
Thank you,
Jennifer Amon
-------------------------------------------------------------------------
-
-
-
----------
Jennifer R. Amon Work Phone: 440-962-2471
Moen Incorporated Work Fax: 440-962-2739
25300 Al Moen Drive Work Email: [EMAIL PROTECTED]
North Olmsted, OH 44070 Personal Email: [EMAIL PROTECTED]
Web: http://junior.apk.net/~jamon/
-------------------------------------------------------------------------
-
-
-
----------
________________________________________________________________________
This email has been scanned for all known viruses.
_______________________________________________________________________
--
To unsubscribe, e-mail:
<mailto:poi-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail:
<mailto:poi-user-help@;jakarta.apache.org>
--
To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
________________________________________________________________________
This email has been scanned for all known viruses prior to entering the
Moen
network.
________________________________________________________________________
________________________________________________________________________
This email has been scanned for all known viruses.
_______________________________________________________________________
--
To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
--
To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
--
To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
--
To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
--
To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
--
To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
