Issue 98012

Summary:

function DAYSINMONTH and DATSINYEAR caculate error

Product:

Calc

Reporter:

doze_worm <zhuangyuelin>

Component:

code

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

amy2008, issues, peter.junge, rainerbielefeld_ooo_qa

Version:

OOO300m9

Keywords:

oooqa

Target Milestone:

---

Hardware:

Unknown

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Issue Depends on:

Issue Blocks:

84292

Attachments:

Description	Flags
Sample file with detailed test results	none

Description doze_worm 2009-01-13 02:51:54 UTC

[Steps]
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"

[Result]
Display 30 in "Function result".

[Expectation]
The result should be 29.

[Addition]
  <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