To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=85387
User regina changed the following:
What |Old value |New value
================================================================================
CC|'' |'regina'
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Keywords|needmoreinfo, oooqa |oooqa
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Sat Jan 19 21:17:33 +0000
2008 -------
You can solve this input problem and force an unambiguous meaning, if you set
the number language in your format, in your case to en-uk. Or you use ISO
notation 2007-01-04 for your input.
I see an inconsistent behavior of OOo too, and therefore confirm the issue.
Please compare this situations:
(A) Set your local to German(Germany).
- Format a cell to date tt/mm/jjjj, number language default
- Enter 04/01/2007, so the day should be 4.
- You see 04/01/2007 in the cell.
- Use DAY(),MONTH(),YEAR() to determine, what date it is. You will see that it
is (in ISO-notation) 2007-01-04.
- Format a cell to date mm/tt/jjjj, number language default
- Enter 04/01/2007 in the cell, so the day should be 1.
- You see 04/01/2007 in the cell.
- Use DAY(),MONTH(),YEAR() to determine, what date it is. You will see that it
is (in ISO notation) 2007-04-01.
OOo has calculated the order of day and month from the given format of the cell
in both cases.
(B) Set your local to English(USA).
- Format a cell to date dd/mm/yyyy, number language default
- Enter 04/01/2007, so the day should be 4 as in the German case.
- You see 01/04/2007 in the cell.
- Use DAY(),MONTH(),YEAR() to determine, what date it is. You will see that it
is (in ISO-notation) 2007-04-01.
OOo does not calculated the order of day and month from the given format but
from the local.
Proposal: Use always the order of day, month, and year from the given cell
format. Do not silently change order, if number of month not in 1..12, but set
to text format in those cases.
---------------------------------------------------------------------
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]
