Avik already responded that their is a patch in bugzilla that will soon be applied to allow custom formats. You'll have to download a nightly build once its applied, or you can get the CVS HEAD right now and apply it to your local copy.
-Andy Raj Kumar Kundu wrote: >Hi Avik / Andy, > > Please help me to solve my problem. I want to format a cell like that >###,###,###.##### (i.e. customized format). I am already found a class >"HSSFDataFormat" which is used to format a cell, but it not supported a >customized format. > > Can you please help me to customize the formatting of a Numeric cell >using POI? > > Or > > Can you tell me in which program of source files I should change to >incorporate the customized format? > >I saw that if I open a .xls file in binary format which containing a >customized format (like #,###.00000) of data, the only change I saw that it >will be added customized format after predefine data format block -- am I >correct? > > > >Please give me a solution for customizing the cell format as soon as >possible. > >Thank u very much. > > > >Best Regards, > >Raj > > >----- Original Message ----- >From: "Andrew C. Oliver" <[EMAIL PROTECTED]> >To: "POI Users List" <[EMAIL PROTECTED]> >Sent: Thursday, July 25, 2002 5:50 PM >Subject: Re: Excel file format > > > > >>Please do not use 1.5.0. Acquire 1.5.1. 1.5.1 is more stable than >>1.5.1 as it has the advantages of >>bugfixes. And there should be no pain in upgrading. (just swap the jar >> >> >out) > > >>-Andy >> >>Raj Kumar Kundu wrote: >> >> >> >>>Hi Avik, >>> >>> Thank you so much for your valuable help. >>> >>> Can I get the patch or files (.java file) for to set customized >>> >>> >formats > > >>>of a cell which was just submitted a few day ago by Shawn (as per your >>>previous response)? >>> >>> I have a POI version 1.5.0. >>> >>> >>> >>>Please help. >>> >>>Best Regards, >>> >>>Raj >>> >>> >>> >>> >>>----- Original Message ----- >>>From: "Avik Sengupta" <[EMAIL PROTECTED]> >>>To: "POI Users List" <[EMAIL PROTECTED]> >>>Sent: Thursday, July 25, 2002 4:38 PM >>>Subject: Re: Excel file format >>> >>> >>> >>> >>> >>> >>>>http://sc.openoffice.org/excelfileformat.pdf is where you will find a >>>> >>>> >lot > > >>>> >>>> >>>of >>> >>> >>> >>> >>>>the excel file format. >>>> >>>>Having said that, some code to set customised formats was just submitted >>>> >>>> >a > > >>>> >>>> >>>few >>> >>> >>> >>> >>>>days ago (thanks Shawn!). >>>> >>>>http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11068 >>>> >>>>It'll hopefully get commited in the next few days, after which you can >>>> >>>> >try > > >>>> >>>> >>>the >>> >>> >>> >>> >>>>latest nightly build. >>>> >>>> >>>>Quoting Raj Kumar Kundu <[EMAIL PROTECTED]>: >>>> >>>> >>>> >>>> >>>> >>>>>Hi friends, >>>>> >>>>> Any body can help me to find out Excel (.xls) file format. >>>>> >>>>> I want to set a cell format like (###,###,###.##### or >>>>>###,###,###.00000) that is a customized data format. >>>>> >>>>> Any body can help me regarding this issue. >>>>> >>>>> >>>>> >>>>>Please help. >>>>> >>>>> >>>>> >>>>>Best Regards, >>>>> >>>>>Raj >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>-- >>>>>To unsubscribe, e-mail: >>>>> >>>>> >>>>> >>>>> >>><mailto:[EMAIL PROTECTED]> >>> >>> >>> >>> >>>>>For additional commands, e-mail: >>>>> >>>>> >>>>> >>>>> >>><mailto:[EMAIL PROTECTED]> >>> >>> >>> >>> >>>>> >>>>> >>>>-- >>>>To unsubscribe, e-mail: >>>> >>>> ><mailto:[EMAIL PROTECTED]> > > >>>>For additional commands, e-mail: >>>> >>>> ><mailto:[EMAIL PROTECTED]> > > >>>> >>>> >>>> >>>> >>>-- >>>To unsubscribe, e-mail: >>> >>> ><mailto:[EMAIL PROTECTED]> > > >>>For additional commands, e-mail: >>> >>> ><mailto:[EMAIL PROTECTED]> > > >>> >>> >>> >>> >> >> >>-- >>To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >>For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> >> >> >> >> > > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
