Ah, now I was going to suggest a utility class but thought that a little bit presumptious; if you will do this, I am confident that lots of others will appreciate the contribution and that it might be possible to prevail on Yegor to add it to the utility package. Must admit that I had not thought overly long about perfromance and it will be fascinating to see just how long it takes to work on larger sheets, I am hoping that we will both be surprised.
All the best and I look forward to seeing the results. Yours Mark B AR Williamson wrote: > > Mark, > > Let me thank you for you a well thought out reply, appreciate it. > > Yes, I can see there is potential for a lot of "fun" in terms of column > management. I will write up a Utility class to help with this and > throw it to the list. > > My only fear is that, while technically feasible, its going to be > horrendously slow with large sheets; particularly if you are > inserting/deleting columns near the left as oppose to the right. > > thanks and i will let you know how i get on, > > alan > http://alan.blog-city.com/ > > MSB wrote: >> .....and, I should have made it clear that removing a cell will not cause >> those cells to it's right top automatically re-number themselves and so >> effectively remove the column for you. You will still need to move these >> cells to the left manually so to speak; well at least I think that you >> will >> have to. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://www.nabble.com/Adding-Deleting-a-Column-tp25982828p26005004.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
