[Issue 125175] reading .csv dates depends on language

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=125175

Kay <ks...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
                 CC|                            |kschenk@apache.org,
                   |                            |TorrAB@Yahoo.com
          Component|formatting                  |open-import
             Latest|---                         |4.1.0
    Confirmation on|                            |
   Target Milestone|---                         |4.1.1
     Ever confirmed|0                           |1

--- Comment #1 from Kay <ks...@apache.org> ---
Using Linux-32, version --
AOO411m1(Build:9770)  -  Rev. 1604099
2014-06-30_07:13:14-Rev.1606633

4.1.1-dev


Confirmed that something very odd is happening here.

When I change the type of field from "standard" to "date" when opening the csv
(on import), everything is fine in either version of English -- US or CA.

When I leave the field definitions unchanged on import, even I try to change
the definition for what we assume is the date column -- Column A -- after
opening, nothing happens. No change in date format.

So why? Then I notice on import with this option, no additional field
specification on import, I see a tick mark (') in the front of the date value
thereby throwing the formatting change off. Once I remove this tick mark form
both dates, everything works as expected.

I am not sure why this mark was inserted. This DEFINITELY needs attention.

Changed component to "open-import" instead of formatting.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.