To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=109495
User regina changed the following:
What |Old value |New value
================================================================================
CC|'' |'regina'
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Priority|P2 |P3
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Sun Feb 21 18:39:49
+0000 2010 -------
That is the intended new behavior for converting strings.
See i5658 desc215 for details.
You have to correct your spreadsheet to unambiguous formulas.
You can avoid any problems with date strings and locals, if you use
=EOMONTH(DATE(2008;10;1);C2-1)
instead of
=EOMONTH("01/10/2008";C2-1)
assuming 1 is the day and 10 is the month.
Only strings containing ISO formats are converted now, to avoid ambiguity. You
can still use
=EOMONTH("2008-10-01";C2-1)
I don't know, whether it is possible to convert date strings to ISO format
automatically, guessing the local from the cell number format language for
example. I tend to set this issue to "WONTFIX", but a developer should comment.
---------------------------------------------------------------------
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]
