OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-comment message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: [office-formula] predraft 8 of 2007-12-28, section 6.9.6, function days360 comment


Hello,

I believe that the test case for the function 'days360' is wrong.

The days360 function (as given in the test-case) should result in '159' 
instead of '-162'.

The current implementations of this function in
- excel 2002 (xp)
- excel 2003
- excel 2007
- openoffice.org 2.3.0
- openoffice.org 2.3.1
- kspread 1.6.3
all give '159' as a result.

The given result of '-162' is obtained when one uses the 'days'-function 
instead of the 'days360' function.

-- 
Roel


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]