Issue 96190 - Calc uses different period for ACCRINT than Excel
Summary: Calc uses different period for ACCRINT than Excel
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 3.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: ms_interoperability
Depends on:
Blocks:
 
Reported: 2008-11-13 16:19 UTC by andreschnabel
Modified: 2017-05-20 11:33 UTC (History)
1 user (show)

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

Attachments
testcase (7.00 KB, application/vnd.ms-excel)
2008-11-13 16:23 UTC, andreschnabel 		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 andreschnabel 2008-11-13 16:19:50 UTC 
Calc and Excel use different calculation of the period that is used for ACCRINT.
Seems as periods that start / end within a leap year are calculated differently.

If a period starts in a leap year (but after 02-29) Calc will use a year with
366 days, while excel seems to use 365 days. See attached example.

This should be checked against the ODF formula spec.
Comment 1 andreschnabel 2008-11-13 16:23:56 UTC 
Created attachment 57975 [details]
testcase
Comment 2 Marcus 2017-05-20 11:33:45 UTC 
Reset assigne to the default "issues@openoffice.apache.org".