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>
workbook.xls
Description: MS-Excel spreadsheet
-- To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
