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]>
