Re: green icon in the cell

2005-10-19 Thread Daniel Noll
Murali Krishna wrote: Hi Amol, (You can infer the correct type based on whether the string parses to a number etc) how exactly can i do that, if the string verybig, which cann't fit even in double. Obviously if it can't fit in a double, it isn't a double. If you parse a string into a numbe

RE: green icon in the cell

2005-10-19 Thread Murali Krishna
-Original Message- > From: Murali Krishna [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 19, 2005 4:46 PM > To: POI Users List > Subject: RE: green icon in the cell > > > Hi Amol, > > I am getting the numeric as string from the database. when I > am getting

RE: green icon in the cell

2005-10-19 Thread Amol Deshmukh
parses to a number etc.) HTH, ~ amol > -Original Message- > From: Murali Krishna [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 19, 2005 4:46 PM > To: POI Users List > Subject: RE: green icon in the cell > > > Hi Amol, > > I am getting the numer

RE: green icon in the cell

2005-10-19 Thread Murali Krishna
-- > From: Murali Krishna [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 19, 2005 1:16 PM > To: POI Users List > Subject: Re: green icon in the cell > > > Hi Leen Toelen, > > Thanks for the response. I have tried that before and after > seeing your mail

RE: green icon in the cell

2005-10-19 Thread Amol Deshmukh
o: POI Users List > Subject: Re: green icon in the cell > > > Hi Leen Toelen, > > Thanks for the response. I have tried that before and after > seeing your mail, with all the possible combinations of > String, numeric, formula, error and blank. Still its not > resolvi

Re: green icon in the cell

2005-10-19 Thread Murali Krishna
PROTECTED]> wrote: Hi, setCellType to the rescue: void setCellType(int cellType) set the cells type (numeric, formula or string) Regards, Leen Toelen On 10/19/05, Murali Krishna wrote: > Hi, > I am getting a small green icon in the cell when i insert a string which is > numeric data

Re: green icon in the cell

2005-10-18 Thread Leen Toelen
Hi, setCellType to the rescue: voidsetCellType(int cellType) set the cells type (numeric, formula or string) Regards, Leen Toelen On 10/19/05, Murali Krishna <[EMAIL PROTECTED]> wrote: > Hi, > I am getting a small green icon in the cell when i insert a string which i

green icon in the cell

2005-10-18 Thread Murali Krishna
Hi, I am getting a small green icon in the cell when i insert a string which is numeric data in the excel cell. the exact message is "the number in this cell is formatted as text or preceded by an apostophe". is there anyway I can get rid of that. Below is the sample code th