Issue 98012 - function DAYSINMONTH and DATSINYEAR caculate error
Summary: function DAYSINMONTH and DATSINYEAR caculate error
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOO300m9
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks: 84292
  Show dependency tree
 
Reported: 2009-01-13 02:51 UTC by doze_worm
Modified: 2013-01-29 21:43 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Sample file with detailed test results (117.15 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-01-13 06:32 UTC, Rainer Bielefeld 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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