Go for it. Shawn
-----Original Message----- From: Height, Jason [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 10:15 PM To: 'POI Mailing List' Subject: Add ability to insertRows with automatic row shift Hi all, I was thinking that I would like to add the functionality: HSSFRow row = HSSFSheet.insertRow(1); This functionality would differ from createRow in that it would move all current rows after and including the row at the insert position down by one row, updating all cell references (in formulas) to row+1. This is the same as excel Insert Row functionality. The shiftRows functionality would be used, but would need to be improved so that cell references in formulas are updated (this should probably be done anyway). What do you all think. Probably to be complete a deleteRow would be required as well that moved the rows up by one. This would be done on the HEAD. What do you all think. No one else working on this? Jason ---------------------------------------------------------------------------- ---------------------------------------- This e-mail (including attachments) is confidential information of Australian Submarine Corporation Pty Limited (ASC). It may also be legally privileged. Unauthorised use and disclosure is prohibited. ASC is not taken to have waived confidentiality or privilege if this e-mail was sent to you in error. If you have received it in error, please notify the sender promptly. While ASC takes steps to identify and eliminate viruses, it cannot confirm that this e-mail is free from them. You should scan this e-mail for viruses before it is used. The statements in this e-mail are those of the sender only, unless specifically stated to be those of ASC by someone with authority to do so. --------------------------------------------------------------------- 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]
