I've put a new patch out that will shift rows. It includes the test procedures and an quick-guide example. I haven't tried it on 1.5 version but I didn't use or do anything fancy if you want to try to apply it and get it working 1.5 if you unwilling to move to one of the more recent releases.
Shawn Laubach SAIC - Web Developer B-1B System Support Management Division OC-ALC/LAB, Building 3001, Tinker AFB, Oklahoma dsn: 336-2473 comm: 405-736-2473 mobile: 405-245-9562 -----Original Message----- From: Shawn Laubach [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 05, 2002 1:57 PM To: POI Users List Subject: RE: Inserting rows (ATTN: Shawn) (Andy)I haven't done anything with the clone methods so I don't know. I have looked and it is not too difficult to implement a shiftRows procedure that takes a range of rows and shifts them up or down a number of rows. I've actually got some working code that seems to work just fine. I need to work up a test case or two to ensure it is working and nothing breaks it. It might be tomorrow before I can get the test case(s) worked up. I'm afraid however that it would be in the dev release and not for 1.5. -----Original Message----- From: Slava Imeshev [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 05, 2002 11:29 AM To: POI Users List; [EMAIL PROTECTED] Subject: Re: Inserting rows (ATTN: Shawn) Andrew, > so you mean you want to insert a row and cause the rows below it to move > down. That sounds like a good place for a conveince function... Yes, I mean exactly that. > We'd basically have to copy the rows below the inserted rows...down. > > If the first approach doesn't work, how do I copy rows from template to > > the new workbook? > > > > If you're using a nightly build or possibly 1.8-dev (I think clone I'm using 1.5. > support made it into 1.8 dev...shawn?) you can use the "clone" methods to > accomplish this. Is that right Shawn? I'm not sure if I can afford switching to other version. What shoud be in the "clone method"? In other words, how do I copy a cell one-to-one? Any ideas/code snippets? Thanks, Slava Imeshev P.S. It wouldn't be a problem if I didn't have only two days to finish my part :( __________________________________________________ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>