To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=110263
                 Issue #|110263
                 Summary|Wrong data formating in import from .cvs
               Component|Spreadsheet
                 Version|OOO310m11
                Platform|PC
                     URL|
              OS/Version|All
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|open-import
             Assigned to|spreadsheet
             Reported by|gregorystec





------- Additional comments from gregorys...@openoffice.org Fri Mar 19 15:54:50 
+0000 2010 -------
In case when the data field is two digit number ended with dot (XX.) or group up
t three) of two digit number separated with dot (XX.XX.XX.) the standard
conversion for this field is to data format dd.mm.yyyy (system date format). 
For example the number:
"10." is converted to "10.03.2010"
"10.10" is converted to "10.10.2010"
"12.11.15" is converted to "12.11.2015"
The incomplete group of digit is substituted from system date.
If the imported .cvs is very huge and some of column is mixed type text with
numbers, the result is little frustrating.
The system number decimal separator is "." and sytem data format is "dd.mm.yyy",
polish location (pl-PL)

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

Reply via email to