To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=113903
User rainerbielefeld changed the following:
What |Old value |New value
================================================================================
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Keywords|needmoreinfo, oooqa |needhelp, oooqa
--------------------------------------------------------------------------------
Summary|function DAYS() does not |function DAYS() does not
|return correct number. |recognize all localized da
| |tes in date strings
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Thu Aug 19
06:21:20 +0000 2010 -------
I found "Err:502" in G3 with "Ooo 3.1.1 WIN XP DE[OOO310m19 (Build 9420)]".
After modification of date ("30.07.09") result was 29,07%.
"Ooo-Dev 3.3.0 multilingual version English UI WIN XP: [OOo330m1 (Build 9514)]"
showed "#VALUE"
I have some difficulties to understand the problem and cerated a more simple
"mynewexample.ods" that seems to show that there exist problems with recognition
of localized country specific date strings. That indeed worked better in 3.1.1.
So currently I see the effect, but can't really figure out the reason.
For more details please see attached "mynewexample.ods"
By the way:
I believe that HELP is not useful to understand how DAYS() should work.
"DAYS: Calculates the difference between two date values."
That's not correct. Function calculates difference of values if the date numbers
are results of other functions or if numbers are in cells and if the formula
references to those cells.
So syntax is "DAYS(Reference to Date2; Reference to Date1)" or similar
like "DAYS(A1;A2")
If dates are directly integrated into formula, DAYS calculates difference
between values of date strings.
@curson19:
I asked you not to leave comments like "does not work".
---------------------------------------------------------------------
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]
