:-)
Amon, Jennifer wrote:
Oh, for crying out loud!! Now, I really know why it's called HSSF.
Thanks again!
Jennifer
-----Original Message-----
From: Seran, Sathiyan [mailto:sseran@;informatica.com]
Sent: Wednesday, November 06, 2002 5:46 PM
To: 'POI Users List'
Subject: RE: HSSFDataFormat and accounting formats?
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>
________________________________________________________________________
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>
