poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Laubach Shawn Contr OC-ALC/PSB <Shawn.Laub...@tinker.af.mil>
Subject RE: Add ability to insertRows with automatic row shift
Date Fri, 07 Nov 2003 14:43:56 GMT
Go for it.

Shawn

-----Original Message-----
From: Height, Jason [mailto:jheight@subcorp.com.au]
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: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org

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


Mime
View raw message