Return-Path: Delivered-To: apmail-poi-user-archive@www.apache.org Received: (qmail 8045 invoked from network); 5 Sep 2008 23:14:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 5 Sep 2008 23:14:22 -0000 Received: (qmail 78277 invoked by uid 500); 5 Sep 2008 23:14:19 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 78259 invoked by uid 500); 5 Sep 2008 23:14:19 -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 78248 invoked by uid 99); 5 Sep 2008 23:14:18 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Sep 2008 16:14:18 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [68.142.207.194] (HELO web32401.mail.mud.yahoo.com) (68.142.207.194) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 05 Sep 2008 23:13:20 +0000 Received: (qmail 44015 invoked by uid 60001); 5 Sep 2008 23:12:48 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=D1JtsX/6qS+YRf2+erovPNWkNYQsg4Ys8fQNQ2Rb5KeJkeJE9PA/63r3il8JPPme2ikZ95AO1EPbNybRv7rP5McqM/6pT2VItQuHx7Zh93ZD+hDrVaJsXYAjPjDL5hfL8QcCA5ULHn7g9rNtuMsnbLbLRdcUNhXbKph53laoQys=; X-YMail-OSG: FsS7PnwVM1li9agIZoQ5e8ZIHDu6DCMZRcTmFs3F8TaJM_ldGLtOa4IkpXNQuaUoJxD0Ok0g9DOQ7iA3uJas05pFgSbwZVrTm0HWEfSE8p1pOby46GOCSVC24qHQj8IcoQ-- Received: from [76.176.199.171] by web32401.mail.mud.yahoo.com via HTTP; Fri, 05 Sep 2008 16:12:48 PDT X-Mailer: YahooMailWebService/0.7.218.2 Date: Fri, 5 Sep 2008 16:12:48 -0700 (PDT) From: "Robert W. Wade" Subject: Unable to open Excel File if a sheet contains a chart To: user@poi.apache.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Message-ID: <725969.41048.qm@web32401.mail.mud.yahoo.com> X-Virus-Checked: Checked by ClamAV on apache.org I am using poi-3.1-FINAL-20080629.jar along with java 1.5 on OS X. I have an Excel file created using Excel 2004 for Mac V 11.5.1 that contains 3 sheets. I am able to open this file using POI with no problems. If I add a sheet and add a chart to that sheet (but the chart references no data) then I am still able to open the file. If I modify the chart's source data and include 1 data 'series' then POI is unable to open the file. The exception I receive is: org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance along with Caused by: java.lang.IllegalArgumentException: Illegal length - asked for 3 but only 1 left! at org.apache.poi.hssf.record.RecordInputStream.readUnicodeLEString(RecordInputStream.java:252) at org.apache.poi.hssf.record.SeriesTextRecord.fillFields(SeriesTextRecord.java:78) at org.apache.poi.hssf.record.Record.(Record.java:55) at org.apache.poi.hssf.record.SeriesTextRecord.(SeriesTextRecord.java:56) ... 141 more Is this a known issue and perhaps there is a workaround? Thanks, RW --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org