From wurobert@example.net Fri Jan 01 12:06:16 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 29571 invoked from network); 1 Jan 2010 12:06:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Jan 2010 12:06:16 -0000 Received: (qmail 60727 invoked by uid 500); 1 Jan 2010 12:06:15 -0000 Delivered-To: wurobert@example.net Received: (qmail 60686 invoked by uid 500); 1 Jan 2010 12:06:14 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 60676 invoked by uid 99); 1 Jan 2010 12:06:14 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Jan 2010 12:06: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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Jan 2010 12:06:13 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id EA331234C1F1; Fri, 1 Jan 2010 04:05:51 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 48469] New: [PATCH] New Case Study 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: wurobert@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Date: Fri, 1 Jan 2010 04:05:51 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=48469 Summary: [PATCH] New Case Study Product: POI Version: unspecified Platform: Other OS/Version: other Status: NEW Severity: normal Priority: P2 Component: HSSF AssignedTo: wurobert@example.net ReportedBy: wurobert@example.net Attached is a word 2003 XML document detailing a product that has been designed around the Apache-HSSF software. If you have any questions/queries please E-mail me at wurobert@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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Fri Jan 01 12:09:18 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 30154 invoked from network); 1 Jan 2010 12:09:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Jan 2010 12:09:18 -0000 Received: (qmail 62485 invoked by uid 500); 1 Jan 2010 12:09:17 -0000 Delivered-To: wurobert@example.net Received: (qmail 62460 invoked by uid 500); 1 Jan 2010 12:09:17 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 62449 invoked by uid 99); 1 Jan 2010 12:09:17 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Jan 2010 12:09:17 +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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Jan 2010 12:09:17 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 0D869234C1F1; Fri, 1 Jan 2010 04:08:56 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 48469] [PATCH] New Case Study 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: wurobert@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <{{EMAIL+PHONE}}/bugzilla/> References: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <wurobert@example.net> Date: Fri, 1 Jan 2010 04:08:56 -0800 (PST) https://issues.apache.org/bugzilla/show_bug.cgi?id=48469 --- Comment #1 from Mark Golden <wurobert@example.net> 2010-01-01 04:08:56 UTC --- Created an attachment (id=24785) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24785) Microsoft work 97-2003 document -- 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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Sat Jan 02 13:52:28 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 16638 invoked from network); 2 Jan 2010 13:52:28 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Jan 2010 13:52:28 -0000 Received: (qmail 76768 invoked by uid 500); 2 Jan 2010 13:52:27 -0000 Delivered-To: wurobert@example.net Received: (qmail 76680 invoked by uid 500); 2 Jan 2010 13:52:26 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 76670 invoked by uid 99); 2 Jan 2010 13:52:26 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 Jan 2010 13:52: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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 Jan 2010 13:52:24 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 6C75C234C1F0; Sat, 2 Jan 2010 05:52:03 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 48472] New: OperandResolver parseDouble StringIndexOutOfBoundsException 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: wurobert@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Date: Sat, 2 Jan 2010 05:52:03 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=48472 Summary: OperandResolver parseDouble StringIndexOutOfBoundsException Product: POI Version: 3.7-dev Platform: PC OS/Version: All Status: NEW Severity: normal Priority: P2 Component: HSSF AssignedTo: wurobert@example.net ReportedBy: wurobert@example.net When I use OperandResolver.parseDouble to parse a string like excel and I write OperandResolver.parseDouble("-"); then occurs the following bug: Exception in thread "main" java.lang.StringIndexOutOfBoundsException: String index out of range: wurobert@example.net(Unknown Source) at org.apache.poi.hssf.record.formula.eval.OperandResolver.parseDouble(OperandResolver.java:247) PS: I know this will never use by anybody in this way, but if we calculate a formula with a reference to a minus, then occur exactly this, because the formulae use also OperandResolver.parseDouble -- 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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Sat Jan 02 18:18:09 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 96526 invoked from network); 2 Jan 2010 18:18:09 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Jan 2010 18:18:09 -0000 Received: (qmail 968 invoked by uid 500); 2 Jan 2010 18:18:08 -0000 Delivered-To: wurobert@example.net Received: (qmail 906 invoked by uid 500); 2 Jan 2010 18:18:08 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 895 invoked by uid 99); 2 Jan 2010 18:18:08 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 Jan 2010 18:18:08 +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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 Jan 2010 18:18:06 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id B8595234C1F0; Sat, 2 Jan 2010 10:17:45 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 48475] New: Escher properties initialization lockup on multi-threaded start X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HWPF X-Bugzilla-Keywords: PatchAvailable X-Bugzilla-Severity: normal X-Bugzilla-Who: wurobert@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Date: Sat, 2 Jan 2010 10:17:45 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=48475 Summary: Escher properties initialization lockup on multi-threaded start Product: POI Version: 3.7-dev Platform: All OS/Version: All Status: NEW Keywords: PatchAvailable Severity: normal Priority: P2 Component: HWPF AssignedTo: wurobert@example.net ReportedBy: wurobert@example.net Created an attachment (id=24786) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24786) patch to protect EscherProperties initialization, against trunk 2010-01-02 When multiple Word 97 documents hit our multi-threaded system the initial load of EscherProperties can cause a lockup. The attached patch protects the initialization phase of this class. Since it is loading a static HashMap it needs this protection to get loaded safely. -- 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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Sat Jan 02 19:11:43 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 19621 invoked from network); 2 Jan 2010 19:11:43 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Jan 2010 19:11:43 -0000 Received: (qmail 37804 invoked by uid 500); 2 Jan 2010 19:11:43 -0000 Delivered-To: wurobert@example.net Received: (qmail 37767 invoked by uid 500); 2 Jan 2010 19:11:42 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 37757 invoked by uid 99); 2 Jan 2010 19:11:42 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 Jan 2010 19:11:42 +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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 Jan 2010 19:11:42 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 2FBAE234C1F0; Sat, 2 Jan 2010 11:11:21 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 48475] Escher properties initialization lockup on multi-threaded start X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HWPF X-Bugzilla-Keywords: PatchAvailable X-Bugzilla-Severity: normal X-Bugzilla-Who: wurobert@example.net X-Bugzilla-Status: NEEDINFO X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Status In-Reply-To: <{{EMAIL+PHONE}}/bugzilla/> References: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <wurobert@example.net> Date: Sat, 2 Jan 2010 11:11:21 -0800 (PST) https://issues.apache.org/bugzilla/show_bug.cgi?id=48475 Josh Micich <wurobert@example.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO --- Comment #1 from Josh Micich <wurobert@example.net> 2010-01-02 11:11:21 UTC --- Your patch doesn't seem to change anything. I am almost certain that either version of this source file compiles to the same bytecode. I know synchronization errors are very difficult to prove, but can you at least write a non-deterministic test case (i.e. one that fails sometimes) to show that there is actually a problem here. A problem with a very similar description was 'fixed' with bug 47412. The problem there was much more obvious (concurrent access to a single map object referenced by a static field). Hopefully the 'fix' was obvious too (no test provided). >From what I understand, the JVM guarantees class initialisation to be synchronized, so the current code looks fine to me. I'm happy to be proven wrong, but I don't see any point in making an apparent change that actually does nothing. -- 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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Sun Jan 03 20:48:50 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 21530 invoked from network); 3 Jan 2010 20:48:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Jan 2010 20:48:50 -0000 Received: (qmail 65895 invoked by uid 500); 3 Jan 2010 20:48:50 -0000 Delivered-To: wurobert@example.net Received: (qmail 65843 invoked by uid 500); 3 Jan 2010 20:48:49 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 65833 invoked by uid 99); 3 Jan 2010 20:48:49 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 03 Jan 2010 20:48:49 +0000 X-ASF-Spam-Status: No, hits=0.7 required=10.0 tests=SPF_HELO_PASS,SPF_SOFTFAIL X-Spam-Check-By: apache.org Received-SPF: softfail (nike.apache.org: transitioning domain of wurobert@example.net does not designate 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO pluto.adsl24.co.uk) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 03 Jan 2010 20:48:39 +0000 Received: from home.gagravarr.org ([83.161.120.155] helo=pattertwig.gagravarr.org) by pluto.adsl24.co.uk with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from <wurobert@example.net>) id 1NRXN2-0001WL-T4 for wurobert@example.net; Sun, 03 Jan 2010 20:48:17 +0000 Received: from localhost ([83.161.120.155] ident=nick) by pattertwig.gagravarr.org with esmtp (Exim 4.69) (envelope-from <wurobert@example.net>) id 1NRXN5-0002V8-5u for wurobert@example.net; Sun, 03 Jan 2010 20:48:19 +0000 Date: Sun, 3 Jan 2010 20:48:08 +0000 (GMT) From: Nick Burch <wurobert@example.net> X-X-Sender: wurobert@example.net To: POI Developers List <wurobert@example.net> Subject: Re: excel text extraction In-Reply-To: <wurobert@example.net> Message-ID: <wurobert@example.net> References: <wurobert@example.net> User-Agent: Alpine 2.00 (DEB 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - pluto.adsl24.co.uk X-AntiAbuse: Original Domain - poi.apache.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - alfresco.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Checked: Checked by ClamAV on apache.org On Sun, 13 Dec 2009, Phil Varner wrote: > 1) ExtractorFactory uses the ExcelExtractor rather than the > EventBasedExcelExtractor, which causes it to OOM for very large > workbooks. I was wondering why this was and if it would be reasonable > to change it. The default is to use the UserModel based ones, as they tend to be more accurate and more configurable. However, I don't see why we couldn't add a "boolean preferEventBased" flag to toggle this. That said, iirc we only have an event based extractor for .xls, so it might not make all that much difference given that all other files you throw at it will take loads of memory again :/ > 2) Without an event-based extractor for OOXML workbooks, you can never > extract text from very large workbooks. I implemented a hacky > workaround to read only the shared strings xml doc, but I was wondering > if there was a better way to do this or if there was any interest in > polishing this into something that could be part of POI. You could probably base something on XLSX2CSV which is largely event based > 3) QuickButCruddyTextExtractor doesn't extend POIOLE2TextExtractor, > and I was wondering if there was a reason why. It predates the extractor interface by quite a bit, so I'm guessing it was forgotten :/ If you do fancy knocking up some patches for any of this, that's be very much appreciated :) Nick --------------------------------------------------------------------- To unsubscribe, e-mail: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Sun Jan 03 21:55:37 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 41635 invoked from network); 3 Jan 2010 21:55:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Jan 2010 21:55:37 -0000 Received: (qmail 89874 invoked by uid 500); 3 Jan 2010 21:55:37 -0000 Delivered-To: wurobert@example.net Received: (qmail 89821 invoked by uid 500); 3 Jan 2010 21:55:37 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 89811 invoked by uid 99); 3 Jan 2010 21:55:37 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 03 Jan 2010 21:55:37 +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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 03 Jan 2010 21:55:36 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 5E574234C48D; Sun, 3 Jan 2010 13:55:16 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 46136] Add an ignore warning for cells with Numbers as Text 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: enhancement X-Bugzilla-Who: wurobert@example.net X-Bugzilla-Status: NEEDINFO X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Status In-Reply-To: <wurobert@example.net/bugzilla/> References: <wurobert@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 Message-Id: <wurobert@example.net> Date: Sun, 3 Jan 2010 13:55:16 -0800 (PST) https://issues.apache.org/bugzilla/show_bug.cgi?id=46136 Nick Burch <wurobert@example.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO --- Comment #4 from Nick Burch <wurobert@example.net> 2010-01-03 13:55:14 UTC --- Most of the record support should now be in SVN However, I'm not sure of the best way to expose it to the usermodel. As best as I can tell, each sheet can have a number of FeatHdr+Feat record pairs. Within each FeatRecord is an array of cell ranges that it applies to, then a particular shared feature. For example, it seems you can have: * range = a1 -> b1, type = formula ignore, set = number as text, empty cell ref * range = c1 -> c4 + c7 -> c8, type = formulas ignore, set = number as text * range = a1 -> b1, type = protection, title + type + password hash Any suggestions on where we've got something vaguely similar in the usermodel to copy the structure from greatly appreciated! -- 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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Mon Jan 04 06:20:46 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 92106 invoked from network); 4 Jan 2010 06:20:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Jan 2010 06:20:46 -0000 Received: (qmail 37711 invoked by uid 500); 4 Jan 2010 06:20:45 -0000 Delivered-To: wurobert@example.net Received: (qmail 37653 invoked by uid 500); 4 Jan 2010 06:20:45 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 37642 invoked by uid 99); 4 Jan 2010 06:20:44 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Jan 2010 06:20:44 +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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Jan 2010 06:20:44 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id A01D9234C04C; Sun, 3 Jan 2010 22:20:23 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 48462] Excel Name Box could not display the range name corresponding to the singlecell after create/change the range name using POI 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: wurobert@example.net X-Bugzilla-Status: REOPENED X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Status Resolution In-Reply-To: <{{EMAIL+PHONE}}/bugzilla/> References: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <wurobert@example.net> Date: Sun, 3 Jan 2010 22:20:23 -0800 (PST) https://issues.apache.org/bugzilla/show_bug.cgi?id=48462 Lion Liang <wurobert@example.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|INVALID | --- Comment #4 from Lion Liang <wurobert@example.net> 2010-01-03 22:20:19 UTC --- Thanks Josh. I just find using "Sheet1!$A$2" is working well on POI 3.5 for my requirement, but still not work for POI 3.2 Final. this might be something like a POI bug fix or enhancement after 3.2 final release. However I am still using POI 3.2 for my work, I can't find the corresponding bug or change list for this feature by searching in Bugzilla, could you please attach it here if you could find it? Thanks! BTW, I didn't have a chance to look at the way to use Retroweaver(you told me this in Bug 46547) to convert the latest POI release to run on a 1.4 JRE yet, but I'll definitely try it later. Thanks again for your helps. Sorry I have to put this bug to REOPENED to ensure it could be copied to you. -- 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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Mon Jan 04 13:48:26 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 9113 invoked from network); 4 Jan 2010 13:48:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Jan 2010 13:48:26 -0000 Received: (qmail 42660 invoked by uid 500); 4 Jan 2010 13:48:26 -0000 Delivered-To: wurobert@example.net Received: (qmail 42635 invoked by uid 500); 4 Jan 2010 13:48:26 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 42625 invoked by uid 99); 4 Jan 2010 13:48: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 Jan 2010 13:48: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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Jan 2010 13:48:24 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 77C8229A0012; Mon, 4 Jan 2010 05:48:03 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 48480] New: When there is a comment in a cell with cell-type BLANK, reading of comments doesn't work correctly. 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: wurobert@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Date: Mon, 4 Jan 2010 05:48:03 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=48480 Summary: When there is a comment in a cell with cell-type BLANK, reading of comments doesn't work correctly. Product: POI Version: 3.5-FINAL Platform: Macintosh OS/Version: Linux Status: NEW Severity: normal Priority: P2 Component: HSSF AssignedTo: wurobert@example.net ReportedBy: wurobert@example.net When there is a comment in a cell that doesn't have any other contents, reading of comments doesn't work correctly. I have a test file, where there are comments in two cells. In the first cell with a comment (let's call it cell A) the CELL-TYPE is STRING, and in the second cell with a comment (let's call it cell B), the CELL-TYPE is BLANK. When I read the cell A, I get the comment that is actually in the cell B. -- 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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Tue Jan 05 01:00:06 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 64001 invoked from network); 5 Jan 2010 01:00:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Jan 2010 01:00:06 -0000 Received: (qmail 54624 invoked by uid 500); 5 Jan 2010 01:00:05 -0000 Delivered-To: wurobert@example.net Received: (qmail 54559 invoked by uid 500); 5 Jan 2010 01:00:05 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 54549 invoked by uid 99); 5 Jan 2010 01:00:05 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jan 2010 01:00:05 +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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jan 2010 01:00:03 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id B1599234C1E9; Mon, 4 Jan 2010 16:59:42 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 46664] Print Area does not save in HSSF worksheets X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HDF X-Bugzilla-Keywords: X-Bugzilla-Severity: major X-Bugzilla-Who: wurobert@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Version Severity In-Reply-To: <wurobert@example.net/bugzilla/> References: <wurobert@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 Message-Id: <wurobert@example.net> Date: Mon, 4 Jan 2010 16:59:42 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46664 DGrossman98 <wurobert@example.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|3.5-dev |3.6 Severity|normal |major -- 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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Tue Jan 05 04:21:50 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 27394 invoked from network); 5 Jan 2010 04:21:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Jan 2010 04:21:50 -0000 Received: (qmail 50790 invoked by uid 500); 5 Jan 2010 04:21:50 -0000 Delivered-To: wurobert@example.net Received: (qmail 50686 invoked by uid 500); 5 Jan 2010 04:21:50 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 50676 invoked by uid 99); 5 Jan 2010 04:21:49 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jan 2010 04:21: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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jan 2010 04:21:49 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id E2D9B234C04C; Mon, 4 Jan 2010 20:21:28 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 45873] Formulas are not being recalculated X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: POI Overall X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: wurobert@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: CC In-Reply-To: <{{EMAIL+PHONE}}/bugzilla/> References: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <wurobert@example.net> Date: Mon, 4 Jan 2010 20:21:28 -0800 (PST) https://issues.apache.org/bugzilla/show_bug.cgi?id=45873 jofferson adrias <wurobert@example.net> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |wurobert@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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Tue Jan 05 08:02:52 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 98181 invoked from network); 5 Jan 2010 08:02:52 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Jan 2010 08:02:52 -0000 Received: (qmail 83469 invoked by uid 500); 5 Jan 2010 08:02:52 -0000 Delivered-To: wurobert@example.net Received: (qmail 83414 invoked by uid 500); 5 Jan 2010 08:02:52 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 83404 invoked by uid 99); 5 Jan 2010 08:02:51 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jan 2010 08:02: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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jan 2010 08:02:51 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 3179E234C04C; Tue, 5 Jan 2010 00:02:31 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 48485] New: Paper size A3 not available in HSSFPrintSetup 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: wurobert@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Date: Tue, 5 Jan 2010 00:02:31 -0800 (PST) https://issues.apache.org/bugzilla/show_bug.cgi?id=48485 Summary: Paper size A3 not available in HSSFPrintSetup Product: POI Version: 3.6 Platform: PC OS/Version: Linux Status: NEW Severity: normal Priority: P2 Component: HSSF AssignedTo: wurobert@example.net ReportedBy: wurobert@example.net The setPaperSize(short) method in HSSFPrintSetup does not currently support A3 papersize. (Supports A4,A5,Letter,Legal, Executive and a few Envelope sizes only). For large reports, A3 seems important. Would it be possible to add this also ? -- 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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Tue Jan 05 09:21:43 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 19019 invoked from network); 5 Jan 2010 09:21:43 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Jan 2010 09:21:43 -0000 Received: (qmail 64157 invoked by uid 500); 5 Jan 2010 09:21:43 -0000 Delivered-To: wurobert@example.net Received: (qmail 64104 invoked by uid 500); 5 Jan 2010 09:21:43 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 64094 invoked by uid 99); 5 Jan 2010 09:21:43 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jan 2010 09:21:43 +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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jan 2010 09:21:41 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 1643F234C48C; Tue, 5 Jan 2010 01:21:20 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 48485] Paper size A3 not available in HSSFPrintSetup 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: wurobert@example.net X-Bugzilla-Status: NEEDINFO X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Status In-Reply-To: <{{EMAIL+PHONE}}/bugzilla/> References: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <wurobert@example.net> Date: Tue, 5 Jan 2010 01:21:20 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=48485 Nick Burch <wurobert@example.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO --- Comment #1 from Nick Burch <wurobert@example.net> 2010-01-05 01:21:17 UTC --- Any chance you could upload two very simple otherwise identical files, one set to A4, and one set to A3? That'll be useful for double checking the settings needed in the file for A3, as well as being the basis for the unit tests for the feature once added. -- 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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Tue Jan 05 19:29:22 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 72682 invoked from network); 5 Jan 2010 19:29:21 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Jan 2010 19:29:21 -0000 Received: (qmail 13733 invoked by uid 500); 5 Jan 2010 19:29:21 -0000 Delivered-To: wurobert@example.net Received: (qmail 13662 invoked by uid 500); 5 Jan 2010 19:29:21 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 13652 invoked by uid 99); 5 Jan 2010 19:29:21 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jan 2010 19:29:21 +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 wurobert@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO mail-yx0-f195.google.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jan 2010 19:29:13 +0000 Received: by yxe33 with SMTP id 33so28769074yxe.0 for <wurobert@example.net>; Tue, 05 Jan 2010 11:28:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=SGAfflMT8XhCnOcBrV9HFQuu/BKS1OtTsnuCxxGcTyA=; b=bTtstDzF8SezU1CXruoAbgimqj78Lvs+jESDVgkBGcmjnTGvBt6ALhIvQSC19yv3eg 0InFOgabdCN4H8twlZ/ikbqlZ80VDtAidjBJac0vAQ1v1Lew9LscW3diOlcKW55S1ReV zx7CXaTlX07dF6Wia6h7yQJizU6LVbas+ypZc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=ZfINP/JTGw0O8F10VLLQQ5Dz0etOvEQx/88t2Hx5qqZyQcSGdPwcY3C5bA0FlNR9TO YamKFelCqs2LWO7oY3PHlRuW5cJhvE49NnkwMc6tWVFJNMSP4uaBZIhBd5ITPRUJkTu4 nU9zo9kw0vrzNyFlxbwKdBq+GiLlXYctY+mrU= MIME-Version: 1.0 Received: by 83.161.120.155 with SMTP id r20mr705634ybl.166.1262719732434; Tue, 05 Jan 2010 11:28:52 -0800 (PST) Date: Tue, 5 Jan 2010 11:28:52 -0800 Message-ID: <wurobert@example.net> Subject: EventBasedExcelExtractor issue with cell format strings From: Phil Varner <wurobert@example.net> To: wurobert@example.net Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org Hi all, The EBEE tries to format decimal values before returning them using the method formatNumberDateCell. I have some xls (unfortunately I can't share) that throw an exception from the DecimalFormat constructor: java.lang.IllegalArgumentException: Unquoted special character ';' in pattern "_(*#,##0_);_(*(#,##0);_(* "-"_);_(@_)" For my purposes, I just patched this to catch the exception and return the unformatted string, but that's probably not appropriate in the general case. If someone wants to provide some guidance as to what the format string means and how one might go about fixing it, I'd be glad to contribute. --Phil -- Machines might be interesting, but people are fascinating. -- K.P. --------------------------------------------------------------------- To unsubscribe, e-mail: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Tue Jan 05 19:42:23 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 74994 invoked from network); 5 Jan 2010 19:42:23 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Jan 2010 19:42:23 -0000 Received: (qmail 30126 invoked by uid 500); 5 Jan 2010 19:42:22 -0000 Delivered-To: wurobert@example.net Received: (qmail 30087 invoked by uid 500); 5 Jan 2010 19:42:22 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 30077 invoked by uid 99); 5 Jan 2010 19:42:22 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jan 2010 19:42:22 +0000 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: domain of wurobert@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO mail-yx0-f195.google.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jan 2010 19:42:15 +0000 Received: by yxe33 with SMTP id 33so28780855yxe.0 for <wurobert@example.net>; Tue, 05 Jan 2010 11:41:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type :content-transfer-encoding; bh=BbaRTeI/S1LDmGWSf++3AlWq52B/6/lTn2USXrDhS3U=; b=SeHCdsqB1ye5gCAp/JQetZzVO06/MUb3q9ZD6uNdqmitbTez/jzYhzLKbod9g05sIW 1H0ElLoL+p0HFIcL76dC2kOMJa94W2BHrIursjk6DEEWHL7wSt4WGSzmSc6QpTBUGvTd /9wEsF3UYIjXiG9HbGvwp0v/nnzTpf8DZTZGI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:content-transfer-encoding; b=u/20dDbDBu8A+qPKl9sZiSf/upb9/6Iv7tKUNb46UrCBwYxEZ4E6ZZREN5W6M2sXHw lia1oT18kEB5qjkFI5dj796+jkEGwQUZwL+8q/RXmduVHaGa7GPzVRaMU6Rr3bQv06w+ a/gXXG7uFKYwU6CYUBq7EsKxztIptBj9AnVYM= MIME-Version: 1.0 Received: by 83.161.120.155 with SMTP id y5mr38436625ybb.85.1262720514718; Tue, 05 Jan 2010 11:41:54 -0800 (PST) In-Reply-To: <wurobert@example.net> References: <wurobert@example.net> <wurobert@example.net> Date: Tue, 5 Jan 2010 11:41:53 -0800 Message-ID: <wurobert@example.net> Subject: Re: excel text extraction From: Phil Varner <wurobert@example.net> To: POI Developers List <wurobert@example.net> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Thanks for the suggestions. Comments inline >> 1) ExtractorFactory uses the ExcelExtractor rather than the >> EventBasedExcelExtractor, which causes it to OOM for very large workbook= s. >> =A0I was wondering why this was and if it would be reasonable to change = it. > > The default is to use the UserModel based ones, as they tend to be more > accurate and more configurable. However, I don't see why we couldn't add = a > "boolean preferEventBased" flag to toggle this. > > That said, iirc we only have an event based extractor for .xls, so it mig= ht > not make all that much difference given that all other files you throw at= it > will take loads of memory again :/ Yes, the event-based is only for xls. However, I think the difference is that an Excel doc has the potential to be very large (in my case, 65535x10) since they can be generated from another datasource, whereas ppt and doc are usually human-created and are much smaller. I think it's probably less common to have a word doc that took up multiple gigs in memory, but easy to do with excel. Anecdotally, my customer has several XLS that cause OOMs and no ppt or doc that do so. No easy answer here. >> 2) Without an event-based extractor for OOXML workbooks, you can never >> extract text from very large workbooks. =A0I implemented a hacky workaro= und to >> read only the shared strings xml doc, but I was wondering if there was a >> better way to do this or if there was any interest in polishing this int= o >> something that could be part of POI. > > You could probably base something on XLSX2CSV which is largely event base= d I got an OOM just loading the Package, so I don't think XLSX2CSV will work. >> 3) QuickButCruddyTextExtractor doesn't extend POIOLE2TextExtractor, >> and I was wondering if there was a reason why. > > It predates the extractor interface by quite a bit, so I'm guessing it wa= s > forgotten :/ I tried implementing it a few weeks ago, but there's a reason (now forgotten) that QBCTE can't implement POTE. I ran into a bug with it and switched back to PowerpointTextExtractor, which has worked fine. > > If you do fancy knocking up some patches for any of this, that's be very > much appreciated :) Will do, once I'm sure they're stable. --Phil --=20 Machines might be interesting, but people are fascinating. -- K.P. --------------------------------------------------------------------- To unsubscribe, e-mail: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Tue Jan 05 21:18:21 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 99527 invoked from network); 5 Jan 2010 21:18:21 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Jan 2010 21:18:21 -0000 Received: (qmail 57933 invoked by uid 500); 5 Jan 2010 21:18:21 -0000 Delivered-To: wurobert@example.net Received: (qmail 57882 invoked by uid 500); 5 Jan 2010 21:18:21 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 57872 invoked by uid 99); 5 Jan 2010 21:18:20 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jan 2010 21:18:20 +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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jan 2010 21:18:20 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id C9E4E234C48C; Tue, 5 Jan 2010 13:17:59 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 45678] HSSFDataFormatter returns some incorrect formatted strings 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: minor X-Bugzilla-Who: wurobert@example.net X-Bugzilla-Status: NEEDINFO X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <wurobert@example.net/bugzilla/> References: <wurobert@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 Message-Id: <wurobert@example.net> Date: Tue, 5 Jan 2010 13:17:59 -0800 (PST) https://issues.apache.org/bugzilla/show_bug.cgi?id=45678 --- Comment #7 from Dave Meikle <wurobert@example.net> 2010-01-05 13:17:55 UTC --- I have been implementing some code in Apache Tika (part of the Lucene community) to improve our number format support as part of a JIRA Ticket. As part of this is related to fractions I would like to progress the support of fractions with POI, therefore I have made changes to support dynamic usage of Commons Math. Still have a few tweaks to make and then will attach. Cheers, Dave -- 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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Wed Jan 06 03:21:37 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 25077 invoked from network); 6 Jan 2010 03:21:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 6 Jan 2010 03:21:37 -0000 Received: (qmail 72349 invoked by uid 500); 6 Jan 2010 03:21:36 -0000 Delivered-To: wurobert@example.net Received: (qmail 72305 invoked by uid 500); 6 Jan 2010 03:21:36 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 72295 invoked by uid 99); 6 Jan 2010 03:21:35 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jan 2010 03:21:35 +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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jan 2010 03:21:33 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id C0255234C04C; Tue, 5 Jan 2010 19:21:12 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 45873] Formulas are not being recalculated X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: POI Overall X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: wurobert@example.net X-Bugzilla-Status: RESOLVED X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Status Resolution In-Reply-To: <{{EMAIL+PHONE}}/bugzilla/> References: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <wurobert@example.net> Date: Tue, 5 Jan 2010 19:21:12 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=45873 Josh Micich <wurobert@example.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |WORKSFORME --- Comment #7 from Josh Micich <wurobert@example.net> 2010-01-05 19:21:09 UTC --- Your example seems to work OK with poi-2.5.1-final-20040804, poi-3.1-FINAL-20080629, poi-3.2-FINAL, poi-3.5-beta5-20090115, poi-3.5-FINAL-20090928, poi-3.6-20091214 But with poi-3.0-FINAL and poi-3.0.2-FINAL-20080204, POI fails to encode the formula correctly (perhaps an old bug token operand class transformation). I'm a little surprised that you reported 3.0-rc4-20070503 to work for you. Perhaps your observations are specific to a particular Excel version. I use Win Excel 2007. It might be the case that prior versions of Excel don't auto-calculate a spreadsheet without being forced to. I don't recall if POI has changed recently (with regard to the default value of the auto-calculate flag). Try HSSFSheet.setForceFormulaRecalculation() to force Excel to re-calculate all formulas on the current sheet upon opening. On the other hand, you can use HSSFFormulaEvaluator and evaluateFormulaCell() to update the cached formula results so that re-calculation by Excel is not relevant. -- 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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Wed Jan 06 10:35:40 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 42547 invoked from network); 6 Jan 2010 10:35:40 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 6 Jan 2010 10:35:40 -0000 Received: (qmail 63327 invoked by uid 500); 6 Jan 2010 10:35:40 -0000 Delivered-To: wurobert@example.net Received: (qmail 63277 invoked by uid 500); 6 Jan 2010 10:35:40 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 63267 invoked by uid 99); 6 Jan 2010 10:35:40 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jan 2010 10:35:40 +0000 X-ASF-Spam-Status: No, hits=-3.3 required=10.0 tests=RCVD_IN_DNSWL_MED,SPF_SOFTFAIL X-Spam-Check-By: apache.org Received-SPF: softfail (nike.apache.org: transitioning domain of wurobert@example.net does not designate 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO urchin.earth.li) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jan 2010 10:35:32 +0000 Received: from nick (helo=localhost) by urchin.earth.li with local-esmtp (Exim 4.69) (envelope-from <wurobert@example.net>) id 1NSTEN-0007rD-CI for wurobert@example.net; Wed, 06 Jan 2010 10:35:11 +0000 Date: Wed, 6 Jan 2010 10:35:11 +0000 (GMT) From: Nick Burch <wurobert@example.net> X-X-Sender: wurobert@example.net To: POI Developers List <wurobert@example.net> Subject: Re: EventBasedExcelExtractor issue with cell format strings In-Reply-To: <wurobert@example.net> Message-ID: <wurobert@example.net> References: <wurobert@example.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Checked: Checked by ClamAV on apache.org On Tue, 5 Jan 2010, Phil Varner wrote: > The EBEE tries to format decimal values before returning them using > the method formatNumberDateCell. I have some xls (unfortunately I > can't share) that throw an exception from the DecimalFormat > constructor: > java.lang.IllegalArgumentException: Unquoted special character ';' in > pattern "_(*#,##0_);_(*(#,##0);_(* "-"_);_(@_)" Any chance you could create a new simple workbook, and copy just the number formatting and that number over? If you upload that to bugzilla, we can then take a look OOI, does the usermodel cope ok with your format? Nick --------------------------------------------------------------------- To unsubscribe, e-mail: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Wed Jan 06 11:04:04 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 53584 invoked from network); 6 Jan 2010 11:04:04 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 6 Jan 2010 11:04:04 -0000 Received: (qmail 96566 invoked by uid 500); 6 Jan 2010 11:04:03 -0000 Delivered-To: wurobert@example.net Received: (qmail 96524 invoked by uid 500); 6 Jan 2010 11:04:03 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 96514 invoked by uid 99); 6 Jan 2010 11:04:03 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jan 2010 11:04: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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jan 2010 11:04:01 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id AF18E234C052; Wed, 6 Jan 2010 03:03:40 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 45678] HSSFDataFormatter returns some incorrect formatted strings 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: minor X-Bugzilla-Who: wurobert@example.net X-Bugzilla-Status: NEEDINFO X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <wurobert@example.net/bugzilla/> References: <wurobert@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 Message-Id: <wurobert@example.net> Date: Wed, 6 Jan 2010 03:03:40 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=45678 --- Comment #8 from Nick Burch <wurobert@example.net> 2010-01-06 03:03:37 UTC --- Great news, we'll look forward to seeing the patch :) -- 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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Wed Jan 06 11:58:57 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 71794 invoked from network); 6 Jan 2010 11:58:57 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 6 Jan 2010 11:58:57 -0000 Received: (qmail 78306 invoked by uid 500); 6 Jan 2010 11:58:56 -0000 Delivered-To: wurobert@example.net Received: (qmail 78251 invoked by uid 500); 6 Jan 2010 11:58:56 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 78241 invoked by uid 99); 6 Jan 2010 11:58:56 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jan 2010 11:58:56 +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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jan 2010 11:58:55 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 74086234C052; Wed, 6 Jan 2010 03:58:35 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 47188] setCellComment corrupts workbook (2007 XML format) 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: major X-Bugzilla-Who: wurobert@example.net X-Bugzilla-Status: NEEDINFO X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <wurobert@example.net/bugzilla/> References: <wurobert@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 Message-Id: <wurobert@example.net> Date: Wed, 6 Jan 2010 03:58:35 -0800 (PST) https://issues.apache.org/bugzilla/show_bug.cgi?id=47188 --- Comment #6 from rajeev <wurobert@example.net> 2010-01-06 03:58:33 UTC --- yes I am using 3.6 and without any template below is the code snippet ClientAnchor anchor = ch.createClientAnchor(); anchor.setCol1(6+i); anchor.setRow1(4+i); anchor.setCol2(12+i); anchor.setRow2(13+i); anchor.setDx1(i*4); anchor.setDy1(i*4); anchor.setDx2(i*4); anchor.setDy2(i*4); Comment comment = drawing.createCellComment(anchor); comment.setString(ch.createRichTextString(alias)); comment.setColumn(i); comment.setRow(0); cell.setCellComment(comment); Setting co-ordinates solved the anchoring problem but still i guess the same old error Opening the workbook gives the following error: Removed Records: Comments from /xl/comments1.xml part (Comments) Not sure whether I am missing anything. -- 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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Wed Jan 06 12:54:00 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 95603 invoked from network); 6 Jan 2010 12:54:00 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 6 Jan 2010 12:54:00 -0000 Received: (qmail 40484 invoked by uid 500); 6 Jan 2010 12:54:00 -0000 Delivered-To: wurobert@example.net Received: (qmail 40449 invoked by uid 500); 6 Jan 2010 12:54:00 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 40438 invoked by uid 99); 6 Jan 2010 12:54:00 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jan 2010 12:54:00 +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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jan 2010 12:53:59 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 5BAE1234C052; Wed, 6 Jan 2010 04:53:39 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 47188] setCellComment corrupts workbook (2007 XML format) 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: major X-Bugzilla-Who: wurobert@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Status In-Reply-To: <wurobert@example.net/bugzilla/> References: <wurobert@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 Message-Id: <wurobert@example.net> Date: Wed, 6 Jan 2010 04:53:39 -0800 (PST) https://issues.apache.org/bugzilla/show_bug.cgi?id=47188 rajeev <wurobert@example.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW --- Comment #7 from rajeev <wurobert@example.net> 2010-01-06 04:53:36 UTC --- changing the status after providing asked info -- 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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Wed Jan 06 17:33:46 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 3521 invoked from network); 6 Jan 2010 17:33:45 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 6 Jan 2010 17:33:45 -0000 Received: (qmail 80818 invoked by uid 500); 6 Jan 2010 17:33:45 -0000 Delivered-To: wurobert@example.net Received: (qmail 80764 invoked by uid 500); 6 Jan 2010 17:33:45 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 80754 invoked by uid 99); 6 Jan 2010 17:33:45 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jan 2010 17:33:45 +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 brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jan 2010 17:33:44 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 75A0D234C052; Wed, 6 Jan 2010 09:33:24 -0800 (PST) From: wurobert@example.net To: wurobert@example.net Subject: DO NOT REPLY [Bug 48493] New: Get NullPointerException in org.apache.xmlbeans.impl.store.Xobj.array_setter when creating Excel spreadsheet 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: critical X-Bugzilla-Who: wurobert@example.net X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: wurobert@example.net X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: <{{EMAIL+PHONE}}/bugzilla/> X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Date: Wed, 6 Jan 2010 09:33:24 -0800 (PST) https://issues.apache.org/bugzilla/show_bug.cgi?id=48493 Summary: Get NullPointerException in org.apache.xmlbeans.impl.store.Xobj.array_setter when creating Excel spreadsheet Product: POI Version: unspecified Platform: PC OS/Version: Windows XP Status: NEW Severity: critical Priority: P2 Component: XSSF AssignedTo: wurobert@example.net ReportedBy: wurobert@example.net Created an attachment (id=24802) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24802) The java class ExcelObj.java that is referenced in the bug text I have a web application that uses our ExcelObj.java (code attached) to write an Excel file. When it reaches the line wb.write(fOut); it stops with this exception: wurobert@example.net.array_setter(Xobj.java:2401) at org.apache.xmlbeans.impl.values.XmlComplexContentImpl.arraySetterHelper(XmlComplexContentImpl.java:1055) at org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTWorksheetImpl.setColsArray(Unknown Source) at org.apache.poi.xssf.usermodel.XSSFSheet.write(XSSFSheet.java:2297) at org.apache.poi.xssf.usermodel.XSSFSheet.commit(XSSFSheet.java:2287) at org.apache.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:177) at org.apache.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:181) at org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:214) at gov.bls.dbes.sled.util.ExcelObj.close(ExcelObj.java:110) at gov.bls.dbes.sled.util.ExcelWriter.writeExcelFile(ExcelWriter.java:296) at gov.bls.dbes.sled.util.ExcelWriter.writeExcelFile(ExcelWriter.java:352) at gov.bls.dbes.sled.action.ProcessNewExcelAction.outputExcel(ProcessNewExcelAction.java:231) at gov.bls.dbes.sled.action.ProcessNewExcelAction.writeOutExcel(ProcessNewExcelAction.java:125) at gov.bls.dbes.sled.action.ProcessNewExcelAction.execute(ProcessNewExcelAction.java:80) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.java:763) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3241) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2010) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:1916) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209) at weblogic.work.ExecuteThread.run(ExecuteThread.java:181) HOWEVER when I alter the single line wb = new XSSFWorkbook(); to be wb = new HSSFFWorkbook(); (in other words, to use HSSF rather than XSSF) the execution finishes normally. -- 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: wurobert@example.net For additional commands, e-mail: wurobert@example.net From wurobert@example.net Wed Jan 06 17:43:57 2010 Return-Path: <wurobert@example.net> Delivered-To: wurobert@example.net Received: (qmail 10773 invoked from network); 6 Jan 2010 17:43:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 6 Jan 2010 17:43:56 -0000 Received: (qmail 98893 invoked by uid 500); 6 Jan 2010 17:43:56 -0000 Delivered-To: wurobert@example.net Received: (qmail 98846 invoked by uid 500); 6 Jan 2010 17:43:56 -0000 Mailing-List: contact wurobert@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:wurobert@example.net> List-Unsubscribe: <mailto:wurobert@example.net> List-Post: <mailto:wurobert@example.net> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <wurobert@example.net> Delivered-To: mailing list wurobert@example.net Received: (qmail 98836 invoked by uid 99); 6 Jan 2010 17:43:56 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jan 2010 17:43:56 +0000 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: domain of wurobert@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO mail-yx0-f195.google.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jan 2010 17:43:49 +0000 Received: by yxe33 with SMTP id 33so29639641yxe.0 for <wurobert@example.net>; Wed, 06 Jan 2010 09:43:28 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=7iOMGajzxWBNO779ikpe7+f6AQL6rp4eZYbWK3hCPx0=; b=xeIXNsKgPfJkg6GVVtaQQDfYOacrJVqEIwpeeRQHjubl5Ya9xtfQnrcuYwYcPDe4BP tAGYaT4O2/MLH+sQGKB16oLt0elFYSw9kZsXUPQvtWvjwldUsf/qcFbKwFuYHCCApcQC
{'source': 'Apache Software Foundation Public Mail Archives'}