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

Report information
The Basics
Id:
101636
Status:
new
Priority:
Low/Low
Queue:
Spreadsheet-XLSX
People
Owner:
Nobody in particular
Requestors:
smujohnson [...] gmail.com
Cc:
AdminCc:
BugTracker
Severity:
(no value)
Broken in:
(no value)
Fixed in:
(no value)

History
Tue Jan 20 15:59:17 2015 smujohnson [...] gmail.com - Ticket created
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>


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.