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>
