| 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: | |
| 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.