https://issues.apache.org/bugzilla/show_bug.cgi?id=49027
Summary: Excel French date format not preserved
Product: POI
Version: unspecified
Platform: PC
OS/Version: Linux
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=25220)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=25220)
the template (see description)
I wrote a program to generate an Excel spreadsheet containing rows of data in
which cells in each column have a particular format. Some columns are french
(canadian) dates.
My program works by copying a template which is the same as the output report
but with only one blank data row. Each row of data in the output spreadsheet is
obtained by cloning the styles in the blank row, and then filling in the data.
This works fine, except when the cell style in the blank row is a French date
(i.e. in Excel, pick the Date format, with language French (Canada)).
The dates always show up in English.
Attached is the template (portfolio_template_FR.xls) with columns FGHI
formatted as French (Canada) dates. I'd like to attach the output report as
well but I am only allowed one attachment below.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
