From rodgerskatie@example.net Fri Feb 01 06:44:42 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 87500 invoked from network); 1 Feb 2008 06:44:42 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Feb 2008 06:44:42 -0000 Received: (qmail 91186 invoked by uid 500); 1 Feb 2008 06:44:33 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 91156 invoked by uid 500); 1 Feb 2008 06:44:33 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 91147 invoked by uid 99); 1 Feb 2008 06:44:33 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 31 Jan 2008 22:44:33 -0800 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Feb 2008 06:44:27 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 68DEF714043; Thu, 31 Jan 2008 22:44:19 -0800 (PST) From: rodgerskatie@example.net To: rodgerskatie@example.net Subject: DO NOT REPLY [Bug 44336] New: - [PATCH] Sheet names with special characters aren't rendered properly in formulas Message-ID: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-Reason: AssignedTo Date: Thu, 31 Jan 2008 22:44:19 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=44336>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=44336 Summary: [PATCH] Sheet names with special characters aren't rendered properly in formulas Product: POI Version: 3.0-dev Platform: Other OS/Version: All Status: NEW Severity: normal Priority: P2 Component: HSSF AssignedTo: rodgerskatie@example.net ReportedBy: rodgerskatie@example.net Ref3DPtg.toFormulaString() has some code to detect the presense of a space char. Area3DPtg doesn't even have that. Some sample junit code to show the error: Ref3DPtg target = new Ref3DPtg("A1", (short)0); Workbook book = Workbook.createWorkbook(); book.checkExternSheet(0); book.setSheetName(0, "profit+loss"); assertEquals("'profit+loss'!A1", target.toFormulaString(book)); -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Fri Feb 01 06:51:45 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 88950 invoked from network); 1 Feb 2008 06:51:45 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Feb 2008 06:51:45 -0000 Received: (qmail 98213 invoked by uid 500); 1 Feb 2008 06:51:36 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 98193 invoked by uid 500); 1 Feb 2008 06:51:36 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 98184 invoked by uid 99); 1 Feb 2008 06:51:36 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 31 Jan 2008 22:51:36 -0800 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Feb 2008 06:51:29 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id E18BB714043; Thu, 31 Jan 2008 22:51:21 -0800 (PST) From: rodgerskatie@example.net To: rodgerskatie@example.net Subject: DO NOT REPLY [Bug 44336] - [PATCH] Sheet names with special characters aren't rendered properly in formulas In-Reply-To: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-Reason: AssignedTo Message-Id: <rodgerskatie@example.net> Date: Thu, 31 Jan 2008 22:51:21 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=44336>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=44336 ------- Additional Comments From rodgerskatie@example.net 2008-01-31 22:51 ------- Created an attachment (id=21457) --> (http://issues.apache.org/bugzilla/attachment.cgi?id=21457&action=view) svn diff for several files + 5 new java files Some unrelated junit tests broke while doing the work. These were mostly related to printRanges. It was assumed that the correct behaviour for rendering 3d refs for print ranges was the same as that for rendering formulas (i.e. delimit and escape if any special characters are present). The junits were modified to reflect this. -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Fri Feb 01 12:31:42 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 98825 invoked from network); 1 Feb 2008 12:31:42 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Feb 2008 12:31:42 -0000 Received: (qmail 49804 invoked by uid 500); 1 Feb 2008 12:31:33 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 49780 invoked by uid 500); 1 Feb 2008 12:31:33 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 49771 invoked by uid 99); 1 Feb 2008 12:31:33 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Feb 2008 04:31:33 -0800 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Feb 2008 12:31:14 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 2DD82714045; Fri, 1 Feb 2008 04:31:20 -0800 (PST) From: rodgerskatie@example.net To: rodgerskatie@example.net Subject: DO NOT REPLY [Bug 44326] - POILogger log(level,string,exception) calls itself in an endless loop In-Reply-To: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-Reason: AssignedTo Message-Id: <rodgerskatie@example.net> Date: Fri, 1 Feb 2008 04:31:20 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=44326>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=44326 rodgerskatie@example.net changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- Additional Comments From rodgerskatie@example.net 2008-02-01 04:31 ------- Try with svn trunk. I've fixed it to avoid the infinite loop, added log(level,throwable), and updated the CommonsLogger to take advantage of that -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Fri Feb 01 13:02:58 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 6743 invoked from network); 1 Feb 2008 13:02:58 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Feb 2008 13:02:58 -0000 Received: (qmail 3134 invoked by uid 500); 1 Feb 2008 13:02:48 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 3104 invoked by uid 500); 1 Feb 2008 13:02:48 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 3095 invoked by uid 99); 1 Feb 2008 13:02:48 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Feb 2008 05:02:48 -0800 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Feb 2008 13:02:28 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id D471371403B; Fri, 1 Feb 2008 05:02:35 -0800 (PST) From: rodgerskatie@example.net To: rodgerskatie@example.net Subject: DO NOT REPLY [Bug 44336] - [PATCH] Sheet names with special characters aren't rendered properly in formulas In-Reply-To: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-Reason: AssignedTo Message-Id: <rodgerskatie@example.net> Date: Fri, 1 Feb 2008 05:02:35 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=44336>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=44336 rodgerskatie@example.net changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- Additional Comments From rodgerskatie@example.net 2008-02-01 05:02 ------- Thanks for this, patch applied to trunk -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Fri Feb 01 18:23:51 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 4813 invoked from network); 1 Feb 2008 18:23:51 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Feb 2008 18:23:51 -0000 Received: (qmail 16935 invoked by uid 500); 1 Feb 2008 18:23:42 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 16916 invoked by uid 500); 1 Feb 2008 18:23:42 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 16907 invoked by uid 99); 1 Feb 2008 18:23:41 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Feb 2008 10:23:41 -0800 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 [83.161.120.155] (HELO fluffy.torchbox.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Feb 2008 18:23:14 +0000 Received: from fluffy.internal.torchbox.com ([83.161.120.155]) by fluffy.torchbox.com with esmtp (Exim 4.63) (envelope-from <rodgerskatie@example.net>) id 1JL0Xo-0003rz-7w for rodgerskatie@example.net; Fri, 01 Feb 2008 18:23:20 +0000 Date: Fri, 1 Feb 2008 18:23:20 +0000 (GMT) From: Nick Burch <rodgerskatie@example.net> X-X-Sender: rodgerskatie@example.net To: rodgerskatie@example.net Subject: Fun with HSSF and Hyperlinks Message-ID: <rodgerskatie@example.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Score: -2.1 (--) Organization: Torchbox Ltd, Registered Company #3983354, Unit 9, Southill Business Park, OX7 3EW, UK X-Virus-Checked: Checked by ClamAV on apache.org Hi All I had a stab at doing hyperlink support for hssf (bug #37923). After discovering a rather old, stub implementation of the record, handily under an apache licence, I was able to get most of the Hyperlink record supported. (A few unknowns, and one bit of black magic, but all files containing the record in our test suite still open fine...). Oh, and I've done record tests for it all too, which seem to cover most things. On trying to add usermodel support for it, I hit a bit of a snag. The records weren't ending up in Workbook.records, as they came after the EOFRecord, so weren't being picked up by the interesting records sweep in Workbook.createWorkbook As a stop-gap, I've got Workbook.createWorkbook to check the records after EOFRecord, and pop the Hyperlink records into another array. However, this doesn't let them tie in with cells, as they're in the wrong place, and I'm not even sure how to tell which sheet a Hyperlink belongs to (row+column are easy though) I've also done some unit tests in usermodel.HSSFCell, which are disabled for now as the cells don't get created, as the Hyperlink records aren't picked up by the sheet's record sweep. So, if you fancy trying to finish the support off, they should get you most of the way there for a test, then you just need to deal with getting the records into where they need to be... Nick --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Fri Feb 01 18:24:55 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 5031 invoked from network); 1 Feb 2008 18:24:55 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Feb 2008 18:24:55 -0000 Received: (qmail 17723 invoked by uid 500); 1 Feb 2008 18:24:46 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 17687 invoked by uid 500); 1 Feb 2008 18:24:46 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 17678 invoked by uid 500); 1 Feb 2008 18:24:46 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 17674 invoked by uid 99); 1 Feb 2008 18:24:46 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Feb 2008 10:24:46 -0800 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Feb 2008 18:24:39 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id CFDAA714047; Fri, 1 Feb 2008 10:24:31 -0800 (PST) From: rodgerskatie@example.net To: rodgerskatie@example.net Subject: DO NOT REPLY [Bug 37923] - Trying to read an excel worksheet with hyperlink references In-Reply-To: <rodgerskatie@example.net/bugzilla/> X-Bugzilla-Reason: AssignedTo Message-Id: <rodgerskatie@example.net> Date: Fri, 1 Feb 2008 10:24:31 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=37923>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=37923 ------- Additional Comments From rodgerskatie@example.net 2008-02-01 10:24 ------- I've added support for the Hyperlink record, and tests for that Hit a snag with getting it passed on to the usermodel code, as the records seem to be in completely the wrong part of the record stream. See my post to dev@ for details -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Sat Feb 02 00:26:53 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 9744 invoked from network); 2 Feb 2008 00:26:53 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Feb 2008 00:26:53 -0000 Received: (qmail 73300 invoked by uid 500); 2 Feb 2008 00:26:44 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 73276 invoked by uid 500); 2 Feb 2008 00:26:44 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 73267 invoked by uid 99); 2 Feb 2008 00:26:44 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Feb 2008 16:26:44 -0800 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 Feb 2008 00:26:24 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id E5727714047; Fri, 1 Feb 2008 16:26:31 -0800 (PST) From: rodgerskatie@example.net To: rodgerskatie@example.net Subject: DO NOT REPLY [Bug 44345] New: - [patch] Added implementations for Excel functions COUNTA, COUNTIF, INDEX, ROWS, COLUMNS Message-ID: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-Reason: AssignedTo Date: Fri, 1 Feb 2008 16:26:31 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=44345>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=44345 Summary: [patch] Added implementations for Excel functions COUNTA, COUNTIF, INDEX, ROWS, COLUMNS Product: POI Version: 3.0-dev Platform: Other OS/Version: other Status: NEW Severity: normal Priority: P2 Component: HSSF AssignedTo: rodgerskatie@example.net ReportedBy: rodgerskatie@example.net Stub implementations of (COUNTA, COUNTIF, INDEX, ROWS, COLUMNS ) were filled in. Some specific case of these functions are still not implemented, but basic behaviour is there. Added test cases for these and some other functions. Note also - there is an unrelated change in HyperlinkRecord.java The current version appears to be using a JDK5 API. (IllegalStateException.<init>(Throwable) ). Please correct me if JDK5 is ok to use. -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Sat Feb 02 00:32:05 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 11291 invoked from network); 2 Feb 2008 00:32:04 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Feb 2008 00:32:04 -0000 Received: (qmail 78408 invoked by uid 500); 2 Feb 2008 00:31:55 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 78389 invoked by uid 500); 2 Feb 2008 00:31:55 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 78380 invoked by uid 99); 2 Feb 2008 00:31:55 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Feb 2008 16:31:55 -0800 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 Feb 2008 00:31:49 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 8430D714047; Fri, 1 Feb 2008 16:31:41 -0800 (PST) From: rodgerskatie@example.net To: rodgerskatie@example.net Subject: DO NOT REPLY [Bug 44345] - [patch] Added implementations for Excel functions COUNTA, COUNTIF, INDEX, ROWS, COLUMNS In-Reply-To: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-Reason: AssignedTo Message-Id: <rodgerskatie@example.net> Date: Fri, 1 Feb 2008 16:31:41 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=44345>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=44345 ------- Additional Comments From rodgerskatie@example.net 2008-02-01 16:31 ------- Created an attachment (id=21460) --> (http://issues.apache.org/bugzilla/attachment.cgi?id=21460&action=view) svndiff and added files -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Sat Feb 02 17:14:01 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 33907 invoked from network); 2 Feb 2008 17:14:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Feb 2008 17:14:01 -0000 Received: (qmail 43531 invoked by uid 500); 2 Feb 2008 17:13:52 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 43511 invoked by uid 500); 2 Feb 2008 17:13:52 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 43495 invoked by uid 99); 2 Feb 2008 17:13:52 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 Feb 2008 09:13:52 -0800 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=RCVD_IN_BL_SPAMCOP_NET,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [83.161.120.155] (HELO dinom.ru) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 Feb 2008 17:13:37 +0000 Received: from [83.161.120.155] (helo=[83.161.120.155]) by dinom.ru with esmtpa (Exim 4.63) (envelope-from <rodgerskatie@example.net>) id JVMG3M-0000R4-4C for rodgerskatie@example.net; Sat, 02 Feb 2008 20:18:58 +0300 Date: Sat, 2 Feb 2008 20:13:13 +0300 From: Yegor Kozlov <rodgerskatie@example.net> X-Mailer: The Bat! (v3.85.03) Professional Organization: Dinom LLC X-Priority: 3 (Normal) Message-ID: <rodgerskatie@example.net> To: "POI Developers List" <rodgerskatie@example.net> Subject: Re: Fun with HSSF and Hyperlinks In-Reply-To: <rodgerskatie@example.net> References: <rodgerskatie@example.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org By the way, where did you find the implementation of HyperlinkRecord? Which Bug #? 1. HyperlinkRecord construction failed on non-URL links, in particular, on links to a place in worksheet. I added a check to prevent reading past EOF. 2. HyperlinkRecord.fillFields is incomplete. It works only with URL type of links. I didn't decode it yet but fillFields should behave something like this: if(type == URL){ //read URL properties } else if (type == email){ //read email properties } else if (type == document){ //read coordinates of a cell in this document } else { //unknown ... } In each case the rules are different. The same applies to serialize(). Any thoughts how to decode it? 3. Hyperlink is a special info attached to a cell. Very much like cell comment. To find a hyperlink you need to traverse through the sheet records and test row and column of found HyperlinkRecords. I added HSSFHyperlink object and getHyperlink/setHyperlink to HSSFCell. For now only getHyperlink() works. setHyperlink is not yet implemented. First, we need to finish with HyperlinkRecord and figure out how to fill data for different types of links. Once this is implemented, assigning a hyperlink to a cell would be just appending a HyperlinkRecord to sheet records. Regards, Yegor > Hi All > I had a stab at doing hyperlink support for hssf (bug #37923). After > discovering a rather old, stub implementation of the record, handily under > an apache licence, I was able to get most of the Hyperlink record > supported. (A few unknowns, and one bit of black magic, but all files > containing the record in our test suite still open fine...). Oh, and I've > done record tests for it all too, which seem to cover most things. > On trying to add usermodel support for it, I hit a bit of a snag. The > records weren't ending up in Workbook.records, as they came after the > EOFRecord, so weren't being picked up by the interesting records sweep in > Workbook.createWorkbook > As a stop-gap, I've got Workbook.createWorkbook to check the records after > EOFRecord, and pop the Hyperlink records into another array. However, this > doesn't let them tie in with cells, as they're in the wrong place, and I'm > not even sure how to tell which sheet a Hyperlink belongs to (row+column > are easy though) > I've also done some unit tests in usermodel.HSSFCell, which are disabled > for now as the cells don't get created, as the Hyperlink records aren't > picked up by the sheet's record sweep. So, if you fancy trying to finish > the support off, they should get you most of the way there for a test, > then you just need to deal with getting the records into where they need > to be... > Nick > --------------------------------------------------------------------- > To unsubscribe, e-mail: rodgerskatie@example.net > For additional commands, e-mail: rodgerskatie@example.net --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Sun Feb 03 19:18:10 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 64273 invoked from network); 3 Feb 2008 19:18:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Feb 2008 19:18:10 -0000 Received: (qmail 36398 invoked by uid 500); 3 Feb 2008 19:18:01 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 36380 invoked by uid 500); 3 Feb 2008 19:18:01 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 36371 invoked by uid 99); 3 Feb 2008 19:18:00 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 03 Feb 2008 11:18:00 -0800 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 03 Feb 2008 19:17:41 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 843F071406E; Sun, 3 Feb 2008 11:17:48 -0800 (PST) From: rodgerskatie@example.net To: rodgerskatie@example.net Subject: DO NOT REPLY [Bug 44345] - [patch] Added implementations for Excel functions COUNTA, COUNTIF, INDEX, ROWS, COLUMNS In-Reply-To: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-Reason: AssignedTo Message-Id: <rodgerskatie@example.net> Date: Sun, 3 Feb 2008 11:17:48 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=44345>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=44345 ------- Additional Comments From rodgerskatie@example.net 2008-02-03 11:17 ------- The attached archive contains only unit tests. The implementation is missing. Regards, Yegor -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Mon Feb 04 10:49:47 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 59017 invoked from network); 4 Feb 2008 10:49:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Feb 2008 10:49:46 -0000 Received: (qmail 97108 invoked by uid 500); 4 Feb 2008 10:49:38 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 97082 invoked by uid 500); 4 Feb 2008 10:49:38 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 97073 invoked by uid 99); 4 Feb 2008 10:49:38 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Feb 2008 02:49:38 -0800 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Feb 2008 10:49:18 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id D1B4C714044; Mon, 4 Feb 2008 02:49:25 -0800 (PST) From: rodgerskatie@example.net To: rodgerskatie@example.net Subject: DO NOT REPLY [Bug 44345] - [patch] Added implementations for Excel functions COUNTA, COUNTIF, INDEX, ROWS, COLUMNS In-Reply-To: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-Reason: AssignedTo Message-Id: <rodgerskatie@example.net> Date: Mon, 4 Feb 2008 02:49:25 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=44345>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=44345 rodgerskatie@example.net changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- Additional Comments From rodgerskatie@example.net 2008-02-04 02:49 ------- Thanks for the patch (spotted it hidden in the tar file!) and unit tests I've applied them to svn trunk. As for the JDK issue, we are aiming for it to still build on jdk 1.4, but sometimes a 1.5 jdk will happily compile some 1.5 only stuff when in 1.4 compatibility mode, so the odd things slips through :( -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Mon Feb 04 11:15:57 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 65415 invoked from network); 4 Feb 2008 11:15:57 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Feb 2008 11:15:57 -0000 Received: (qmail 29750 invoked by uid 500); 4 Feb 2008 11:15:48 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 29517 invoked by uid 500); 4 Feb 2008 11:15:48 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 29505 invoked by uid 99); 4 Feb 2008 11:15:48 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Feb 2008 03:15:48 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [83.161.120.155] (HELO fluffy.torchbox.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Feb 2008 11:15:33 +0000 Received: from [888a:dbb7:2d49:b3f6:8605:bf4e:caed:e5a4] by fluffy.torchbox.com with esmtp (Exim 4.63) (envelope-from <rodgerskatie@example.net>) id 1JLzIJ-0003Rj-QB for rodgerskatie@example.net; Mon, 04 Feb 2008 11:15:25 +0000 Date: Mon, 4 Feb 2008 11:11:58 +0000 (GMT) From: Nick Burch <rodgerskatie@example.net> X-X-Sender: rodgerskatie@example.net To: POI Developers List <rodgerskatie@example.net> Subject: Re: Fun with HSSF and Hyperlinks In-Reply-To: <rodgerskatie@example.net> Message-ID: <rodgerskatie@example.net> References: <rodgerskatie@example.net> <rodgerskatie@example.net> User-Agent: Alpine 1.00 (LFD 882 2007-12-20) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Spam-Score: -2.5 (--) Organization: Torchbox Ltd, Registered Company #3983354, Unit 9, Southill Business Park, OX7 3EW, UK X-Virus-Checked: Checked by ClamAV on apache.org On Sat, 2 Feb 2008, Yegor Kozlov wrote: > By the way, where did you find the implementation of HyperlinkRecord? > Which Bug #? Actually, google! I searched for some documentation on the record format, and found an apache licenced stub implementation > 1. HyperlinkRecord construction failed on non-URL links, in particular, > on links to a place in worksheet. I added a check to prevent reading > past EOF. Excellent, thanks. I only tested it with the kinds of hyperlink I might ever use > 2. HyperlinkRecord.fillFields is incomplete. It works only with URL type > of links. I didn't decode it yet but fillFields should behave something > like this: > > Any thoughts how to decode it? Create a couple of each type, and stare at the bytes until they make sense? Otherwise, wait another few weeks, and hope it's covered by the binary file format docs Microsoft are due to release then > 3. Hyperlink is a special info attached to a cell. Very much like cell > comment. To find a hyperlink you need to traverse through the sheet > records and test row and column of found HyperlinkRecords. Hmm, how does that work if I have hyperlinks on two different sheets? Say, one in A2 on sheets 1 and 2, how do we tell those apart? > I added HSSFHyperlink object and getHyperlink/setHyperlink to HSSFCell. > For now only getHyperlink() works. > > setHyperlink is not yet implemented. First, we need to finish with > HyperlinkRecord and figure out how to fill data for different types of > links. Once this is implemented, assigning a hyperlink to a cell would > be just appending a HyperlinkRecord to sheet records. Sounds good. I'd suggest we wait a few weeks and see what docs we can get then, unless you fancy staring at some byte arrays before then to make sense of it all! For now, I've added another test excel file, HyperlinksOnManySheets.xls. This has web links, emails, and internal links, over several different sheets. Ought to be a good starting point for testing further functionality Nick --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Mon Feb 04 11:52:44 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 72880 invoked from network); 4 Feb 2008 11:52:44 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Feb 2008 11:52:44 -0000 Received: (qmail 73253 invoked by uid 500); 4 Feb 2008 11:52:35 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 73224 invoked by uid 500); 4 Feb 2008 11:52:34 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 73193 invoked by uid 99); 4 Feb 2008 11:52:34 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Feb 2008 03:52:34 -0800 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 [83.161.120.155] (HELO dinom.ru) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Feb 2008 11:52:05 +0000 Received: from [83.161.120.155] (helo=[83.161.120.155]) by dinom.ru with esmtpa (Exim 4.63) (envelope-from <rodgerskatie@example.net>) id JVPQK9-00017G-KE for rodgerskatie@example.net; Mon, 04 Feb 2008 14:57:45 +0300 Date: Mon, 4 Feb 2008 14:51:58 +0300 From: Yegor Kozlov <rodgerskatie@example.net> X-Mailer: The Bat! (v3.85.03) Professional Organization: Dinom LLC X-Priority: 3 (Normal) Message-ID: <rodgerskatie@example.net> To: "POI Developers List" <rodgerskatie@example.net> Subject: Re[2]: Fun with HSSF and Hyperlinks In-Reply-To: <rodgerskatie@example.net> References: <rodgerskatie@example.net> <rodgerskatie@example.net> <rodgerskatie@example.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org > Create a couple of each type, and stare at the bytes until they make > sense? Otherwise, wait another few weeks, and hope it's covered by the > binary file format docs Microsoft are due to release then I keep hacking it :) If I don't have success then let's wait, although I wouldn't much count on Microsoft releasing the HLINK spec in a few weeks. >> 3. Hyperlink is a special info attached to a cell. Very much like cell >> comment. To find a hyperlink you need to traverse through the sheet >> records and test row and column of found HyperlinkRecords. > Hmm, how does that work if I have hyperlinks on two different sheets? Say, > one in A2 on sheets 1 and 2, how do we tell those apart? Note, I'm iterating through Sheet.records. So, it should work across sheets. I'm going to test my usermodel code against HyperlinksOnManySheets.xls later today. Yegor > --------------------------------------------------------------------- > To unsubscribe, e-mail: rodgerskatie@example.net > For additional commands, e-mail: rodgerskatie@example.net --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Mon Feb 04 12:19:35 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 85529 invoked from network); 4 Feb 2008 12:19:35 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Feb 2008 12:19:35 -0000 Received: (qmail 11250 invoked by uid 500); 4 Feb 2008 12:19:27 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 11018 invoked by uid 500); 4 Feb 2008 12:19:26 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 11006 invoked by uid 99); 4 Feb 2008 12:19:26 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Feb 2008 04:19:26 -0800 X-ASF-Spam-Status: No, hits=2.7 required=10.0 tests=SPF_PASS,SUBJ_RE_NUM X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [83.161.120.155] (HELO fluffy.torchbox.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Feb 2008 12:19:12 +0000 Received: from [888a:dbb7:2d49:b3f6:8605:bf4e:caed:e5a4] by fluffy.torchbox.com with esmtp (Exim 4.63) (envelope-from <rodgerskatie@example.net>) id 1JM0Hv-0006PL-MC for rodgerskatie@example.net; Mon, 04 Feb 2008 12:19:04 +0000 Date: Mon, 4 Feb 2008 12:15:38 +0000 (GMT) From: Nick Burch <rodgerskatie@example.net> X-X-Sender: rodgerskatie@example.net To: POI Developers List <rodgerskatie@example.net> Subject: Re[2]: Fun with HSSF and Hyperlinks In-Reply-To: <rodgerskatie@example.net> Message-ID: <rodgerskatie@example.net> References: <rodgerskatie@example.net> <rodgerskatie@example.net> <rodgerskatie@example.net> <rodgerskatie@example.net> User-Agent: Alpine 1.00 (LFD 882 2007-12-20) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Spam-Score: -1.0 (-) Organization: Torchbox Ltd, Registered Company #3983354, Unit 9, Southill Business Park, OX7 3EW, UK X-Virus-Checked: Checked by ClamAV on apache.org On Mon, 4 Feb 2008, Yegor Kozlov wrote: >> Hmm, how does that work if I have hyperlinks on two different sheets? >> Say, one in A2 on sheets 1 and 2, how do we tell those apart? > > Note, I'm iterating through Sheet.records. So, it should work across > sheets. I'm going to test my usermodel code against > HyperlinksOnManySheets.xls later today. Ah, didn't look on those. I had some issues with the records not appearing in the workbook's record list, but didn't think to check the sheet's records Nick --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Mon Feb 04 14:42:08 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 47284 invoked from network); 4 Feb 2008 14:42:08 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Feb 2008 14:42:08 -0000 Received: (qmail 64327 invoked by uid 500); 4 Feb 2008 14:42:00 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 64299 invoked by uid 500); 4 Feb 2008 14:42:00 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 64283 invoked by uid 99); 4 Feb 2008 14:41:59 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Feb 2008 06:41:59 -0800 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 [83.161.120.155] (HELO dinom.ru) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Feb 2008 14:41:31 +0000 Received: from [83.161.120.155] (helo=[83.161.120.155]) by dinom.ru with esmtpa (Exim 4.63) (envelope-from <rodgerskatie@example.net>) id JVPYEP-0000W8-0E for rodgerskatie@example.net; Mon, 04 Feb 2008 17:47:13 +0300 Date: Mon, 4 Feb 2008 17:41:25 +0300 From: Yegor Kozlov <rodgerskatie@example.net> X-Mailer: The Bat! (v3.85.03) Professional Organization: Dinom LLC X-Priority: 3 (Normal) Message-ID: <rodgerskatie@example.net> To: "POI Developers List" <rodgerskatie@example.net> Subject: Re: [VOTE] Release 3.0.2 BETA3 as 3.0.2 FINAL In-Reply-To: <rodgerskatie@example.net> References: <rodgerskatie@example.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Any more people wanting to review the release candidate? Actually, only Nick and I voted. I need at least one +1 PMC vote to release. Yegor > Hi All > I think we are ready to release POI 3.0.2 FINAL. > There was much development activity in January. Over 20 bugs have been fixed since 3.0.2 BETA2. > The full list of changes is available in the change log: > http://poi.apache.org/changes.html > I've done a release candidate for POI 3.0.2 FINAL. It can be downloaded from: > http://people.apache.org/~yegor/POI-3.0.2-FINAL/ > The build was produced from the REL_3_0_2_BETA3 tag which was merged with trunk r615598. > Note, the release does NOT include the new OOXML code. As discussed with Nick, > once OOXML support is ready for some sort of release, that will be POI 3.1. > Please say your opinion: > [ ] +1 I support the release > [ ] +0 I don't care > [ ] -1 I'm opposed to the release because... > I'm voting [+1]. Voting will last a week and end on Monday 4th February. > Yegor > --------------------------------------------------------------------- > To unsubscribe, e-mail: rodgerskatie@example.net > For additional commands, e-mail: rodgerskatie@example.net --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Tue Feb 05 06:53:07 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 82109 invoked from network); 5 Feb 2008 06:53:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Feb 2008 06:53:06 -0000 Received: (qmail 46528 invoked by uid 500); 5 Feb 2008 06:52:58 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 46506 invoked by uid 500); 5 Feb 2008 06:52:58 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 46497 invoked by uid 500); 5 Feb 2008 06:52:58 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 46494 invoked by uid 99); 5 Feb 2008 06:52:58 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Feb 2008 22:52:58 -0800 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Feb 2008 06:52:50 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 49E48714045; Mon, 4 Feb 2008 22:52:43 -0800 (PST) From: rodgerskatie@example.net To: rodgerskatie@example.net Subject: DO NOT REPLY [Bug 42564] - org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance In-Reply-To: <rodgerskatie@example.net/bugzilla/> X-Bugzilla-Reason: AssignedTo Message-Id: <rodgerskatie@example.net> Date: Mon, 4 Feb 2008 22:52:43 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=42564>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=42564 rodgerskatie@example.net changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Tue Feb 05 07:52:00 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 93703 invoked from network); 5 Feb 2008 07:52:00 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Feb 2008 07:52:00 -0000 Received: (qmail 83931 invoked by uid 500); 5 Feb 2008 07:51:51 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 83708 invoked by uid 500); 5 Feb 2008 07:51:51 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 83699 invoked by uid 99); 5 Feb 2008 07:51:51 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Feb 2008 23:51:51 -0800 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Feb 2008 07:51:31 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id C3757714045; Mon, 4 Feb 2008 23:51:38 -0800 (PST) From: rodgerskatie@example.net To: rodgerskatie@example.net Subject: DO NOT REPLY [Bug 43905] - Have the HSSFSheet and HSSFRow implement the Iterator interface In-Reply-To: <rodgerskatie@example.net/bugzilla/> X-Bugzilla-Reason: AssignedTo Message-Id: <rodgerskatie@example.net> Date: Mon, 4 Feb 2008 23:51:38 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=43905>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=43905 rodgerskatie@example.net changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|WORKSFORME | ------- Additional Comments From rodgerskatie@example.net 2008-02-04 23:51 ------- Sadly, Nick Burch is mistaken. If you test the code sample "Iterate over rows and cells (including Java 5 foreach loops)" at http://poi.apache.org/hssf/quick- guide.html#Iterator, you will find that it generates a compiler error "Can only iterate over an array or an instance of java.lang.Iterable". (Was this tested before publishing?) For this to work, Noel Markham's original suggestion should be implemented. For HSSFSheet and HSSFRow to be Iterable, there must be a method called iterator(). Alternatively (and perhaps more logically), you could return Iterable data structures through HSSFSheet.rows() and HSSFRow.cells(). -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Tue Feb 05 15:05:26 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 93146 invoked from network); 5 Feb 2008 15:05:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Feb 2008 15:05:26 -0000 Received: (qmail 82082 invoked by uid 500); 5 Feb 2008 15:05:17 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 82067 invoked by uid 500); 5 Feb 2008 15:05:17 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 82058 invoked by uid 99); 5 Feb 2008 15:05:17 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Feb 2008 07:05:17 -0800 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Feb 2008 15:04:57 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id BE1CC71406F; Tue, 5 Feb 2008 07:05:04 -0800 (PST) From: rodgerskatie@example.net To: rodgerskatie@example.net Subject: DO NOT REPLY [Bug 43905] - Have the HSSFSheet and HSSFRow implement the Iterator interface In-Reply-To: <rodgerskatie@example.net/bugzilla/> X-Bugzilla-Reason: AssignedTo Message-Id: <rodgerskatie@example.net> Date: Tue, 5 Feb 2008 07:05:04 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=43905>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=43905 ------- Additional Comments From rodgerskatie@example.net 2008-02-05 07:05 ------- Additionally, the Iterator returned by iterator() should be typed - i. e. return an Iterator<HSSFRow> or Iterator<HSSFSheet>. This avoids compiler warnings about type safety and increases user confidence. -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Tue Feb 05 15:23:59 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 15697 invoked from network); 5 Feb 2008 15:23:59 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Feb 2008 15:23:59 -0000 Received: (qmail 15217 invoked by uid 500); 5 Feb 2008 15:23:51 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 15195 invoked by uid 500); 5 Feb 2008 15:23:51 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 15186 invoked by uid 99); 5 Feb 2008 15:23:51 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Feb 2008 07:23:50 -0800 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Feb 2008 15:23:43 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 20ECF71406F; Tue, 5 Feb 2008 07:23:35 -0800 (PST) From: rodgerskatie@example.net To: rodgerskatie@example.net Subject: DO NOT REPLY [Bug 43905] - Have the HSSFSheet and HSSFRow implement the Iterator interface In-Reply-To: <rodgerskatie@example.net/bugzilla/> X-Bugzilla-Reason: AssignedTo Message-Id: <rodgerskatie@example.net> Date: Tue, 5 Feb 2008 07:23:35 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=43905>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=43905 ------- Additional Comments From rodgerskatie@example.net 2008-02-05 07:23 ------- (In reply to comment #3) > Additionally, the Iterator returned by iterator() should be typed - i. e. > return an Iterator<HSSFRow> or Iterator<HSSFSheet>. This avoids compiler > warnings about type safety and increases user confidence. Typing requires Java 1.5, and POI is aiming to stay working with Java 1.4, so that isn't going to be possible -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Tue Feb 05 16:36:09 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 37200 invoked from network); 5 Feb 2008 16:36:09 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Feb 2008 16:36:09 -0000 Received: (qmail 42544 invoked by uid 500); 5 Feb 2008 16:36:01 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 42316 invoked by uid 500); 5 Feb 2008 16:36:00 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 42307 invoked by uid 99); 5 Feb 2008 16:36:00 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Feb 2008 08:36:00 -0800 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Feb 2008 16:35:40 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 8FD5771406F; Tue, 5 Feb 2008 08:35:47 -0800 (PST) From: rodgerskatie@example.net To: rodgerskatie@example.net Subject: DO NOT REPLY [Bug 43905] - Have the HSSFSheet and HSSFRow implement the Iterator interface In-Reply-To: <rodgerskatie@example.net/bugzilla/> X-Bugzilla-Reason: AssignedTo Message-Id: <rodgerskatie@example.net> Date: Tue, 5 Feb 2008 08:35:47 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=43905>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=43905 rodgerskatie@example.net changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution| |WONTFIX ------- Additional Comments From rodgerskatie@example.net 2008-02-05 08:35 ------- It seems that the way sun introduced foreach loops in java 1.5 was rather stupid, and prevents your code from then working on java 1.4. Since we require java 1.4 compatibility, we can't implement java.lang.Iterable (though trunk does have the method that that requires). For now, you'll need to just use the normal iterator methods In the ooxml branch, we do have some workarounds for java 1.4 vs java 1.5 features, so Sheet/HSSFSheet/XSSFSheet and Row/HSSFRow/XSSFRow do implement java.lang.Iterable (when build on java 1.5), so foreach loops will work there. -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Tue Feb 05 17:49:37 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 65818 invoked from network); 5 Feb 2008 17:49:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Feb 2008 17:49:37 -0000 Received: (qmail 93155 invoked by uid 500); 5 Feb 2008 17:49:29 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 93119 invoked by uid 500); 5 Feb 2008 17:49:29 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 93109 invoked by uid 99); 5 Feb 2008 17:49:29 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Feb 2008 09:49:29 -0800 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [83.161.120.155] (HELO mail.lab49.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Feb 2008 17:49:14 +0000 Received: from qvt_118 ([83.161.120.155]) by mail.lab49.com over TLS secured channel with Microsoft SMTPSVC(901)896-3412); Tue, 5 Feb 2008 12:48:20 -0500 From: Avik Sengupta <rodgerskatie@example.net> To: "POI Developers List" <rodgerskatie@example.net> Subject: Re: [VOTE] Release 3.0.2 BETA3 as 3.0.2 FINAL Date: Tue, 5 Feb 2008 17:48:07 +0000 User-Agent: KMail/1.9.7 References: <rodgerskatie@example.net> <rodgerskatie@example.net> In-Reply-To: <rodgerskatie@example.net> Organization: Itellix Software Solutions Pvt Ltd MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <rodgerskatie@example.net> X-OriginalArrivalTime: 05 Feb 2008 17:48:20.0832 (UTC) FILETIME=[4BFEBE00:01C8681F] X-Virus-Checked: Checked by ClamAV on apache.org +1 Looks good. On Wednesday 30 January 2008 12:04:31 Nick Burch wrote: > On Mon, 28 Jan 2008, Yegor Kozlov wrote: > > I've done a release candidate for POI 3.0.2 FINAL. It can be downloaded > > from: > > http://people.apache.org/~yegor/POI-3.0.2-FINAL/ > > All the artifacts look good to me, so I'm +1 > > > Note, the release does NOT include the new OOXML code. As discussed with > > Nick, once OOXML support is ready for some sort of release, that will be > > POI 3.1. > > Depending on how long it takes to get the ooxml code stable and full > implemented, and how many core bugs we fix in the mean time, we might want > to do a 3.0.3 first. I guess we can decide that in a few months time, when > we know the fixed bug count, and have a decent eta on the ooxml stuff > being ready > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: rodgerskatie@example.net > For additional commands, e-mail: rodgerskatie@example.net --------------------------------------------------------------------- To unsubscribe, e-mail: rodgerskatie@example.net For additional commands, e-mail: rodgerskatie@example.net From rodgerskatie@example.net Wed Feb 06 05:02:27 2008 Return-Path: <rodgerskatie@example.net> Delivered-To: rodgerskatie@example.net Received: (qmail 24267 invoked from network); 6 Feb 2008 05:02:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 6 Feb 2008 05:02:26 -0000 Received: (qmail 41031 invoked by uid 500); 6 Feb 2008 05:02:18 -0000 Delivered-To: rodgerskatie@example.net Received: (qmail 41016 invoked by uid 500); 6 Feb 2008 05:02:18 -0000 Mailing-List: contact rodgerskatie@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:rodgerskatie@example.net> List-Unsubscribe: <mailto:rodgerskatie@example.net> List-Post: <mailto:rodgerskatie@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <rodgerskatie@example.net> Delivered-To: mailing list rodgerskatie@example.net Received: (qmail 41007 invoked by uid 99); 6 Feb 2008 05:02:18 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Feb 2008 21:02:18 -0800 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Feb 2008 05:02:11 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id F22BB71406E; Tue, 5 Feb 2008 21:02:01 -0800 (PST) From: rodgerskatie@example.net To: rodgerskatie@example.net Subject: DO NOT REPLY [Bug 44364] New: - [patch] Added Excel functions MATCH, NA, SUMPRODUCT and other fixes Message-ID: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-Reason: AssignedTo Date: Tue, 5 Feb 2008 21:02:01 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=44364>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED
{'source': 'Apache Software Foundation Public Mail Archives'}