From millerrobert@example.com Sun Feb 01 15:11:53 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 78613 invoked from network); 1 Feb 2009 15:11:52 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Feb 2009 15:11:52 -0000 Received: (qmail 26567 invoked by uid 500); 1 Feb 2009 15:11:52 -0000 Delivered-To: millerrobert@example.com Received: (qmail 26547 invoked by uid 500); 1 Feb 2009 15:11:52 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 26536 invoked by uid 99); 1 Feb 2009 15:11:51 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 01 Feb 2009 07:11:51 -0800 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, 01 Feb 2009 15:11:50 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id E91B6234C4B7; Sun, 1 Feb 2009 07:11:28 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46635] Request: Add a method to remove slides. X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSLF X-Bugzilla-Keywords: X-Bugzilla-Severity: enhancement X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: RESOLVED X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Status Resolution In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Sun, 1 Feb 2009 07:11:28 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46635 Yegor Kozlov <millerrobert@example.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED --- Comment #2 from Yegor Kozlov <millerrobert@example.com> 2009-02-01 07:11:27 PST --- Added in r739775 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=739775 )Please note, that my implementation uses 0-based arguments, not 1-based as suggested in your patch. I would rather change SlideShow.reorderSlide to accept 0-based arguments than use 1-based throughout the code. Yegor -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Sun Feb 01 16:31:03 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 9049 invoked from network); 1 Feb 2009 16:31:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Feb 2009 16:31:03 -0000 Received: (qmail 64777 invoked by uid 500); 1 Feb 2009 16:31:02 -0000 Delivered-To: millerrobert@example.com Received: (qmail 64751 invoked by uid 500); 1 Feb 2009 16:31:02 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 64740 invoked by uid 99); 1 Feb 2009 16:31:02 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 01 Feb 2009 08:31:02 -0800 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, 01 Feb 2009 16:31:02 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id CE511234C4B7; Sun, 1 Feb 2009 08:30:41 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46627] offset of new pictures is sometimes wrong X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSLF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Sun, 1 Feb 2009 08:30:41 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46627 --- Comment #3 from David <millerrobert@example.com> 2009-02-01 08:30:41 PST --- Sorry, I am having trouble reproducing this problem on a new ppt file. The one that causes problems for me I cannot submit because of company policy, but this happened before on several files, so this does not seem to be an isolated incident. I will try again to reproduce the problem when I have more time (in about a week or so). bye, David. -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Sun Feb 01 16:49:27 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 16622 invoked from network); 1 Feb 2009 16:49:27 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Feb 2009 16:49:27 -0000 Received: (qmail 79875 invoked by uid 500); 1 Feb 2009 16:49:26 -0000 Delivered-To: millerrobert@example.com Received: (qmail 79843 invoked by uid 500); 1 Feb 2009 16:49:26 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 79832 invoked by uid 99); 1 Feb 2009 16:49:26 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 01 Feb 2009 08:49:26 -0800 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, 01 Feb 2009 16:49:26 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id DE478234C48D; Sun, 1 Feb 2009 08:49:05 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46627] offset of new pictures is sometimes wrong X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSLF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Sun, 1 Feb 2009 08:49:05 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46627 --- Comment #4 from Yegor Kozlov <millerrobert@example.com> 2009-02-01 08:49:05 PST --- I suspect it can be reproduced with PictureTypeZero.ppt or PictureLengthZero.ppt from our collection of test files: http://svn.apache.org/repos/asf/poi/trunk/src/scratchpad/testcases/org/apache/poi/hslf/data/ Can check it and post sample code that causes the problem? These two files contain invalid images, the first one contains images with unknown type=0, the second one contains images with zero length, i.e. only header and no data. Yegor -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Mon Feb 02 10:12:31 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 84622 invoked from network); 2 Feb 2009 10:12:31 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Feb 2009 10:12:31 -0000 Received: (qmail 13107 invoked by uid 500); 2 Feb 2009 10:12:31 -0000 Delivered-To: millerrobert@example.com Received: (qmail 13083 invoked by uid 500); 2 Feb 2009 10:12:31 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 13072 invoked by uid 99); 2 Feb 2009 10:12:30 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Feb 2009 02:12:30 -0800 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, 02 Feb 2009 10:12:28 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id C0D3C234C4BD; Mon, 2 Feb 2009 02:12:07 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46643] Inserted rows and cells do not notify already existing cells of events X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: blocker X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: NEEDINFO X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Status In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Mon, 2 Feb 2009 02:12:07 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46643 Nick Burch <millerrobert@example.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO --- Comment #4 from Nick Burch <millerrobert@example.com> 2009-02-02 02:12:06 PST --- Are you aware the excel caches formula values, and you need to re-calculate those cached values after altering things in poi? http://poi.apache.org/spreadsheet/eval.html -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Mon Feb 02 15:21:00 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 28975 invoked from network); 2 Feb 2009 15:21:00 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Feb 2009 15:21:00 -0000 Received: (qmail 96081 invoked by uid 500); 2 Feb 2009 15:20:59 -0000 Delivered-To: millerrobert@example.com Received: (qmail 96051 invoked by uid 500); 2 Feb 2009 15:20:59 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 96040 invoked by uid 99); 2 Feb 2009 15:20:59 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Feb 2009 07:20:59 -0800 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, 02 Feb 2009 15:20:57 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id BDB1F234C4BD; Mon, 2 Feb 2009 07:20:36 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46569] Image is reversed on a very wide column. X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: NEEDINFO X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Status In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Mon, 2 Feb 2009 07:20:36 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46569 Yegor Kozlov <millerrobert@example.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO --- Comment #2 from Yegor Kozlov <millerrobert@example.com> 2009-02-02 07:20:35 PST --- Your sample programs uses unresolved ReportWriterHelper.convertPixelsToCharacters and ReportWriterHelper.convertPixelsToPoints. Please re-attach an isolated test case. Also attach the image you are using for the header. Yegor -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Mon Feb 02 18:05:10 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 902 invoked from network); 2 Feb 2009 18:05:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Feb 2009 18:05:10 -0000 Received: (qmail 90351 invoked by uid 500); 2 Feb 2009 18:05:09 -0000 Delivered-To: millerrobert@example.com Received: (qmail 90329 invoked by uid 500); 2 Feb 2009 18:05:09 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 90318 invoked by uid 99); 2 Feb 2009 18:05:09 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Feb 2009 10:05:09 -0800 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, 02 Feb 2009 18:05:08 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 52AF8234C4AF; Mon, 2 Feb 2009 10:04:48 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46643] Inserted rows and cells do not notify already existing cells of events X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: blocker X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: ASSIGNED X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Status In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Mon, 2 Feb 2009 10:04:48 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46643 Robert Pate <millerrobert@example.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |ASSIGNED --- Comment #5 from Robert Pate <millerrobert@example.com> 2009-02-02 10:04:47 PST --- I have attempted the re-calculation solution but with no avail. If you open the output file generated, you will see the issue. If you change any of the valus from D3 to D23 the sukm formula in D25 will not update but if you change the values in D2 or D24, the sum will update correctly. The file was generated while using the reevaluate solution. If I generate the same output but replace the sum formula with a daisy chain of pluses (D2+D3+D4+D5 ..... +D23+D24), the formula works correctly every time, but if I have more then 308 lines to sum, the formula grows too big. Please help. -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Mon Feb 02 19:39:52 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 34950 invoked from network); 2 Feb 2009 19:39:51 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Feb 2009 19:39:51 -0000 Received: (qmail 11592 invoked by uid 500); 2 Feb 2009 19:39:51 -0000 Delivered-To: millerrobert@example.com Received: (qmail 11567 invoked by uid 500); 2 Feb 2009 19:39:51 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 11550 invoked by uid 99); 2 Feb 2009 19:39:51 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Feb 2009 11:39:51 -0800 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, 02 Feb 2009 19:39:50 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 61D76234C4AA; Mon, 2 Feb 2009 11:39:30 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46647] New: COUNTIF function evaluates "<>" operator incorrectly X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: critical X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: NEW X-Bugzilla-Priority: P4 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Date: Mon, 2 Feb 2009 11:39:30 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46647 Summary: COUNTIF function evaluates "<>" operator incorrectly Product: POI Version: 3.2-FINAL Platform: PC OS/Version: Windows XP Status: NEW Severity: critical Priority: P4 Component: HSSF AssignedTo: millerrobert@example.com ReportedBy: millerrobert@example.com Should have "case NE: return cmpResult != 0;" on line 131: http://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/hssf/record/formula/functions/Countif.java?annotate=734243 There are also problems with string to number conversion, for example: '<>123' should always match string values, even '123' (the only thing it doesn't match is 123). '>5' should never match any string value, even '6' No string-to-number conversion is ever required for operators besides '=' and '' (no operator, very similar to '=') -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Mon Feb 02 20:19:26 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 44049 invoked from network); 2 Feb 2009 20:19:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Feb 2009 20:19:26 -0000 Received: (qmail 59909 invoked by uid 500); 2 Feb 2009 20:19:25 -0000 Delivered-To: millerrobert@example.com Received: (qmail 59878 invoked by uid 500); 2 Feb 2009 20:19:25 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 59867 invoked by uid 99); 2 Feb 2009 20:19:25 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Feb 2009 12:19:25 -0800 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, 02 Feb 2009 20:19:23 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 91A51234C4AA; Mon, 2 Feb 2009 12:19:02 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46647] COUNTIF function evaluates "<>" operator incorrectly X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: critical X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: RESOLVED X-Bugzilla-Priority: P4 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: URL Status Resolution In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Mon, 2 Feb 2009 12:19:02 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=3D46647 Josh Micich <millerrobert@example.com> changed: What |Removed |Added ---------------------------------------------------------------------------- URL| |http://mail- | |archives.apache.org/mod_mb= ox | |/poi- | |user/200902.mbox/%3CBLU142- | |W251C33C5EB0BED090300479CC= 50 | |@phx.gbl%3E Status|NEW |RESOLVED Resolution| |FIXED --- Comment #1 from Josh Micich <millerrobert@example.com> 2009-02-02 12:19:02 = PST --- Fixed in svn 740088 Junits added. This bug was initiated due to the post 'About the evaluation of "countif"' = from Miki Haruki (=E4=B8=89=E6=9C=A8 =E6=98=A5=E6=A8=B9) on poi-user. Thanks for the detailed problem description. --=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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Mon Feb 02 22:55:11 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 16668 invoked from network); 2 Feb 2009 22:55:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Feb 2009 22:55:11 -0000 Received: (qmail 95924 invoked by uid 500); 2 Feb 2009 22:55:04 -0000 Delivered-To: millerrobert@example.com Received: (qmail 95907 invoked by uid 500); 2 Feb 2009 22:55:04 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 95883 invoked by uid 99); 2 Feb 2009 22:55:04 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Feb 2009 14:55:04 -0800 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, 02 Feb 2009 22:55:03 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 3C9CE234C48D; Mon, 2 Feb 2009 14:54:43 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46643] Formula parser should encode explicit range operator with tMemFunc X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: blocker X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: ASSIGNED X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Summary In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Mon, 2 Feb 2009 14:54:43 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46643 Josh Micich <millerrobert@example.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Inserted rows and cells do |Formula parser should encode |not notify already existing |explicit range operator with |cells of events |tMemFunc --- Comment #6 from Josh Micich <millerrobert@example.com> 2009-02-02 14:54:42 PST --- There is definitely something funky going on in attachment (id=23211) . When you open it in Excel it has the behaviour you describe (updating cells within the range does not cause the formula to be automatically updated). Another observation is that re-entering the formula (F2, <enter>) in Excel fixes the problem. This is almost always a sign that POI has incorrectly encoded the formula tokens. BiffViewer shows the formula from the attachment (id=23211) as: Ptg[0]=org.apache.poi.hssf.record.formula.Ref3DPtg [sheetIx=0 ! D2]R Ptg[1]=org.apache.poi.hssf.record.formula.Ref3DPtg [sheetIx=0 ! D24]R Ptg[2]=class org.apache.poi.hssf.record.formula.RangePtg. Ptg[3]=org.apache.poi.hssf.record.formula.FuncVarPtg [SUM nArgs=1]V After re-enterring the formula and saving with Excel this becomes: Ptg[0]=org.apache.poi.hssf.record.formula.MemFuncPtg [len=15]R Ptg[1]=org.apache.poi.hssf.record.formula.Ref3DPtg [sheetIx=0 ! D2]R Ptg[2]=org.apache.poi.hssf.record.formula.Ref3DPtg [sheetIx=0 ! D6]R Ptg[3]=class org.apache.poi.hssf.record.formula.RangePtg. Ptg[4]=org.apache.poi.hssf.record.formula.AttrPtg [sum ]. I have done a quick test and found that the critical difference is the presence of the token tMemFunc. If POI is modified to encode this token, Excel opens the file OK and the symptoms are gone. I have changed the summary to reflect this. -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Mon Feb 02 22:57:23 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 17416 invoked from network); 2 Feb 2009 22:57:23 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Feb 2009 22:57:23 -0000 Received: (qmail 98432 invoked by uid 500); 2 Feb 2009 22:57:22 -0000 Delivered-To: millerrobert@example.com Received: (qmail 98408 invoked by uid 500); 2 Feb 2009 22:57:22 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 98397 invoked by uid 99); 2 Feb 2009 22:57:22 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Feb 2009 14:57:22 -0800 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, 02 Feb 2009 22:57:20 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id BAF6A234C4AF; Mon, 2 Feb 2009 14:56:59 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46643] Formula parser should encode explicit range operator with tMemFunc X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: blocker X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: ASSIGNED X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Mon, 2 Feb 2009 14:56:59 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46643 --- Comment #7 from Josh Micich <millerrobert@example.com> 2009-02-02 14:56:59 PST --- Initially had I thought that the different encoding of SUM (as tfuncVar(SUM) instead of tAttrSum) was causing the problem, but this did not prove to be the case. Nonetheless, it turns out to be a small change that we should probably do in order to make POI's formula encoding more closely match that of Excel. -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Mon Feb 02 23:07:27 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 23260 invoked from network); 2 Feb 2009 23:07:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Feb 2009 23:07:26 -0000 Received: (qmail 7805 invoked by uid 500); 2 Feb 2009 23:07:26 -0000 Delivered-To: millerrobert@example.com Received: (qmail 7779 invoked by uid 500); 2 Feb 2009 23:07:26 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 7767 invoked by uid 99); 2 Feb 2009 23:07:26 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Feb 2009 15:07:26 -0800 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, 02 Feb 2009 23:07:23 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 767E5234C48D; Mon, 2 Feb 2009 15:07:02 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46643] Formula parser should encode explicit range operator with tMemFunc X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: blocker X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: ASSIGNED X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Mon, 2 Feb 2009 15:07:02 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46643 --- Comment #8 from Josh Micich <millerrobert@example.com> 2009-02-02 15:07:01 PST --- Another important detail about these tokens is that the range is encoded as two 3D cell refs with an explicit range operator. From the instructions you provided, Step 2 is expected to produce token tArea(D2:D3). The obvious way to get the encoding (tRef3D(D2),tRef3D(D3),tRange) is to instead call: cell.setCellFormula("SUM(InventoryDetails!D2:InventoryDetails!D3)"); I am assuming that this is much closer to the code you actually executed. It's possible that there is some *other* bug in POI that caused the formula originally set as "SUM(D2:D3)" to transform into "SUM(InventoryDetails!D2:InventoryDetails!D3", but this doesn't seem likely to me. If you *did* call setCellFormula("SUM(D2:D3)") while creating the attachment, that would represent another bug. If so please can you open another bugzilla with exact details of the code that will produce that error. For example: cell.setCellFormula("SUM(D2:D3)"); // do specific things to cause bug ... shift rows ? // Check that the formula hasn't changed: System.out.println(cell.getCellFormula()); // anything but "SUM(D2:D3)" would indicate a bug -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Mon Feb 02 23:16:49 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 27960 invoked from network); 2 Feb 2009 23:16:49 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Feb 2009 23:16:49 -0000 Received: (qmail 25368 invoked by uid 500); 2 Feb 2009 23:16:49 -0000 Delivered-To: millerrobert@example.com Received: (qmail 25199 invoked by uid 500); 2 Feb 2009 23:16:48 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 25188 invoked by uid 99); 2 Feb 2009 23:16:48 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Feb 2009 15:16:48 -0800 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, 02 Feb 2009 23:16:46 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 8CF57234C48D; Mon, 2 Feb 2009 15:16:25 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46643] Formula parser should encode explicit range operator with tMemFunc X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: blocker X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: RESOLVED X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Status Resolution In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Mon, 2 Feb 2009 15:16:25 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46643 Josh Micich <millerrobert@example.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |FIXED --- Comment #9 from Josh Micich <millerrobert@example.com> 2009-02-02 15:16:25 PST --- Fixed in svn r740146 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=740146 ) Junit 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Mon Feb 02 23:23:38 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 33620 invoked from network); 2 Feb 2009 23:23:38 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Feb 2009 23:23:38 -0000 Received: (qmail 31880 invoked by uid 500); 2 Feb 2009 23:23:37 -0000 Delivered-To: millerrobert@example.com Received: (qmail 31638 invoked by uid 500); 2 Feb 2009 23:23:37 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 31621 invoked by uid 99); 2 Feb 2009 23:23:37 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Feb 2009 15:23:36 -0800 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, 02 Feb 2009 23:23:35 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 32CEF234C4AF; Mon, 2 Feb 2009 15:23:15 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46643] Formula parser should encode explicit range operator with tMemFunc X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: blocker X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: RESOLVED X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Mon, 2 Feb 2009 15:23:15 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46643 --- Comment #10 from Robert Pate <millerrobert@example.com> 2009-02-02 15:23:14 PST --- I used the formula reference: cell.setCellFormula("SUM(InventoryDetails!D2:InventoryDetails!D3)"); I am new to POI and need to fix this in a production environment on the 3.2.FINAL release. Could you show me how to do this or ppoint me in the right direct (classes to look at, etc)? Thank you so much for you help. -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Tue Feb 03 00:27:18 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 63930 invoked from network); 3 Feb 2009 00:27:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Feb 2009 00:27:18 -0000 Received: (qmail 90756 invoked by uid 500); 3 Feb 2009 00:27:17 -0000 Delivered-To: millerrobert@example.com Received: (qmail 90726 invoked by uid 500); 3 Feb 2009 00:27:17 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 90715 invoked by uid 99); 3 Feb 2009 00:27:17 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Feb 2009 16:27:17 -0800 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, 03 Feb 2009 00:27:16 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id AEFFC234C48D; Mon, 2 Feb 2009 16:26:56 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46643] Formula parser should encode explicit range operator with tMemFunc X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: blocker X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: RESOLVED X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Mon, 2 Feb 2009 16:26:56 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46643 --- Comment #11 from Josh Micich <millerrobert@example.com> 2009-02-02 16:26:55 PST --- (In reply to comment #10) > I used the formula reference: > cell.setCellFormula("SUM(InventoryDetails!D2:InventoryDetails!D3)"); Cool. So the other, hypothetical bug doesn't exist :) > I am new to POI and need to fix this in a production environment on the > 3.2.FINAL release. Could you show me how to do this or ppoint me in the right > direct (classes to look at, etc)? You have three main choices: (1) Work Around If it's easy enough for you to change that line of code to cell.setCellFormula("SUM(D2:D3)"); then you can use POI 3.2-FINAL as-is, since the problem only occurs with the explicit range operator (which is more or less ':' with a complex RHS) (2) Wait for the next POI release Next: 'nightly build' tomorrow, 'betawithin a week or so, or 'final' in perhaps a month. (3) Patch your local 3.2 The fix was quite small (details below), but I am not 100% sure if all of the other stuff needed to make this work are present in version 3.2. For example I think bug 44675 is important (it *is* present in 3.1-beta2). There could be other important fixes things that I am not remembering. The critical change was on line 347 of this file: http://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/formula/FormulaParser.java?annotate=729028&pathrev=740146 Delete one line and add three: - return new ParseNode(RangePtg.instance, children); + ParseNode result = new ParseNode(RangePtg.instance, children); + MemFuncPtg memFuncPtg = new MemFuncPtg(result.getEncodedSize()); + return new ParseNode(memFuncPtg, result); Of course in 3.2 the line number is different (326): http://svn.apache.org/viewvc/poi/tags/REL_3_2_FINAL/src/java/org/apache/poi/ss/formula/FormulaParser.java?annotate=703641 http://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/formula/FormulaParser.java?r1=740146&r2=740145&pathrev=740146 -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Tue Feb 03 00:27:58 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 64078 invoked from network); 3 Feb 2009 00:27:58 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Feb 2009 00:27:58 -0000 Received: (qmail 91085 invoked by uid 500); 3 Feb 2009 00:27:57 -0000 Delivered-To: millerrobert@example.com Received: (qmail 91066 invoked by uid 500); 3 Feb 2009 00:27:57 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 91055 invoked by uid 99); 3 Feb 2009 00:27:57 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Feb 2009 16:27:57 -0800 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, 03 Feb 2009 00:27:55 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 90AA0234C48D; Mon, 2 Feb 2009 16:27:34 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46643] Formula parser should encode explicit range operator with tMemFunc X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: blocker X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: RESOLVED X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Mon, 2 Feb 2009 16:27:34 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46643 --- Comment #12 from Josh Micich <millerrobert@example.com> 2009-02-02 16:27:34 PST --- (In reply to comment #7) Also made POI follow Excel's special case for the encoding of SUM taking a single argument. This was done for consistency; it is not critical for fixing any known bug. Fixed in svn r740159 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=740159 ) -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Tue Feb 03 03:35:32 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 48854 invoked from network); 3 Feb 2009 03:35:32 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Feb 2009 03:35:32 -0000 Received: (qmail 40695 invoked by uid 500); 3 Feb 2009 03:35:31 -0000 Delivered-To: millerrobert@example.com Received: (qmail 40668 invoked by uid 500); 3 Feb 2009 03:35:31 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 40657 invoked by uid 99); 3 Feb 2009 03:35:31 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Feb 2009 19:35:31 -0800 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, 03 Feb 2009 03:35:31 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id B50A2234C4AA; Mon, 2 Feb 2009 19:35:10 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46654] New: "Unable to read file" after "shiftRows" X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: major X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Date: Mon, 2 Feb 2009 19:35:10 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46654 Summary: "Unable to read file" after "shiftRows" Product: POI Version: 3.5-dev Platform: PC OS/Version: Windows XP Status: NEW Severity: major Priority: P2 Component: HSSF AssignedTo: millerrobert@example.com ReportedBy: millerrobert@example.com Created an attachment (id=23215) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23215) Testing file I use following codes to open an Excel file, then call "sheet.shiftRows", but the output file cannot be opened by MS Excel. It prompted "Unable to read file." error message. -- HSSFWorkbook wb = new HSSFWorkbook(ExcelUtil.fixInputStream(new FileInputStream("unable_to_read_file.xls"))); HSSFSheet sheet = wb.getSheet("Other"); sheet.shiftRows(12, 165, 12, false, true); wb.write(new FileOutputStream("unable_to_read_file.output.xls")); -- Please use the attached file for testing, thanks a lot! -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Wed Feb 04 08:19:01 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 64660 invoked from network); 4 Feb 2009 08:18:59 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Feb 2009 08:18:59 -0000 Received: (qmail 28793 invoked by uid 500); 4 Feb 2009 08:18:59 -0000 Delivered-To: millerrobert@example.com Received: (qmail 28559 invoked by uid 500); 4 Feb 2009 08:18:59 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 28548 invoked by uid 99); 4 Feb 2009 08:18:58 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Feb 2009 00:18:58 -0800 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, 04 Feb 2009 08:18:58 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id ACD47234C48C; Wed, 4 Feb 2009 00:18:37 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46660] New: How to unhide a hidden Workbook? X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Date: Wed, 4 Feb 2009 00:18:37 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46660 Summary: How to unhide a hidden Workbook? Product: POI Version: 3.5-dev Platform: PC OS/Version: Windows XP Status: NEW Severity: normal Priority: P2 Component: HSSF AssignedTo: millerrobert@example.com ReportedBy: millerrobert@example.com Created an attachment (id=23223) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23223) sample hidden workbook I have an Excel file (please check the attachment) which is hidden when opening by MS Excel. Is it possible to make it unhide by POI? Thanks a lot! -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Wed Feb 04 10:24:30 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 42530 invoked from network); 4 Feb 2009 10:24:29 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Feb 2009 10:24:29 -0000 Received: (qmail 89491 invoked by uid 500); 4 Feb 2009 10:24:29 -0000 Delivered-To: millerrobert@example.com Received: (qmail 89463 invoked by uid 500); 4 Feb 2009 10:24:29 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 89452 invoked by uid 99); 4 Feb 2009 10:24:29 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Feb 2009 02:24:29 -0800 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, 04 Feb 2009 10:24:27 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 411E8234C48C; Wed, 4 Feb 2009 02:24:05 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46662] New: Writing a workbook twice throws XmlValueDisconnectedException X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: XSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Date: Wed, 4 Feb 2009 02:24:06 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46662 Summary: Writing a workbook twice throws XmlValueDisconnectedException Product: POI Version: 3.5-dev Platform: PC OS/Version: Windows Server 2003 Status: NEW Severity: normal Priority: P2 Component: XSSF AssignedTo: millerrobert@example.com ReportedBy: millerrobert@example.com Created an attachment (id=23224) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23224) Repro file for the issue Read a xlsx file. Write the same workbook to two different file. Closing FileOutputStream after second write throws XmlValueDisconnectedException. millerrobert@example.com.check_orphaned(XmlObjectBase.java:1213) at org.apache.xmlbeans.impl.values.XmlObjectBase.newCursor(XmlObjectBase.java:243) at org.apache.xmlbeans.impl.values.XmlComplexContentImpl.arraySetterHelper(XmlComplexConten tImpl.java:1073) at org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTFontsImpl.setFontArray(Unknow n Source) at org.apache.poi.xssf.model.StylesTable.writeTo(StylesTable.java:323) at org.apache.poi.xssf.model.StylesTable.commit(StylesTable.java:381) at org.apache.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:171) at org.apache.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:173) at org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:199) at com.mytest.xssftest.crxlsfile(xssftest.java:39) at com.mytest.xssftest.main(xssftest.java:24) Tested from latest svn trunk. -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Wed Feb 04 10:25:51 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 43885 invoked from network); 4 Feb 2009 10:25:51 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Feb 2009 10:25:51 -0000 Received: (qmail 91738 invoked by uid 500); 4 Feb 2009 10:25:50 -0000 Delivered-To: millerrobert@example.com Received: (qmail 91717 invoked by uid 500); 4 Feb 2009 10:25:50 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 91705 invoked by uid 99); 4 Feb 2009 10:25:50 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Feb 2009 02:25:50 -0800 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, 04 Feb 2009 10:25:49 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 9AB80234C48C; Wed, 4 Feb 2009 02:25:29 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46662] Writing a workbook twice throws XmlValueDisconnectedException X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: XSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Wed, 4 Feb 2009 02:25:29 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46662 --- Comment #1 from Vinu Kumar <millerrobert@example.com> 2009-02-04 02:25:29 PST --- Created an attachment (id=23225) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23225) xlsx file used for testing -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Wed Feb 04 10:44:23 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 50545 invoked from network); 4 Feb 2009 10:44:23 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Feb 2009 10:44:23 -0000 Received: (qmail 39813 invoked by uid 500); 4 Feb 2009 10:44:22 -0000 Delivered-To: millerrobert@example.com Received: (qmail 39788 invoked by uid 500); 4 Feb 2009 10:44:22 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 39777 invoked by uid 99); 4 Feb 2009 10:44:22 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Feb 2009 02:44:22 -0800 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, 04 Feb 2009 10:44:20 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 75202234C498; Wed, 4 Feb 2009 02:43:59 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46663] New: Calling shiftRows on a xlsx file corrupts the workbook X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: XSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Date: Wed, 4 Feb 2009 02:43:59 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46663 Summary: Calling shiftRows on a xlsx file corrupts the workbook Product: POI Version: 3.5-dev Platform: PC OS/Version: Windows Server 2003 Status: NEW Severity: normal Priority: P2 Component: XSSF AssignedTo: millerrobert@example.com ReportedBy: millerrobert@example.com Created an attachment (id=23226) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23226) Repro file for the issue Read an xlsx file and call shiftRows. Write the resultant workbook to a file and open in MS office 2007. Office throws the following error "Excel found unreadable content." and asks for recovering. Following recovery message is thrown: Removed Records: Cell information from /xl/worksheets/sheet1.xml part The row gets shifted but it shifts the first column and last column is lost. -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Wed Feb 04 10:44:51 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 50710 invoked from network); 4 Feb 2009 10:44:51 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Feb 2009 10:44:51 -0000 Received: (qmail 40863 invoked by uid 500); 4 Feb 2009 10:44:50 -0000 Delivered-To: millerrobert@example.com Received: (qmail 40831 invoked by uid 500); 4 Feb 2009 10:44:50 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 40820 invoked by uid 99); 4 Feb 2009 10:44:50 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Feb 2009 02:44:50 -0800 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, 04 Feb 2009 10:44:49 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 5A042234C498; Wed, 4 Feb 2009 02:44:29 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46663] Calling shiftRows on a xlsx file corrupts the workbook X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: XSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Wed, 4 Feb 2009 02:44:29 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46663 --- Comment #1 from Vinu Kumar <millerrobert@example.com> 2009-02-04 02:44:29 PST --- Created an attachment (id=23227) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23227) xlsx file used for testing -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Wed Feb 04 15:27:04 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 9309 invoked from network); 4 Feb 2009 15:27:04 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Feb 2009 15:27:04 -0000 Received: (qmail 63002 invoked by uid 500); 4 Feb 2009 15:27:03 -0000 Delivered-To: millerrobert@example.com Received: (qmail 62809 invoked by uid 500); 4 Feb 2009 15:27:02 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 62743 invoked by uid 99); 4 Feb 2009 15:27:02 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Feb 2009 07:27:02 -0800 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, 04 Feb 2009 15:27:01 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id E60FE234C48D; Wed, 4 Feb 2009 07:26:39 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46664] New: Print Area does not save in HSSF worksheets X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HDF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Date: Wed, 4 Feb 2009 07:26:39 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46664 Summary: Print Area does not save in HSSF worksheets Product: POI Version: 3.5-dev Platform: PC OS/Version: Linux Status: NEW Severity: normal Priority: P2 Component: HDF AssignedTo: millerrobert@example.com ReportedBy: millerrobert@example.com Created an attachment (id=23228) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23228) example code I can set a print area and read it back just fine, but it does not get saved when the document is written to disk. I have example code and files (both input and output.) -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Wed Feb 04 15:27:56 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 9846 invoked from network); 4 Feb 2009 15:27:53 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Feb 2009 15:27:53 -0000 Received: (qmail 64815 invoked by uid 500); 4 Feb 2009 15:27:53 -0000 Delivered-To: millerrobert@example.com Received: (qmail 64574 invoked by uid 500); 4 Feb 2009 15:27:52 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 64562 invoked by uid 99); 4 Feb 2009 15:27:52 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Feb 2009 07:27:52 -0800 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, 04 Feb 2009 15:27:51 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id A50CF234C48D; Wed, 4 Feb 2009 07:27:31 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46664] Print Area does not save in HSSF worksheets X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HDF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Wed, 4 Feb 2009 07:27:31 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46664 --- Comment #1 from millerrobert@example.com 2009-02-04 07:27:31 PST --- Created an attachment (id=23229) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23229) example input -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Wed Feb 04 15:28:15 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 10038 invoked from network); 4 Feb 2009 15:28:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Feb 2009 15:28:15 -0000 Received: (qmail 65129 invoked by uid 500); 4 Feb 2009 15:28:15 -0000 Delivered-To: millerrobert@example.com Received: (qmail 64892 invoked by uid 500); 4 Feb 2009 15:28:14 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 64881 invoked by uid 99); 4 Feb 2009 15:28:14 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Feb 2009 07:28:14 -0800 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, 04 Feb 2009 15:28:13 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id 0EF7F234C495; Wed, 4 Feb 2009 07:27:51 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46664] Print Area does not save in HSSF worksheets X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HDF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: millerrobert@example.com X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: millerrobert@example.com X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: In-Reply-To: <millerrobert@example.com/bugzilla/> References: <millerrobert@example.com/bugzilla/> Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Message-Id: <millerrobert@example.com> Date: Wed, 4 Feb 2009 07:27:51 -0800 (PST) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=46664 --- Comment #2 from millerrobert@example.com 2009-02-04 07:27:51 PST --- Created an attachment (id=23230) --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23230) example output -- 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: millerrobert@example.com For additional commands, e-mail: millerrobert@example.com From millerrobert@example.com Thu Feb 05 06:06:43 2009 Return-Path: <millerrobert@example.com> Delivered-To: millerrobert@example.com Received: (qmail 41484 invoked from network); 5 Feb 2009 06:06:43 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Feb 2009 06:06:43 -0000 Received: (qmail 62696 invoked by uid 500); 5 Feb 2009 06:06:42 -0000 Delivered-To: millerrobert@example.com Received: (qmail 62673 invoked by uid 500); 5 Feb 2009 06:06:42 -0000 Mailing-List: contact millerrobert@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:millerrobert@example.com> List-Unsubscribe: <mailto:millerrobert@example.com> List-Post: <mailto:millerrobert@example.com> List-Id: <dev.poi.apache.org> Reply-To: "POI Developers List" <millerrobert@example.com> Delivered-To: mailing list millerrobert@example.com Received: (qmail 62662 invoked by uid 99); 5 Feb 2009 06:06:42 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Feb 2009 22:06:42 -0800 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; Thu, 05 Feb 2009 06:06:41 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id A0690234C495; Wed, 4 Feb 2009 22:06:21 -0800 (PST) From: millerrobert@example.com To: millerrobert@example.com Subject: DO NOT REPLY [Bug 46663] Calling shiftRows on a xlsx file corrupts the workbook X-Bugzilla-Reason: AssignedTo
{'source': 'Apache Software Foundation Public Mail Archives'}