Skip Menu |
 
rt.cpan.org will be shut down on March 1st, 2021.

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

Report information
The Basics
Id: 101636
Status: new
Priority: 0/
Queue: Spreadsheet-XLSX

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

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: Decimal format being ignored in Excel file
Date: Tue, 20 Jan 2015 12:59:02 -0800
To: bug-Spreadsheet-XLSX [...] rt.cpan.org
From: smu johnson <smujohnson [...] gmail.com>
Download (untitled) / with headers
text/plain 421b
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 is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

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