Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||function datedif() is missing|
|Component:||programming||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||camilleri.jon, issues, kamataki, pescetti, srt2006, tora3, vulcain, y-catch|
|Issue Type:||FEATURE||Latest Confirmation in:||---|
Description richpainter 2005-05-18 18:19:35 UTC
The function datedif() is missing. This function has been used in Excel since version 5 and is extremely useful. I use Excel spreadsheets that are protected that use datedif() so I need this function to work as is in order to switch over to using OpenOffice. This link http://www.cpearson.com/excel/datedif.htm documents this function as found in Excel. I realize that this complaint was raised over 2 years ago but since it is in common use with Excel OpenOffice should support it because many times there is no way to change the existing spreadsheet to make a work around (this is my situation). Also, if it is so "simple to implement" then just add the needed code to properly implement datedif() in OpenOffice. Otherwise this will be just another reason for people to NOT migrate to OpenOffice.
Comment 1 frank 2005-06-13 11:21:55 UTC
one for the requirements team
Comment 2 Andrea Pescetti 2012-10-02 21:33:56 UTC
As Dennis Hamilton noted on ooo-users http://mail-archives.apache.org/mod_mbox/incubator-ooo-users/201210.mbox/browser , DATEDIF() is part of OpenFormula (part 2 of the ODF 1.2 Specification). So it's already formally specified and standardized. This is an important prerequisite to check before starting the implementation.
Comment 3 vulcain 2013-01-28 09:51:38 UTC
Resolved in LibreOffice 3.6: https://bugs.freedesktop.org/show_bug.cgi?id=44456