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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
