This queue is for tickets about the Spreadsheet-XLSX CPAN distribution.

Report information
The Basics
Id:
50236
Status:
open
Priority:
Low/Low

People
Owner:
Nobody in particular
Requestors:
pat.mariani [...] att.net
Cc:
AdminCc:

BugTracker
Severity:
Important
Broken in:
0.11
Fixed in:
(no value)

Attachments
Broadband Intitative Review Input Template (Assign Training).xlsx



Subject: chartsheet fix doesn't account for changed order or deleted sheets
MIME-Version: 1.0
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Charset: utf8
X-RT-Original-Encoding: utf-8
Content-Type: multipart/mixed; boundary="----------=_1254797695-2295-822"
Content-Length: 0
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: binary
Content-Length: 1277
Perl version 5.8.7 xlsx release .11 solaris .xlsx File attached - loop over last worksheet incorrectly. worksheet named by sheetId (8 in this case) is incorrect after deleted sheets - would be correctly named x1/worksheets/sheet4.xml worksheet description mentions 4 sheets... (apply the sample program to dump the workbook will fail on the last sheet, but get the name correct! since it can not find the data) Moving the sheet order in excel and 're-saving' produces varied results. (name no longer matches data) From workbook.xml [code] - <sheets> <sheet name="Project List" sheetId="1" r:id="rId1" /> <sheet name="Service Areas" sheetId="2" r:id="rId2" /> <sheet name="Communities Chosen" sheetId="3" r:id="rId3" /> <sheet name="CBs" sheetId="8" r:id="rId4" /> </sheets> [/code] Added r:id code back in - the computer guy in me doesn't like the elseif without catching the 'else' !! :) [code] if ($k eq 'name') { $sheet -> {Name} = $v; $sheet -> {Name} = $converter -> convert ($sheet -> {Name}) if $converter; } elsif ($k eq 'sheetId') { ($sheet -> {Id}) = $v; } elsif ($k eq 'r:id') { ($sheet -> {Id}) = $v =~ m{rId(\d+)}; }; [/code]
Subject: Broadband Intitative Review Input Template (Assign Training).xlsx
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="----------=_1254797695-2295-821"
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Charset: utf8
Content-Length: 0
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: iso-8859-1
Content-Length: 0
Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; name="Broadband Intitative Review Input Template (Assign Training).xlsx"
Content-Disposition: inline; filename="Broadband Intitative Review Input Template (Assign Training).xlsx"
Content-Transfer-Encoding: base64
Content-Length: 871253

Message body not shown because it is not plain text.

MIME-Version: 1.0
Subject: Patched in version 0.12
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
Charset: utf8
Content-Type: text/plain
Message-ID: <rt-3.6.HEAD-2295-1254819147-673.50236-0-0@rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 86
I included your file in the test suite. It wold be very nice to have a smaller one...
MIME-Version: 1.0
X-Spam-Status: No, hits=1.2 required=8.0 tests=MSGID_MULTIPLE_AT
In-Reply-To: <rt-3.6.HEAD-2295-1254819147-673.50236-6-0@rt.cpan.org>
X-Mailer: Microsoft Office Outlook 12.0
References: <RT-Ticket-50236@rt.cpan.org> <rt-3.6.HEAD-2295-1254819147-673.50236-6-0@rt.cpan.org>
Content-Language: en-us
Message-ID: <007f01ca4679$5901fc90$0b05f5b0$@mariani@att.net>
Content-Type: text/plain; charset="UTF-8"
Organization: Agile Systems, Inc.
X-RT-Original-Encoding: utf-8
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by diesel.bestpractical.com (Postfix) with SMTP id 524294D80F1 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Tue, 6 Oct 2009 07:37:27 -0400 (EDT)
Received: (qmail 18383 invoked by uid 103); 6 Oct 2009 11:37:26 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 6 Oct 2009 11:37:26 -0000
Received: from fmailhost02.isp.att.net (HELO fmailhost02.isp.att.net) (204.127.217.102) by 16.mx.develooper.com (qpsmtpd/0.80) with ESMTP; Tue, 06 Oct 2009 04:37:20 -0700
Received: from patrickhp32bit (c-69-142-97-87.hsd1.nj.comcast.net[69.142.97.87]) by worldnet.att.net (frfwmhc02) with SMTP id <20091006113716H0200s01h5e>; Tue, 6 Oct 2009 11:37:17 +0000
Delivered-To: cpan-bug+Spreadsheet-XLSX@diesel.bestpractical.com
Subject: RE: [rt.cpan.org #50236] Patched in version 0.12
Return-Path: <pat.mariani@att.net>
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: bug-Spreadsheet-XLSX@rt.cpan.org
Thread-Index: AcpGYlWUyWyFp70TRC60jsvY4hxPYgAFvD+A
Date: Tue, 6 Oct 2009 07:37:10 -0400
X-Spam-Level: *
X-Originating-Ip: [69.142.97.87]
To: <bug-Spreadsheet-XLSX@rt.cpan.org>
Content-Transfer-Encoding: 7bit
From: "Patrick Mariani" <pat.mariani@att.net>
RT-Message-ID: <rt-3.6.HEAD-2295-1254829058-1210.50236-0-0@rt.cpan.org>
Content-Length: 431
I will work on one! I'm sure I can come up with something. Pat
Show quoted text
-----Original Message----- From: Dmitry Ovsyanko via RT [mailto:bug-Spreadsheet-XLSX@rt.cpan.org] Sent: Tuesday, October 06, 2009 4:52 AM To: pat.mariani@att.net Subject: [rt.cpan.org #50236] Patched in version 0.12 <URL: https://rt.cpan.org/Ticket/Display.html?id=50236 > I included your file in the test suite. It wold be very nice to have a smaller one...


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.