To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=102810
------- Additional comments from cruzan...@openoffice.org Thu Jul 1 18:21:07
+0000 2010 -------
@rainerbielefeld:
Rainerbielefeld, thanks a lot 4 your help. But your test in lines B3 and B359
return the correct values. Remember that you local setting is configured to show
dates in format DD.MM.YY, so the result expected in cell B3 is 2 January 2000
and your test returns it well.
The import module should convert the format MM/DD/YYYY of the .csv file in
internal date/time Calc format. In this case (cell B3 and B359), Calc did it.
Please, check the lines 276 to 306 and tell me if they correspond of October
month. After that, check the lines of the October month of other years and
verify if all dates are as expected.
@all:
Test environment:
OS
Linux – Fedora Core 13
Windows XP Professional – SP3
OO
OOO320m12 (Build: 9483) – English (US)
OOO300m15 (Build: 9379) – English (US)
The problem occur in all of 4 combinations and compilations above.
To reproduce the problem:
0. Main language settings (Screenshot-Options-Language Settings-Languages.png)
Menu Tools, Options, Language settings
Language of session
User Interface: Default - English (USA)
Locale Setting: Portuguese (Brazil)
Decimal Separator Key: (Checked) Same as local setting (,) -
“comma”
Default Currency: BRL R$ Portuguese (Brazil)
Default Language for Documents Session
Western: Portuguese (Brazil)
1. Opening file
Menu File, Open and select dates.csv file
Default options
Character set: Unicode (UTF-8)
From row 1
Separated by comma (checked) and all others options
unchecked
Text delimiter '“' (quotes)
Select single column
Column type: Date (MDY)
(Screenshot-TextImport-[dates.csv].png)
(dates1.ods)
another way
2. Checking the result
Go to line 654
(Screenshot-dates.csv-OpenOffice.orgCalc.png)
The A654 cell has a text, not a date/time content, in format MM/DD/YYYY
In cell B654 put the formula '=A654+1' and the result will be '#VALUE!'
Do the same in cell B655 (=A655+1) and the result will be '16/10/01'
The same problem occur in lines 654, 1389, 2117, 2845, 3216, 3580,
3944, 4308,
4679, 5043, 5407 and 5771.
Another way to test is sort the column A descending. It'll put the text
cells
above the dates cells.
In line of the test suggested by 'rainerbielefeld', I fill the column B
with
the formula =A1, =A2, … , =A5845. The column was format as date (D. MMM. YYYY)
and in line 283, the result is 10. Ago (Aug). 2000 and the expected was 08. Out
(Oct). 2000.
(Screenshot-dates.csv-OpenOffice.orgCalc-2.png)
---------------------------------------------------------------------
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
