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

Report information
The Basics
Id:
101636
Status:
new
Priority:
Low/Low

People
Owner:
Nobody in particular
Requestors:
smujohnson [...] gmail.com
Cc:
AdminCc:

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



MIME-Version: 1.0
X-Spam-Status: No, score=0.011 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DNS_FROM_AHBL_RHSBL=2.699, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_LOW=-0.7, T_TO_NO_BRKTS_FREEMAIL=0.01] autolearn=no
X-Spam-Flag: NO
Content-Type: multipart/alternative; boundary="089e014940646f6c73050d1bb5db"
Message-ID: <CAF8w-5wzn49sDuRJSKshwS1D7Y+f3V1Zuesjx1YazBC-ju0cKg@mail.gmail.com>
X-Received: by 10.152.3.100 with SMTP id b4mr39242889lab.68.1421787542807; Tue, 20 Jan 2015 12:59:02 -0800 (PST)
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Spam-Score: 0.011
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 1D313240493 for <cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com>; Tue, 20 Jan 2015 15:59:16 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id tFtyPId6umu4 for <cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com>; Tue, 20 Jan 2015 15:59:11 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 28B0E2402D2 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Tue, 20 Jan 2015 15:59:10 -0500 (EST)
Received: (qmail 29397 invoked by alias); 20 Jan 2015 20:59:10 -0000
Received: from mail-la0-f53.google.com (HELO mail-la0-f53.google.com) (209.85.215.53) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Tue, 20 Jan 2015 12:59:07 -0800
Received: by mail-la0-f53.google.com with SMTP id gq15so12235757lab.12 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Tue, 20 Jan 2015 12:59:02 -0800 (PST)
Received: by 10.25.43.16 with HTTP; Tue, 20 Jan 2015 12:59:02 -0800 (PST)
Authentication-Results: hipster.bestpractical.com (amavisd-new); dkim=pass header.i=@gmail.com
Delivered-To: cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com
Subject: Decimal format being ignored in Excel file
Return-Path: <smujohnson@gmail.com>
X-RT-Mail-Extension: spreadsheet-xlsx
X-Original-To: cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com
X-Spam-Check-BY: la.mx.develooper.com
Dkim-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=cQYQreN50cUr03guuyF3hiwsLMXytpyojxyejDbAjMU=; b=HKN7hnK+ei1cj+26NypOf49AljVJ7BkMf7aJ5mTBX7UfTXcfbwMwElHEDVpNSU/XYh +tfebBH1jogIM/G+/9JStaaihrLb2pUTunCpSRnJa33gONXUjNNVOKpGo5DNhVJPnAem pqk3+qmATLJCbL1vB7AK7hNLuO57h4NMJNThM//rdq95+zThsC4R+cdKV1j9D8oWczoP dGM3r5+RpgCKgcJr8ZV0QJPKAr6jMIFihhnE5oTCxnOGMoJ3l0HZyFcwKgF6CvFQqv0v HHdXeFJX/FSDeZUujG2K1hH5YnnddMr8nhbdxs5H0nmVqS65Y/LPA+YIMpKLAUUCfwQ7 3yvg==
Date: Tue, 20 Jan 2015 12:59:02 -0800
X-Spam-Level:
To: bug-Spreadsheet-XLSX@rt.cpan.org
From: smu johnson <smujohnson@gmail.com>
X-RT-Interface: Email
Content-Length: 0
content-type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
Content-Length: 421
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: utf-8
Content-Length: 671
Hi,

The usual behaviour of the classic Spreadsheet::ParseExcel would take into account that the Excel file had decimal formatting, ie, 2 decimal places, and treat that way, e.g., 14.00, even if "14" was entered into the spreadsheet.

Spreadsheet-XLSX on the other hand just shows the raw value, 14, and ignores the decimal formatting attribute on the cell / column, etc.

Thanks.

--
smu johnson <smujohnson@gmail.com>


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.