Issue 96190

Summary: Calc uses different period for ACCRINT than Excel
Product: Calc Reporter: andreschnabel <andre.schnabel>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 3.0Keywords: ms_interoperability
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
testcase none

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".