Issue 96190 - Calc uses different period for ACCRINT than Excel
Summary: Calc uses different period for ACCRINT than Excel
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:
Keywords: ms_interoperability
Depends on:
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: ---

testcase (7.00 KB, application/
2008-11-13 16:23 UTC, andreschnabel
no flags Details

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]
Comment 2 Marcus 2017-05-20 11:33:45 UTC
Reset assigne to the default "".