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