poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex Karshakevich <al...@thoughtspeed.biz>
Subject Re: Formula problem
Date Tue, 21 Sep 2004 15:31:41 GMT
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


Mime
View raw message