Issue 98012

Summary: function DAYSINMONTH and DATSINYEAR caculate error
Product: Calc Reporter: doze_worm <zhuangyuelin>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: amy2008, issues, peter.junge, rainerbielefeld_ooo_qa
Version: OOO300m9Keywords: oooqa
Target Milestone: ---   
Hardware: Unknown   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 84292    
Description Flags
Sample file with detailed test results none

Description doze_worm 2009-01-13 02:51:54 UTC
1. Create new Calc doc
2. "Insert" -> "Function..."; in "Funciton" bar on the pop-up "Function Wizard"
dialog-box, select "Date&Time" in Category dorp-menu, and double-click
DAYSINMONTH function in Function box.
3. Type a valid date in "Date" text-box, such as "2008-02-12"

Display 30 in "Function result".

The result should be 29.

  <input>   ---  <result>  ---  <expected result>
2000-01-03         30               31
2000-02-15         30               29
2000-02-30         31              error
1900-02-29         28              error
1968-02-28         30               28

And the function DAYSINYEAR has the same problem.
Comment 1 Rainer Bielefeld 2009-01-13 06:30:52 UTC
I checked with "Ooo 3.1 Multilingual version English  UI WIN XP: [DEV300m36
(Build 9369)]" and can confirm the reported effect.

I did not test all details, but it seem that the problem also exists in "Ooo
3.0.0 (DE) Multilingual version German UI WIN XP: [OOO300m9 (Build9358)]" and
"2.4.1  Multilingual version English UI WIN XP: [680m17(Build9310)]"

For further details pls. see attached "samplefile.ods"
Comment 2 Rainer Bielefeld 2009-01-13 06:32:38 UTC
Created attachment 59338 [details]
Sample file with detailed test results