From benjaminwalker@example.net Thu Jul 01 17:13:22 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 18102 invoked from network); 1 Jul 2010 17:13:22 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 1 Jul 2010 17:13:22 -0000 Received: (qmail 91705 invoked by uid 500); 1 Jul 2010 17:13:22 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 91614 invoked by uid 500); 1 Jul 2010 17:13:21 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 91604 invoked by uid 99); 1 Jul 2010 17:13:21 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jul 2010 17:13:21 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jul 2010 17:13:18 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o61HCvR4029851 for <benjaminwalker@example.net>; Thu, 1 Jul 2010 17:12:57 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o61HCupa029850; Thu, 1 Jul 2010 13:12:56 -0400 (EDT) Date: Thu, 1 Jul 2010 13:12:56 -0400 (EDT) Message-Id: <benjaminwalker@example.net> From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49538] [PATCH] Implementing a excel predefined function POISSON X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: CC In-Reply-To: <benjaminwalker@example.net/bugzilla/> References: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=49538 Kalpesh Parmar <benjaminwalker@example.net> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |benjaminwalker@example.net -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Thu Jul 01 17:20:08 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 19982 invoked from network); 1 Jul 2010 17:20:08 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 1 Jul 2010 17:20:08 -0000 Received: (qmail 777 invoked by uid 500); 1 Jul 2010 17:20:07 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 729 invoked by uid 500); 1 Jul 2010 17:20:07 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 720 invoked by uid 99); 1 Jul 2010 17:20:07 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jul 2010 17:20:07 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jul 2010 17:20:04 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o61HCD2i029846 for <benjaminwalker@example.net>; Thu, 1 Jul 2010 17:12:13 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o61HCCxe029845; Thu, 1 Jul 2010 13:12:12 -0400 (EDT) Date: Thu, 1 Jul 2010 13:12:12 -0400 (EDT) From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49538] New: [PATCH] Implementing a excel predefined function POISSON X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=49538 Summary: [PATCH] Implementing a excel predefined function POISSON Product: POI Version: 3.7-dev Platform: PC OS/Version: Windows XP Status: NEW Severity: normal Priority: P2 Component: HSSF AssignedTo: benjaminwalker@example.net ReportedBy: benjaminwalker@example.net Created an attachment (id=25678) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25678) This is the zip of the patch file and the junit test. I have implemented the Poisson function ( within the NumericFunctions ). This also had the implication that I needed to use another library ( common-math - as I need not want to reinvent ) but I have updated the ant build.xml appropriately. I have also supplied a unit test for this function. I have only done this very quickly therefore ( although it does work - with validation and a unit test) it would be good for someone to verify that my changes are ok within your framework. I have attached the addition file (unit test) but it seems that when I created the patch it has included this new file in it (I have used tortoiseSVN to create the patch). The zip poi-hssf-poisson-patch.zip is attached. Hope this is helpful. If not please ask for any other info. Regards, Kalpesh -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Thu Jul 01 19:28:36 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 62651 invoked from network); 1 Jul 2010 19:28:35 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 1 Jul 2010 19:28:35 -0000 Received: (qmail 76307 invoked by uid 500); 1 Jul 2010 19:28:35 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 76265 invoked by uid 500); 1 Jul 2010 19:28:34 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 76253 invoked by uid 99); 1 Jul 2010 19:28:34 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jul 2010 19:28:34 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jul 2010 19:28:32 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o61JKerm001094 for <benjaminwalker@example.net>; Thu, 1 Jul 2010 19:20:40 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o61JKe7Z001093; Thu, 1 Jul 2010 15:20:40 -0400 (EDT) Date: Thu, 1 Jul 2010 15:20:40 -0400 (EDT) Message-Id: <benjaminwalker@example.net> From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49074] Creating Too Many Rich Strings Causes Excel 2007 Files to Lose All Formatting X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: major X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Status In-Reply-To: <benjaminwalker@example.net/bugzilla/> References: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=49074 Curtis Browning <benjaminwalker@example.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW --- Comment #2 from Curtis Browning <benjaminwalker@example.net> 2010-07-01 15:20:38 EDT --- Hi Nick, In response to your questions: 1. Yes, the 65 row x 10 column file is the smallest file that I can create in POI that will demonstrate the problem. 2. I have attached 4 sample Excel workbooks, two created via POI (test_export_64_rows.xls and test_export_65_rows.xls), and two created via the attached driver.vbs script (vba_64_rows.xls and vba_65_rows.xls). The two 64-row files and the two 65-row files contain the exact same cell content. 3. I tried following the steps you requested I take with the BiffViewer application, but the two files created via the VBA script cause BiffViewer to crash with a General Protection Fault. I also tried to manually create the test file in Excel (slow and cumbersome as it was), but the same GPF occurred when opening the file in BiffViewer. Please have a look at the attachments and the relevant POI code. Hopefully it will help you to get to the root cause of this problem. Regards, Curtis -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Thu Jul 01 19:30:04 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 62914 invoked from network); 1 Jul 2010 19:30:04 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 1 Jul 2010 19:30:04 -0000 Received: (qmail 78776 invoked by uid 500); 1 Jul 2010 19:30:04 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 78747 invoked by uid 500); 1 Jul 2010 19:30:03 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 78739 invoked by uid 99); 1 Jul 2010 19:30:03 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jul 2010 19:30:03 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jul 2010 19:30:01 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o61JM9ft001099 for <benjaminwalker@example.net>; Thu, 1 Jul 2010 19:22:09 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o61JM8g8001098; Thu, 1 Jul 2010 15:22:08 -0400 (EDT) Date: Thu, 1 Jul 2010 15:22:08 -0400 (EDT) Message-Id: <benjaminwalker@example.net> From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49074] Creating Too Many Rich Strings Causes Excel 2007 Files to Lose All Formatting X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: major X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <benjaminwalker@example.net/bugzilla/> References: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=49074 --- Comment #3 from Curtis Browning <benjaminwalker@example.net> 2010-07-01 15:22:06 EDT --- Created an attachment (id=25679) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25679) Test Driver to Create the Sample Excel Files -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Thu Jul 01 19:31:23 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 63223 invoked from network); 1 Jul 2010 19:31:23 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 1 Jul 2010 19:31:23 -0000 Received: (qmail 80198 invoked by uid 500); 1 Jul 2010 19:31:22 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 80105 invoked by uid 500); 1 Jul 2010 19:31:22 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 80097 invoked by uid 99); 1 Jul 2010 19:31:22 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jul 2010 19:31:22 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jul 2010 19:31:20 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o61JUw6j001147 for <benjaminwalker@example.net>; Thu, 1 Jul 2010 19:30:58 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o61JUwjJ001146; Thu, 1 Jul 2010 15:30:58 -0400 (EDT) Date: Thu, 1 Jul 2010 15:30:58 -0400 (EDT) Message-Id: <benjaminwalker@example.net> From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49074] Creating Too Many Rich Strings Causes Excel 2007 Files to Lose All Formatting X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: major X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <benjaminwalker@example.net/bugzilla/> References: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=49074 --- Comment #7 from Curtis Browning <benjaminwalker@example.net> 2010-07-01 15:30:56 EDT --- Created an attachment (id=25683) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25683) 65 rows created by driver.vbs script -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Thu Jul 01 19:36:50 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 64280 invoked from network); 1 Jul 2010 19:36:50 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 1 Jul 2010 19:36:50 -0000 Received: (qmail 89358 invoked by uid 500); 1 Jul 2010 19:36:50 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 89336 invoked by uid 500); 1 Jul 2010 19:36:49 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 89328 invoked by uid 99); 1 Jul 2010 19:36:49 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jul 2010 19:36:49 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jul 2010 19:36:46 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o61JStBs001129 for <benjaminwalker@example.net>; Thu, 1 Jul 2010 19:28:55 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o61JStKr001128; Thu, 1 Jul 2010 15:28:55 -0400 (EDT) Date: Thu, 1 Jul 2010 15:28:55 -0400 (EDT) Message-Id: <benjaminwalker@example.net> From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49074] Creating Too Many Rich Strings Causes Excel 2007 Files to Lose All Formatting X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: major X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <benjaminwalker@example.net/bugzilla/> References: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=49074 --- Comment #4 from Curtis Browning <benjaminwalker@example.net> 2010-07-01 15:28:53 EDT --- Created an attachment (id=25680) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25680) 64 rows created by POI code in the attached Driver.java -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Thu Jul 01 19:37:17 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 64350 invoked from network); 1 Jul 2010 19:37:17 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 1 Jul 2010 19:37:17 -0000 Received: (qmail 89837 invoked by uid 500); 1 Jul 2010 19:37:17 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 89779 invoked by uid 500); 1 Jul 2010 19:37:16 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 89771 invoked by uid 99); 1 Jul 2010 19:37:16 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jul 2010 19:37:16 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jul 2010 19:37:14 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o61JTN3N001139 for <benjaminwalker@example.net>; Thu, 1 Jul 2010 19:29:23 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o61JTNC1001138; Thu, 1 Jul 2010 15:29:23 -0400 (EDT) Date: Thu, 1 Jul 2010 15:29:23 -0400 (EDT) Message-Id: <benjaminwalker@example.net> From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49074] Creating Too Many Rich Strings Causes Excel 2007 Files to Lose All Formatting X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: major X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <benjaminwalker@example.net/bugzilla/> References: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=49074 --- Comment #5 from Curtis Browning <benjaminwalker@example.net> 2010-07-01 15:29:20 EDT --- Created an attachment (id=25681) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25681) 65 rows created by POI code in the attached Driver.java -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Thu Jul 01 19:38:27 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 64729 invoked from network); 1 Jul 2010 19:38:26 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 1 Jul 2010 19:38:26 -0000 Received: (qmail 91557 invoked by uid 500); 1 Jul 2010 19:38:26 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 91533 invoked by uid 500); 1 Jul 2010 19:38:26 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 91521 invoked by uid 99); 1 Jul 2010 19:38:26 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jul 2010 19:38:26 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jul 2010 19:38:24 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o61JUWsl001143 for <benjaminwalker@example.net>; Thu, 1 Jul 2010 19:30:32 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o61JUWVm001142; Thu, 1 Jul 2010 15:30:32 -0400 (EDT) Date: Thu, 1 Jul 2010 15:30:32 -0400 (EDT) Message-Id: <benjaminwalker@example.net> From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49074] Creating Too Many Rich Strings Causes Excel 2007 Files to Lose All Formatting X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: major X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <benjaminwalker@example.net/bugzilla/> References: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=49074 --- Comment #6 from Curtis Browning <benjaminwalker@example.net> 2010-07-01 15:30:30 EDT --- Created an attachment (id=25682) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25682) 64 rows created by driver.vbs script -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Fri Jul 02 11:03:42 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 6547 invoked from network); 2 Jul 2010 11:03:41 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 2 Jul 2010 11:03:41 -0000 Received: (qmail 13628 invoked by uid 500); 2 Jul 2010 11:03:41 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 13379 invoked by uid 500); 2 Jul 2010 11:03:39 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 13370 invoked by uid 99); 2 Jul 2010 11:03:38 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Jul 2010 11:03:38 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Jul 2010 11:03:36 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o62AtjOK008569 for <benjaminwalker@example.net>; Fri, 2 Jul 2010 10:55:45 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o62AtiJU008568; Fri, 2 Jul 2010 06:55:44 -0400 (EDT) Date: Fri, 2 Jul 2010 06:55:44 -0400 (EDT) From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49541] New: '=?UTF-8?Q?=EF=82=B375=20years?=' instead of '=?UTF-8?Q?=E2=89=A575=20years?=' X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSLF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=3D49541 Summary: '=EF=82=B375 years' instead of '=E2=89=A575 years' Product: POI Version: 3.6 Platform: PC OS/Version: Windows XP Status: NEW Severity: normal Priority: P2 Component: HSLF AssignedTo: benjaminwalker@example.net ReportedBy: benjaminwalker@example.net Created an attachment (id=3D25685) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=3D25685) test case Hi I tried to extract text from attached ppt. I get '=EF=82=B375 years' instea= d of '=E2=89=A575 years'.=20 BR, Piotr Lipski --=20 Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=3De= mail ------- You are receiving this mail because: ------- You are the assignee for the bug.= --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Fri Jul 02 12:20:56 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 28991 invoked from network); 2 Jul 2010 12:20:55 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 2 Jul 2010 12:20:55 -0000 Received: (qmail 3509 invoked by uid 500); 2 Jul 2010 12:20:55 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 3254 invoked by uid 500); 2 Jul 2010 12:20:52 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 3246 invoked by uid 99); 2 Jul 2010 12:20:51 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Jul 2010 12:20:51 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Jul 2010 12:20:49 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o62CKSua009152 for <benjaminwalker@example.net>; Fri, 2 Jul 2010 12:20:28 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o62CKRA0009151; Fri, 2 Jul 2010 08:20:27 -0400 (EDT) Date: Fri, 2 Jul 2010 08:20:27 -0400 (EDT) Message-Id: <benjaminwalker@example.net> From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49541] '=?UTF-8?Q?=EF=82=B375=20years?=' instead of '=?UTF-8?Q?=E2=89=A575=20years?=' X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSLF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEEDINFO X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Status In-Reply-To: <benjaminwalker@example.net/bugzilla/> References: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=49541 Nick Burch <benjaminwalker@example.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO --- Comment #1 from Nick Burch <benjaminwalker@example.net> 2010-07-02 08:20:23 EDT --- This could well be a case of microsoft making up their own codepoints for stuff Could you please confirm which character number is used in the file (use org.apache.poi.poifs.dev.POIFSViewer or similar to track it down), then confirm what unicode codepoint your character should actually be? -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Fri Jul 02 12:34:56 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 38280 invoked from network); 2 Jul 2010 12:34:56 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 2 Jul 2010 12:34:56 -0000 Received: (qmail 20078 invoked by uid 500); 2 Jul 2010 12:34:56 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 19843 invoked by uid 500); 2 Jul 2010 12:34:53 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 19835 invoked by uid 99); 2 Jul 2010 12:34:52 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Jul 2010 12:34:52 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Jul 2010 12:34:50 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o62CQxZG009193 for <benjaminwalker@example.net>; Fri, 2 Jul 2010 12:26:59 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o62CQxFG009192; Fri, 2 Jul 2010 08:26:59 -0400 (EDT) Date: Fri, 2 Jul 2010 08:26:59 -0400 (EDT) Message-Id: <benjaminwalker@example.net> From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49541] '=?UTF-8?Q?=EF=82=B375=20years?=' instead of '=?UTF-8?Q?=E2=89=A575=20years?=' X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSLF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEEDINFO X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <benjaminwalker@example.net/bugzilla/> References: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=49541 --- Comment #2 from Piotr Lipski <benjaminwalker@example.net> 2010-07-02 08:26:57 EDT --- It should be \u2265 instead I get \uf0b3. -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Fri Jul 02 21:07:07 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 76550 invoked from network); 2 Jul 2010 21:07:06 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 2 Jul 2010 21:07:06 -0000 Received: (qmail 84613 invoked by uid 500); 2 Jul 2010 21:07:06 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 84565 invoked by uid 500); 2 Jul 2010 21:07:05 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 84557 invoked by uid 99); 2 Jul 2010 21:07:05 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Jul 2010 21:07:05 +0000 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: domain of benjaminwalker@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO mx-out-manc3.simplymailsolutions.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Jul 2010 21:06:56 +0000 Received: from zimbra.alfresco.com ([83.161.120.155]) by mx-out-manc3.simplymailsolutions.com (8.14.1/8.14.1) with ESMTP id o62L4ZA5020846 for <benjaminwalker@example.net>; Fri, 2 Jul 2010 22:04:36 +0100 Received: from localhost (localhost.localdomain [83.161.120.155]) by zimbra.alfresco.com (Postfix) with ESMTP id CC6DC414023 for <benjaminwalker@example.net>; Fri, 2 Jul 2010 22:04:35 +0100 (BST) X-Virus-Scanned: benjaminwalker@example.net Received: from zimbra.alfresco.com ([83.161.120.155]) by localhost (zimbra.alfresco.com [83.161.120.155]) (amavisd-new, port 10024) with ESMTP id wcdNsvHBsNzO for <benjaminwalker@example.net>; Fri, 2 Jul 2010 22:04:35 +0100 (BST) Received: from urchin.earth.li (urchin.earth.li [83.161.120.155]) (Authenticated sender: benjaminwalker@example.net) by zimbra.alfresco.com (Postfix) with ESMTP id 5F23A414017 for <benjaminwalker@example.net>; Fri, 2 Jul 2010 22:04:35 +0100 (BST) Date: Fri, 2 Jul 2010 22:04:35 +0100 (BST) From: Nick Burch <benjaminwalker@example.net> X-X-Sender: benjaminwalker@example.net To: benjaminwalker@example.net Subject: Initial Word 6/95 support Message-ID: <benjaminwalker@example.net> User-Agent: Alpine 1.10 (DEB 962 2008-03-14) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; format=flowed; charset=US-ASCII X-Virus-Checked: Checked by ClamAV on apache.org Hi All As you might've seen from my commits in the last few days, I've added some initial support to HWPF for word 6 and word 95 files. I've only been working with a view to doing text extraction (so I can ditch the text mining library from a work project). With lots of trial and error, some offset tips from WV's FIB parsing code, and some refactoring, we can now get text and paragraphs out of word 6 and word 95 files! To play with this, you'll want HWPFOldDocument / Word6Extractor (catch OldWordFileFormatException and switch to the old one as needed) I've got this working with various sample files producing by doing save-as from newer software. This means that it's not impossible that real Word 6 / Word 95 files will break it, especially if they're quick-saved (I didn't have any examples) As usual, please upload files that don't work to new bugzilla entries, or even better upload the broken file and the patch that fixes it :) Nick --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Fri Jul 02 22:22:55 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 90680 invoked from network); 2 Jul 2010 22:22:55 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 2 Jul 2010 22:22:55 -0000 Received: (qmail 34497 invoked by uid 500); 2 Jul 2010 22:22:55 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 34471 invoked by uid 500); 2 Jul 2010 22:22:54 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Delivered-To: moderator for benjaminwalker@example.net Received: (qmail 30238 invoked by uid 99); 2 Jul 2010 22:17:46 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FREEMAIL_FROM,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of benjaminwalker@example.net designates 83.161.120.155 as permitted sender) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=YEW7K1RZ5XRNfwaQFVPnyYi0IhetadPR5CQ4wKMXNak=; b=FJPW9NI1yYRFSUDohJAmr2BO7elXonc/zNhrfhm3jCT/8PYfNnGMURWVRUivObDuH7 oZNMvzo+u6xIQ67fizGB5rflJkw1jhh9byJ64t2ALmqXC+B/Je4T+7EdS288AOBXjCPe DYK2tJql3EXr/2TEoS3JWrxQN0LfvctreNeBA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; b=BZqaa24YNFa+Y0MLx7eynRBfYAGb5QecQLFcAN51di5vy5DHg4UtY6+M/bwDZXby4w +cEjm+tNX5ydfsT5ug10/QLb+mQpleeOx+Ik7kWGsob4mJ8jvwhneMLwfRhKCxxVs73E h15JRLE0MOYPvH8JgBCygCz/uR/j4i+a3cLpg= Message-ID: <benjaminwalker@example.net> Date: Sat, 03 Jul 2010 00:17:04 +0200 From: Antoni Mylka <benjaminwalker@example.net> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; pl; rv:83.161.120.155) Gecko/20100512 Lightning/1.0b1 Thunderbird/3.0.5 MIME-Version: 1.0 To: POI Developers List <benjaminwalker@example.net> Subject: Re: Initial Word 6/95 support References: <benjaminwalker@example.net> In-Reply-To: <benjaminwalker@example.net> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org W dniu 2010-07-02 23:04, Nick Burch pisze: > Hi All > > As you might've seen from my commits in the last few days, I've added > some initial support to HWPF for word 6 and word 95 files. I've only > been working with a view to doing text extraction (so I can ditch the > text mining library from a work project). With lots of trial and error, > some offset tips from WV's FIB parsing code, and some refactoring, we > can now get text and paragraphs out of word 6 and word 95 files! > > To play with this, you'll want HWPFOldDocument / Word6Extractor (catch > OldWordFileFormatException and switch to the old one as needed) > > I've got this working with various sample files producing by doing > save-as from newer software. This means that it's not impossible that > real Word 6 / Word 95 files will break it, especially if they're > quick-saved (I didn't have any examples) > > As usual, please upload files that don't work to new bugzilla entries, > or even better upload the broken file and the patch that fixes it :) A great idea. Did you try to compare the Word6Extractor against the one from text mining? How well does it extract text? BTW, http://code.google.com/p/text-mining/ contains examples of fastsaved files you could use in your tests, they probably can't be committed to ASF for legal reasons (can they????), but they make great tests nonetheless. Antoni Myłka benjaminwalker@example.net --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Fri Jul 02 22:33:14 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 92956 invoked from network); 2 Jul 2010 22:33:13 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 2 Jul 2010 22:33:13 -0000 Received: (qmail 50193 invoked by uid 500); 2 Jul 2010 22:33:13 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 50170 invoked by uid 500); 2 Jul 2010 22:33:13 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 50162 invoked by uid 99); 2 Jul 2010 22:33:12 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Jul 2010 22:33:12 +0000 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: domain of benjaminwalker@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO mx-out-manc3.simplymailsolutions.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Jul 2010 22:33:04 +0000 Received: from zimbra.alfresco.com ([83.161.120.155]) by mx-out-manc3.simplymailsolutions.com (8.14.1/8.14.1) with ESMTP id o62MUhc9024640 for <benjaminwalker@example.net>; Fri, 2 Jul 2010 23:30:43 +0100 Received: from localhost (localhost.localdomain [83.161.120.155]) by zimbra.alfresco.com (Postfix) with ESMTP id C62B8414023 for <benjaminwalker@example.net>; Fri, 2 Jul 2010 23:30:43 +0100 (BST) X-Virus-Scanned: benjaminwalker@example.net Received: from zimbra.alfresco.com ([83.161.120.155]) by localhost (zimbra.alfresco.com [83.161.120.155]) (amavisd-new, port 10024) with ESMTP id xWh+nkrD1eNp for <benjaminwalker@example.net>; Fri, 2 Jul 2010 23:30:43 +0100 (BST) Received: from urchin.earth.li (urchin.earth.li [83.161.120.155]) (Authenticated sender: benjaminwalker@example.net) by zimbra.alfresco.com (Postfix) with ESMTP id 61520414017 for <benjaminwalker@example.net>; Fri, 2 Jul 2010 23:30:43 +0100 (BST) Date: Fri, 2 Jul 2010 23:30:43 +0100 (BST) From: Nick Burch <benjaminwalker@example.net> X-X-Sender: benjaminwalker@example.net To: POI Developers List <benjaminwalker@example.net> Subject: Re: Initial Word 6/95 support In-Reply-To: <benjaminwalker@example.net> Message-ID: <benjaminwalker@example.net> References: <benjaminwalker@example.net> <benjaminwalker@example.net> User-Agent: Alpine 1.10 (DEB 962 2008-03-14) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Checked: Checked by ClamAV on apache.org On Sat, 3 Jul 2010, Antoni Mylka wrote: > Did you try to compare the Word6Extractor against the one from text > mining? How well does it extract text? For my test documents, the POI code now does better than text mining does. This is because we process not just the CHPX character properties, but also the PAPX (paragraph) and SECX (section) tables too, which means we know where the paragraphs are. (However, we don't support decompressing the PAPX/CHPX properties, so you can't tell how a text run is formatted, only that it's different. If anyone cares, you'll need to figure out the differences in the style table between the old and the new format) > BTW, http://code.google.com/p/text-mining/ contains examples of > fastsaved files you could use in your tests, they probably can't be > committed to ASF for legal reasons (can they????), but they make great > tests nonetheless. The text mining library is now LGPL, so we can't commit their test files to POI. If you fancy trying one of their sample fastsaved word 6 or 95 files with Word6Extractor, I'd be interested to hear how it goes! Nick --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Mon Jul 05 13:54:51 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 51574 invoked from network); 5 Jul 2010 13:54:51 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 5 Jul 2010 13:54:51 -0000 Received: (qmail 79644 invoked by uid 500); 5 Jul 2010 13:54:51 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 79484 invoked by uid 500); 5 Jul 2010 13:54:50 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 79476 invoked by uid 99); 5 Jul 2010 13:54:49 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 05 Jul 2010 13:54:49 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 05 Jul 2010 13:54:46 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o65DsPbQ007651 for <benjaminwalker@example.net>; Mon, 5 Jul 2010 13:54:25 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o65DsOrr007650; Mon, 5 Jul 2010 09:54:24 -0400 (EDT) Date: Mon, 5 Jul 2010 09:54:24 -0400 (EDT) Message-Id: <benjaminwalker@example.net> From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49185] Implementation of HSSFName#getComment - descriptive text or comment record X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Attachment #25352 is obsolete In-Reply-To: <benjaminwalker@example.net/bugzilla/> References: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=49185 Andrew Shirley <benjaminwalker@example.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #25352|0 |1 is obsolete| | --- Comment #3 from Andrew Shirley <benjaminwalker@example.net> 2010-07-05 09:54:23 EDT --- Created an attachment (id=25706) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25706) test-data file for test added in previous patch A file for testing. This should be placed in test-data/spreadsheet -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Mon Jul 05 14:00:33 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 52590 invoked from network); 5 Jul 2010 14:00:33 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 5 Jul 2010 14:00:33 -0000 Received: (qmail 88346 invoked by uid 500); 5 Jul 2010 14:00:32 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 86755 invoked by uid 500); 5 Jul 2010 14:00:29 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 86733 invoked by uid 99); 5 Jul 2010 14:00:28 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 05 Jul 2010 14:00:28 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 05 Jul 2010 14:00:25 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o65DqYir007634 for <benjaminwalker@example.net>; Mon, 5 Jul 2010 13:52:34 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o65DqX4i007633; Mon, 5 Jul 2010 09:52:33 -0400 (EDT) Date: Mon, 5 Jul 2010 09:52:33 -0400 (EDT) Message-Id: <benjaminwalker@example.net> From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49185] Implementation of HSSFName#getComment - descriptive text or comment record X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <benjaminwalker@example.net/bugzilla/> References: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=49185 --- Comment #2 from Andrew Shirley <benjaminwalker@example.net> 2010-07-05 09:52:31 EDT --- Created an attachment (id=25705) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25705) patch to support 'NameCommentRecord's This patch parses and stores NameCommentRecord records and changes the implementation of HSSFName#getComment to use it's Description text and if that isn't available an associated NameCommentRecord. -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Tue Jul 06 02:58:35 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 26047 invoked from network); 6 Jul 2010 02:58:35 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 6 Jul 2010 02:58:35 -0000 Received: (qmail 63054 invoked by uid 500); 6 Jul 2010 02:58:35 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 62833 invoked by uid 500); 6 Jul 2010 02:58:33 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 62825 invoked by uid 99); 6 Jul 2010 02:58:33 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Jul 2010 02:58:33 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Jul 2010 02:58:30 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o662odl3012041 for <benjaminwalker@example.net>; Tue, 6 Jul 2010 02:50:39 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o662ocrE012040; Mon, 5 Jul 2010 22:50:38 -0400 (EDT) Date: Mon, 5 Jul 2010 22:50:38 -0400 (EDT) Message-Id: <benjaminwalker@example.net> From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 48325] bad text 'Page &P of &N' and similar errors when reading in spreadsheets X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: regression X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: CC In-Reply-To: <benjaminwalker@example.net/bugzilla/> References: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=48325 benjaminwalker@example.net changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |benjaminwalker@example.net -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Tue Jul 06 07:57:50 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 1641 invoked from network); 6 Jul 2010 07:57:50 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 6 Jul 2010 07:57:50 -0000 Received: (qmail 60029 invoked by uid 500); 6 Jul 2010 07:57:50 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 59773 invoked by uid 500); 6 Jul 2010 07:57:47 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 59763 invoked by uid 99); 6 Jul 2010 07:57:46 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Jul 2010 07:57:46 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Jul 2010 07:57:44 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o667vMPg014929 for <benjaminwalker@example.net>; Tue, 6 Jul 2010 07:57:22 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o667vM8C014928; Tue, 6 Jul 2010 03:57:22 -0400 (EDT) Date: Tue, 6 Jul 2010 03:57:22 -0400 (EDT) Message-Id: <benjaminwalker@example.net> From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49441] Wrong CharSet X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSMF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEEDINFO X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <benjaminwalker@example.net/bugzilla/> References: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=49441 --- Comment #5 from Dmitry <benjaminwalker@example.net> 2010-07-06 03:57:19 EDT --- I tried on a system with an English localization. If not set the Language for Non-Unicode Programs to Russian then message open with wrong characters. -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Tue Jul 06 10:01:18 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 34200 invoked from network); 6 Jul 2010 10:01:18 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 6 Jul 2010 10:01:18 -0000 Received: (qmail 80881 invoked by uid 500); 6 Jul 2010 10:01:18 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 80624 invoked by uid 500); 6 Jul 2010 10:01:15 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 80616 invoked by uid 99); 6 Jul 2010 10:01:14 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Jul 2010 10:01:14 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Jul 2010 10:01:11 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o66A0oM7016020 for <benjaminwalker@example.net>; Tue, 6 Jul 2010 10:00:50 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o66A0nlA016019; Tue, 6 Jul 2010 06:00:49 -0400 (EDT) Date: Tue, 6 Jul 2010 06:00:49 -0400 (EDT) Message-Id: <benjaminwalker@example.net> From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49538] [PATCH] Implementing a excel predefined function POISSON X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <benjaminwalker@example.net/bugzilla/> References: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=49538 --- Comment #1 from Kalpesh Parmar <benjaminwalker@example.net> 2010-07-06 06:00:46 EDT --- I have updated the patch as I missed out the case where if x is a decimal excel will automatically truncate it (now it is compliant with the excel definition of the Poisson function) Regards, I have (as before) attached the zip file which contains the patch ( created as before ) and the updated junit test. poi-hssf-poisson-patch2.zip is now the one to use. Thanks Kalpesh -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Tue Jul 06 10:11:10 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 39656 invoked from network); 6 Jul 2010 10:11:10 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 6 Jul 2010 10:11:10 -0000 Received: (qmail 86105 invoked by uid 500); 6 Jul 2010 10:11:10 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 85858 invoked by uid 500); 6 Jul 2010 10:11:08 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 85850 invoked by uid 99); 6 Jul 2010 10:11:07 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Jul 2010 10:11:07 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Jul 2010 10:11:04 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o66A3DjB016032 for <benjaminwalker@example.net>; Tue, 6 Jul 2010 10:03:13 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o66A3CAo016031; Tue, 6 Jul 2010 06:03:12 -0400 (EDT) Date: Tue, 6 Jul 2010 06:03:12 -0400 (EDT) Message-Id: <benjaminwalker@example.net> From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49538] [PATCH] Implementing a excel predefined function POISSON X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Attachment #25678 is obsolete In-Reply-To: <benjaminwalker@example.net/bugzilla/> References: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=49538 Kalpesh Parmar <benjaminwalker@example.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #25678|0 |1 is obsolete| | --- Comment #2 from Kalpesh Parmar <benjaminwalker@example.net> 2010-07-06 06:03:07 EDT --- Created an attachment (id=25712) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25712) [Patch] The corrected Poisson implementation function Update of the first patch I posted. I have added additional details below. -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Wed Jul 07 01:00:05 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 97918 invoked from network); 7 Jul 2010 01:00:05 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 7 Jul 2010 01:00:05 -0000 Received: (qmail 28009 invoked by uid 500); 7 Jul 2010 01:00:05 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 27948 invoked by uid 500); 7 Jul 2010 01:00:04 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 27939 invoked by uid 99); 7 Jul 2010 01:00:03 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Jul 2010 01:00:03 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Jul 2010 01:00:01 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o670xdeg023884 for <benjaminwalker@example.net>; Wed, 7 Jul 2010 00:59:39 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o670xdmE023883; Tue, 6 Jul 2010 20:59:39 -0400 (EDT) Date: Tue, 6 Jul 2010 20:59:39 -0400 (EDT) From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49564] New: getlocked return error value X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: XSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=49564 Summary: getlocked return error value Product: POI Version: 3.6 Platform: PC OS/Version: Windows XP Status: NEW Severity: normal Priority: P2 Component: XSSF AssignedTo: benjaminwalker@example.net ReportedBy: benjaminwalker@example.net Created an attachment (id=25722) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25722) upload xlsx file for test @Test public void testGetLockedFromXlsx(){ XSSFWorkbook wb; XSSFSheet sheet; FileInputStream finput=null; File file; String xlsSourceFile = "c:\\testgetcellstyle.xlsx"; file = new File(xlsSourceFile); try { finput = new FileInputStream(file); wb = new XSSFWorkbook(finput); sheet = wb.getSheetAt(0); XSSFRow row = sheet.getRow(0); XSSFCell cell = row.getCell(25); XSSFCellStyle cellStyle = cell.getCellStyle(); assertTrue(cellStyle.getLocked());//CellStyle.getLocked() should will return true,But really return false } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); }finally{ try { finput.close(); } catch (IOException e) { e.printStackTrace(); } } } -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Wed Jul 07 01:05:34 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 2693 invoked from network); 7 Jul 2010 01:05:33 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 7 Jul 2010 01:05:33 -0000 Received: (qmail 29423 invoked by uid 500); 7 Jul 2010 01:05:33 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 29378 invoked by uid 500); 7 Jul 2010 01:05:32 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 29370 invoked by uid 99); 7 Jul 2010 01:05:32 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Jul 2010 01:05:32 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO thor.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Jul 2010 01:05:30 +0000 Received: from thor.apache.org (localhost [83.161.120.155]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o67158rn024058 for <benjaminwalker@example.net>; Wed, 7 Jul 2010 01:05:08 GMT Received: (from daemon@localhost) by thor.apache.org (8.13.8+Sun/8.13.8/Submit) id o671582R024057; Tue, 6 Jul 2010 21:05:08 -0400 (EDT) Date: Tue, 6 Jul 2010 21:05:08 -0400 (EDT) Message-Id: <benjaminwalker@example.net> From: benjaminwalker@example.net To: benjaminwalker@example.net Subject: DO NOT REPLY [Bug 49564] getlocked return error value X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: XSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: benjaminwalker@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: benjaminwalker@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <benjaminwalker@example.net/bugzilla/> References: <benjaminwalker@example.net/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=49564 --- Comment #1 from benjaminwalker@example.net 2010-07-06 21:05:05 EDT --- Created an attachment (id=25723) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25723) Screenshot for the cell property -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Wed Jul 07 05:35:37 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 58789 invoked from network); 7 Jul 2010 05:35:36 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155) by 83.161.120.155 with SMTP; 7 Jul 2010 05:35:36 -0000 Received: (qmail 87028 invoked by uid 500); 7 Jul 2010 05:35:36 -0000 Delivered-To: benjaminwalker@example.net Received: (qmail 86773 invoked by uid 500); 7 Jul 2010 05:35:34 -0000 Mailing-List: contact benjaminwalker@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:benjaminwalker@example.net> List-Unsubscribe: <mailto:benjaminwalker@example.net> List-Post: <mailto:benjaminwalker@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <benjaminwalker@example.net> Delivered-To: mailing list benjaminwalker@example.net Received: (qmail 86759 invoked by uid 99); 7 Jul 2010 05:35:33 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Jul 2010 05:35:33 +0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FREEMAIL_FROM,SPF_HELO_PASS,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of benjaminwalker@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO kuber.nabble.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Jul 2010 05:35:26 +0000 Received: from isper.nabble.com ([83.161.120.155]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from <benjaminwalker@example.net>) id 1OWNHl-0000Wy-Ly for benjaminwalker@example.net; Tue, 06 Jul 2010 22:35:05 -0700 Message-ID: <benjaminwalker@example.net> Date: Tue, 6 Jul 2010 22:35:05 -0700 (PDT) From: mnsmcn <benjaminwalker@example.net> To: benjaminwalker@example.net Subject: how to compare two excel file with apache poi MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: benjaminwalker@example.net X-Virus-Checked: Checked by ClamAV on apache.org Joined: Apr 19, 2008 Posts: 48 posted Today 10:30:06 AM hi all i have a task to compare excel sheets,that should be generic,so that at run time it can be any excel file. i have written a code which checks rows and cells based on which i have written a logic to check one row with other row ie cells in it also. if they are differnt ,then color with blue in both cells and in both file. if they are same ,color it with common color and in both file but my problem is if sheet contain empty rows it is not giving proper count ie used getPhysicalNumberOfRows(),pSheet.getLastRowNum() which is not counting empty row. similarly cell if there is a row with cells ie last two cells of a row are empty its showing 1 less count i used both methods but not getting proper cell count ie .getLastCellNum(),getPhysicalNumberOfCells(). please give me idea for proper row count and cells,where my logic depends on it. or code snippets to compare to excel sheets. please give your inputs regarding the above. -- View this message in context: http://old.nabble.com/how-to-compare-two-excel-file-with-apache-poi-tp29092827p29092827.html Sent from the POI - Dev mailing list benjaminwalker@example.net. --------------------------------------------------------------------- To unsubscribe, e-mail: benjaminwalker@example.net For additional commands, e-mail: benjaminwalker@example.net From benjaminwalker@example.net Wed Jul 07 06:40:14 2010 Return-Path: <benjaminwalker@example.net> Delivered-To: benjaminwalker@example.net Received: (qmail 79596 invoked from network); 7 Jul 2010 06:40:14 -0000 Received: from unknown (HELO mail.apache.org) (83.161.120.155)
{'source': 'Apache Software Foundation Public Mail Archives'}