Re: [users] Calc, "Days" function accepts non-date input, returns non-integer result?

[Terry]

Greetings.

I think, if it works as it should when used as directed, we should be 
thankful for small mercies.

Some functions will accept incorrect or wrongly formatted data.  It 
increases the extent of code writing if you provide for every imbecilic 
possibility.

Regards.

Kirill S. Palagin wrote:
(I am providing example).

In file at http://www.mytempdir.com/1133344 :
Cell A4 contains properly formatted input, and function returns expected
result.
Cell A3 contains date as parameter, but without quotation marks;
function returns garbage.
Cell A2 contains obvious garbage in input, function still accepts that.

What do you think of such behavior?

Thanks.

  
-----Original Message-----
From: Kirill S. Palagin [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 25, 2006 2:34 PM
To: users@openoffice.org
Subject: [users] Calc, "Days" function accepts non-date 
input, returns non-integer result?

Hello.

I just have discovered that "Days" function accepts non-date 
input and returns non-integer result. 
Description from Function Wizard - "Calculates the number of 
days between two days".

Is this normal/usefull or should I file an issue in IssueZilla?

Thanks.
WBR,
K. Palagin.


--

Direct mail to teaman is not opened; if necessary, email realmail
Xfce on PCLinuxOS, OOo 2.0.2 (en_GB) www.revivalcentres.org

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]