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/
--------------------------------------------------------------------------
Moen-
------------
________________________________________________________________________
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
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>
