You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Magne Skjeret <ma...@broadpark.no> on 2003/09/11 09:19:42 UTC

automatic resize of columns

Hi

Just a quick question.
Is there anyway to set the columns to resize autmatically after the contect 
of the cells, so that the users wont have to see those ##### cells?

I have so far tried to do a calculation based on how many chars there are 
in the cells, that is not a optimal solution, and actually fails sometimes 
too when the content of the cell is large.

Magne


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Setting data type in HSSF excel cells

Posted by abhishek <as...@xora.com>.
Hi
 I have a collection which contains String data which I need to be shown in
excel columns. The actual data may however be of any type (int, double, date
etc) even though it is stored as string. We cannot apply any numeric
function on excel generated by HSSF if we use
cell.setColumnValue(Stringdata). We need to use cell.setColumnValue(double).
Is it possible that POI/HSSF doesnt set the data type on its own but lets
the excel determine what data is passed (as done when we pass a csv file to
excel)
TIA
Abhishek Vinod Singh



-----Original Message-----
From: Magne Skjeret [mailto:magne.skjeret@broadpark.no]
Sent: Thursday, September 11, 2003 12:57 PM
To: POI Users List
Subject: Re: automatic resize of columns


At 09:19 11.09.2003 +0200, you wrote:
>Hi
>
>Just a quick question.
>Is there anyway to set the columns to resize autmatically after the
>contect of the cells, so that the users wont have to see those ##### cells?
>
>I have so far tried to do a calculation based on how many chars there are
>in the cells, that is not a optimal solution, and actually fails sometimes
>too when the content of the cell is large.

Hmm. I should try to look on the web BEFORE I waste your time.
It seems like that cant be done. Yet????

Magne



>Magne
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Re: automatic resize of columns

Posted by Magne Skjeret <ma...@broadpark.no>.
At 09:19 11.09.2003 +0200, you wrote:
>Hi
>
>Just a quick question.
>Is there anyway to set the columns to resize autmatically after the 
>contect of the cells, so that the users wont have to see those ##### cells?
>
>I have so far tried to do a calculation based on how many chars there are 
>in the cells, that is not a optimal solution, and actually fails sometimes 
>too when the content of the cell is large.

Hmm. I should try to look on the web BEFORE I waste your time.
It seems like that cant be done. Yet????

Magne



>Magne
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org