Return-Path: Delivered-To: apmail-poi-user-archive@www.apache.org Received: (qmail 1653 invoked from network); 8 Oct 2008 09:54:29 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 8 Oct 2008 09:54:29 -0000 Received: (qmail 94784 invoked by uid 500); 8 Oct 2008 09:54:27 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 94773 invoked by uid 500); 8 Oct 2008 09:54:27 -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 94762 invoked by uid 99); 8 Oct 2008 09:54:27 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Oct 2008 02:54:27 -0700 X-ASF-Spam-Status: No, hits=2.7 required=10.0 tests=DNS_FROM_OPENWHOIS,DNS_FROM_SECURITYSAGE,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG 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; Wed, 08 Oct 2008 09:53:24 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1KnVjz-0000rG-5M for user@poi.apache.org; Wed, 08 Oct 2008 02:53:59 -0700 Message-ID: <19875720.post@talk.nabble.com> Date: Wed, 8 Oct 2008 02:53:59 -0700 (PDT) From: Garibaldi To: user@poi.apache.org Subject: Why does a 200kb file grow to large for excel? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: Thorsten.Johl@helmholtz-hzi.de X-Virus-Checked: Checked by ClamAV on apache.org Greetings to all and everyone. I have a rather baffling problem at the moment using HSSF to generate a new Excel .xls file. Generating the file and opening it in Excel worked fine, until I decided to write some additional characters into an allready existing cell, Excel won't open the small file afterwards. I did some testing, adding information to new cells, and Excel refuses to open these new versions as well. If i simply comment the line that generates the new cell, or switch the line that provides new information for a previously existing one, excel complies and opens the file. but adding as much as 7 letters in round about 800 Cells breaks it. And I see no error message whatsoever =( The attributes of the file: 200kb in size, around 1.500 rows, 10 columns, 10 fonts(generated once at object construction), 1 style. Again: Writing the file works, until I supply additional strings to new or existing RichStringText formatted Cells. I'd be very gratefull If anyone has any ideas what is breaking my code. Best Regards Thorsten -- View this message in context: http://www.nabble.com/Why-does-a-200kb-file-grow-to-large-for-excel--tp19875720p19875720.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