Re: HSSF: inserting a new column in existing sheet

[Danny Mui]

maybe copy the shiftrows logic as a shiftcolumns?  shiftrows renumbers 
formulas and such based on row number, so doing the same to columns 
shouldn't be that much of a bother.

grab the source and give it a shot!
or post a bugzilla enhancement request and vote for it.
Marko Asplund wrote:
i'm trying to figure out how to insert a new column in the middle of 
existing columns with HSSF usermodel API for spreadsheets that have been 
created with MS Excel. HSSFRow.createCell() seems to insert a cell 
replacing the existing cell, so it can't be used in a similar fashion as 
you would with rows (HSSFSheet.shiftRows()). i was thinking about just 
creating a new cell in the end of each row and then shifting (copying) 
the values of existing cells to the left. on second thought this does 
not seem to work when there're formula cells in the existing sheet 
(HSSFCell.setCellType() not supported for formulas according to 
documentation). also, does HSSF support all types of cells that can be 
created by MS Excel?

how would other people solve this insertion problem?
best regards,
--
    aspa
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]