On 9/29/05, G. Roderick Singleton <[EMAIL PROTECTED]> wrote:
> > DATEVALUE seems to behave better ...
> >
> > Err:502 =DATEVALUE(9/27/2005) <-- Invalid argument
> > 38622 =DATEVALUE("9/27/05")
> >
> > 38591 =EDATE("9/27/05";-1)
> > -30 =EDATE(9/27/2005;-1)
> >
> > 0.5 =YEARFRAC("1.1.2002"; "7.1.2002";1)
> > 0.00 =YEARFRAC(1/1/2002;7/10/2002;1)
> >
> >
> > On 9/28/05, David Chapman <[EMAIL PROTECTED]> wrote:
> > > Paul,
> > >
> > > I agree with your assessment / concerns. I have not checked if there
> > > are similar issues with other date functions.
> > >
> > > Dave
> > >
> > > On 9/28/05, Paul Smith <[EMAIL PROTECTED]> wrote:
> > > > Dear All
> > > >
> > > > If one uses, in Calc, the wrong syntax
> > > >
> > > > WEEKDAY(09/27/2005)
> > > >
> > > > (without the quotes), one gets 7 as result. This may be misleading, as
> > > > one may assume that this result is correct. Therefore, I think that a
> > > > error should be given when the quotes are forgotten. Do you agree with
> > > > this comment?
> > > >
>
>
> Interesting but are you guys aware that these functions are described in
> Help as requiring quotes? I will assume yes and will surmize that the
> problem is the error message. If this is the case, I suggest that you
> enter an Request for Enhancement (RFE) into Issue
> Tracker as this is the best way to have requests such as this evaluated.
>
> If you haven't already registered, do the following:
>
> 1. To file an issue you must register with OOo by clicking the
> My Pages tab and selecting the Register link
> http://www.openoffice.org/servlets/Join
> 2. Fill in your information
> 3. Reply to the confirmation email that will be sent to the address
> you provided.
> 4. Once you have confirmed, go to www.openoffice.org again
> 5. And click on the "My Pages" tab from which you can file and find
> issues.
>
> Thanks for bringing this to our attention. It is important that you file
> any examples with the issue to ensure your need is understood.
>
> Please let us know the issue number so we can vote.
Regarding this topic, I have just filed an issue:
http://www.openoffice.org/issues/show_bug.cgi?id=55311
Paul
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
