Thanks Shawn, It works in newer version (I downloaded jakarta-poi-1.9.0-dev-20021107.jar).
-Sathiyan -----Original Message----- From: Andrew C. Oliver [mailto:acoliver@;apache.org] Sent: Thursday, November 07, 2002 12:00 PM To: POI Users List Subject: Shawn::: Re: HSSFDataFormat and accounting formats? hummm... Maybe Shawn can help? Seran, Sathiyan wrote: >Andy, > >I am using poi8. >I executed the Data Formats sample code. >Cell A1 and A2 are empty, but when I select the cell in the formula box >display "11111.25". On format window the custom format for both the cell >shows as ";;". > >Attached is the excel sheet. > >-Sathiyan > >-----Original Message----- >From: Andrew C. Oliver [mailto:acoliver@;apache.org] >Sent: Thursday, November 07, 2002 9:57 AM >To: POI Users List >Subject: Re: HSSFDataFormat and accounting formats? > > >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> > > > >------------------------------------------------------------------------ > >-- >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>
