To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=102810
User rainerbielefeld changed the following:
What |Old value |New value
================================================================================
Keywords|C4 |needhelp, needmoreinfo, oo
| |oqa
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Thu Jul 1
05:14:53 +0000 2010 -------
Still not reproducible in all details, but may be I found some first indicatons
that there might be a problem and the column number type selector does not work
well.
I tried with "Ooo-Dev 3.3 multilingual version English UI WIN XP: [DEV300m83
(Build 9511)]" with language settings "English UK", document language setting
"German":
0. Menu 'File - Open - Type "csv"' - <open>
1. Text import dialog:
Chacacter set "Iso-8859-15 - German - From Row 1 - Separated by nothing -
Text delimiter=', All "other options" selected
Column marked, Column Type "MDY" selected
<okY
Document will be imported
2. Select column B
Format "D MMMM YYYY"
Select 'B3', Inser formula "=A3" <enter>
Result: "2 January 2000"
expected: "1 February 2000" due to "MDY"
3. Select column B
Format "D MMMM YYYY"
Select 'B359', Inser formula "=A359" <enter>
expected: "1 February 2000" due to "MDY"
actual: 23 December 2000
expected: Text "23/12/00", because "23/12/00" is not a valid "MDY" date.
May be that there is some unexpected Column type selection override, that causes
cruzandre's problems?
Some more results:
Import with "DMY" seems to work corrrectly, "01/13/2000" 2ill be imported as
Text as expected.
Some other modifications (character set) of the settings in import dialog seem
to be without influence
@all:
Any explications for the strange "MDY" behaviour?
@cruzandre:
Please:
- Contribute the imported .csv as "dates1.ods" without any further modifications
- A step by step instruction containing every mouse click and every key press
- Information concerning all settings in "Options" and Import dialog that might
be relevant
- do not touch IZ status fields if you do not know exactly for what they are
---------------------------------------------------------------------
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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
