Issue 114061 - If Date in Functions DAYSINNONTH、DAYSINYEAR、ISLEAPYEAR、WEEKSINYEAR are more than 8, hangs OOo
Summary: If Date in Functions DAYSINNONTH、DAYSINYEAR、ISLEAPYEAR、WEEKSINYEAR are more t...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOO330m4
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-08-23 09:01 UTC by amy2008
Modified: 2013-01-29 21:54 UTC (History)
5 users (show)

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


Attachments
Document shows the limit where Calc hangs. (10.99 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-08-23 13:06 UTC, Regina Henschel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description amy2008 2010-08-23 09:01:48 UTC
Can reproduce it in OOo330m4 on WinXP and Ubuntu.

How to reproduce it
1 Open a new calc file
2 Insert - Function, double-click DAYSINNONTH、DAYSINYEAR、ISLEAPYEAR or 
  WEEKSINYEAR, like "DAYSINYEAR", enter more than 8 numbers in "date" box

Result
OOo hangs

Expectation 
OOo works well
Comment 1 Regina Henschel 2010-08-23 13:04:30 UTC
Same bug in DEV300m86 on WinXP.

Such number is surely invalid and Calc should detect it and return an "invalid
argument"-error.

There seem to be a lot of overflow-errors in handling dates, see attached documents.
Comment 2 Regina Henschel 2010-08-23 13:06:01 UTC
Created attachment 71258 [details]
Document shows the limit where Calc hangs.
Comment 3 Oliver Brinzing 2010-08-23 16:26:14 UTC
.
Comment 4 amy2008 2010-12-06 09:13:49 UTC
Hi regina,
Thank you for your attachment.
Regards
Li Meiying