poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 49027] New: Excel French date format not preserved
Date Wed, 31 Mar 2010 03:02:15 GMT

           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: dev@poi.apache.org
        ReportedBy: atombuilder@gmail.com

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message