To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=47757
User wsp changed the following:
What |Old value |New value
================================================================================
Status|CLOSED |UNCONFIRMED
--------------------------------------------------------------------------------
Resolution|INVALID |
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Jun 14 08:48:10 -0700
2005 -------
hi,
>how should Calc know that the date you put into a default formatted cell is of
>
>type ISO 8601 ?! It can't !
a programmer can test:
length of string is 8 or 10 and is convertable to one of the known date formats
(then use it acc. users settings) or he can enjoy the following Calc table:
(Col A formatted as Standard, B as IsoDate C-F as Formula REF to B2|B3)
Original: 05-06-13|14 (Important: All fields as Deutsch(Schweiz)
Standard isoDate DATWERT ISTTEXT ISTZAHL ISTLOG JAHR from
05.06.13 05-06-13 Err:502 FALSCH WAHR FALSCH 2005 sh
05.06.14 05.06.14 Err:502 FALSCH WAHR FALSCH 2014 kate
05.06.14 05.06.14 Err:502 FALSCH WAHR FALSCH 2014 writer
Without logic, but 9 years difference and a unwanted format. Date is NOT stored
as DateValue (a long integer), some used tricks are not working in all cases.
Maybe this issue should be known as 'Please implement (ISO-)Date'?
Wolfgang
---------------------------------------------------------------------
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]
