The problem was in fact that setRowNum called on HSSFRow didn't change anything in apearance of worksheet.
Slava --- "Andrew C. Oliver" <[EMAIL PROTECTED]> wrote: > At some level that is what excel does anyhow. > > -Andy > > On Mon, 2002-10-07 at 12:43, Slava Imeshev wrote: > > Andrew, > > > > I implemented shifting rows myself for 1.5, > > thanks Shawn for some ideas. I just perform > > row by row, cell by cell copying. That may be > > not very fast, but it does work for me. > > > > Thank you for you help! > > > > Regards, > > > > Slava Imeshev > > > > --- "Andrew C. Oliver" <[EMAIL PROTECTED]> wrote: > > > OOC, why did you send a patch instead of just committing it? > > > > > > On Mon, 2002-10-07 at 12:04, Laubach Shawn Contr OC-ALC/PSB wrote: > > > > 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]> > > > -- > > > http://www.superlinksoftware.com - software solutions for business > > > http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in > > > Java > > > http://krysalis.sourceforge.net/centipede - the best build/project > > > structure > > > a guy/gal could have! - Make Ant simple on complex Projects! > > > The avalanche has already started. It is too late for the pebbles to > > > vote. > > > -Ambassador Kosh > > > > > > > > > -- > > > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > > > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > > > > > > > __________________________________________________ > > 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]> > > > -- > http://www.superlinksoftware.com - software solutions for business > http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in > Java > http://krysalis.sourceforge.net/centipede - the best build/project > structure > a guy/gal could have! - Make Ant simple on complex Projects! > The avalanche has already started. It is too late for the pebbles to > vote. > -Ambassador Kosh > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > __________________________________________________ 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]>
