Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <poi-user@jakarta.apache.org>
Received-SPF: pass (hermes.apache.org: local policy includes SPF record at
 spf.trusted-forwarder.org)
Message-ID: <4150495D.9090001@thoughtspeed.biz>
Date: Tue, 21 Sep 2004 11:31:41 -0400
From: Alex Karshakevich <alexk@thoughtspeed.biz>
User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913)
MIME-Version: 1.0
To: POI Users List <poi-user@jakarta.apache.org>
Subject: Re: Formula problem
References: <20040921150607.32347.qmail@web14427.mail.yahoo.com>
In-Reply-To: <20040921150607.32347.qmail@web14427.mail.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi Pavan,

Entire columns must be hidden, not individual cells. Just set the width 
of the column to 0 (HSSFSheet.setColumnWidth(short column, short width)) 
and it will do the trick.
We also did the same HSSFCellStyle.setHidden(true) for each cell.
Another solution might be to try and store the temporary values in 
another 'scratchpad' sheet.

Alex.


Pavan Guduru wrote:

>Thanks Alex,
>Your solution is working. But now I am not able to hide the cells where the intermidiate formula value is stored.
> 
>HSSFCellStyle.setHidden(true)  doesnot seem to be working to hide the value in the cell.
>Is there anyway to hide the value of the cell.
> 
>Thanks
>pavan
>


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