yeah...that probably shouldn't even be public... After 2.0 I plan to do some massive API cleanup. (Not that its particularly bad but patches + lack of foresight in some areas makes for some messiness)
The new memory model I'm working on that will debut in a commercially supported HSSF called SOA Workbook will also go in 3.0. (which will give me license to do the API cleanup). I've still got some work to do on it... but my testing shows it reduces memory consumption by about 75%. -Andy On Mon, 2002-10-07 at 13:49, Slava Imeshev wrote: > 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]> > -- 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]>
