Return-Path: Delivered-To: apmail-poi-user-archive@www.apache.org Received: (qmail 8615 invoked from network); 22 Oct 2009 07:01:29 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 22 Oct 2009 07:01:29 -0000 Received: (qmail 3028 invoked by uid 500); 22 Oct 2009 07:01:29 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 2996 invoked by uid 500); 22 Oct 2009 07:01:29 -0000 Mailing-List: contact user-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Users List" Delivered-To: mailing list user@poi.apache.org Received: (qmail 2986 invoked by uid 99); 22 Oct 2009 07:01:29 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Oct 2009 07:01:28 +0000 X-ASF-Spam-Status: No, hits=-2.1 required=5.0 tests=AWL,BAYES_00,FROM_LOCAL_NOVOWEL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Oct 2009 07:01:26 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1N0rfV-00032z-I9 for user@poi.apache.org; Thu, 22 Oct 2009 00:01:05 -0700 Message-ID: <26005004.post@talk.nabble.com> Date: Thu, 22 Oct 2009 00:01:05 -0700 (PDT) From: MSB To: user@poi.apache.org Subject: Re: Adding/Deleting a Column In-Reply-To: <4ADFF841.6060209@alanwilliamson.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: markbrdsly@tiscali.co.uk References: <4ADE2A75.7050704@alanwilliamson.org> <25996500.post@talk.nabble.com> <26004545.post@talk.nabble.com> <4ADFF841.6060209@alanwilliamson.org> 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: user-unsubscribe@poi.apache.org > For additional commands, e-mail: user-help@poi.apache.org > > > -- 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: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org