To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109892 Issue #|109892 Summary|Wrong example for function EDATE() in help document o |f Calc Component|Spreadsheet Version|current Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|new_ooo3
------- Additional comments from [email protected] Sun Mar 7 10:50:08 +0000 2010 ------- I find a wrong example for function "EDATE" in help description of Calc. ****** [ Help description for function "EDATE" ] ***** EDATE The result is a date which is a number of months away from the start date. Only months are considered; days are not used for calculation. Syntax EDATE(StartDate; Months) StartDate is a date. Months is the number of months before (negative) or after (positive) the start date. Example What date is one month prior to 3.31.2001? =EDATE(3.31.2001;-1) returns 2.28.2001. <--"This line is incorrect." ***************************************************** If I would use "=EDATE(3.31.2001;-1)" in Calc,I get "error509". I think it is necessary to add the double quotes with first parameter. So,I proposal the following; Current(incorrect) : =EDATE(3.31.2001;-1) returns 2.28.2001. Change (correct) : =EDATE("3.31.2001";-1) returns 2.28.2001. My kind member invest above issue, we know the description of the different expressions of OOo3.x and OOo2.x. I am happy you will consider the issue and correct the help discription. --------------------------------------------------------------------- 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]
