Issue 49467 - function datedif() is missing
Summary: function datedif() is missing
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 1.1.4
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 123905 (view as issue list)
Depends on:
Blocks:
 
Reported: 2005-05-18 18:19 UTC by richpainter
Modified: 2024-02-06 13:33 UTC (History)
9 users (show)

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

Attachments
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 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
Comment 4 oooforum (fr) 2015-09-25 10:30:35 UTC 
*** Issue 123905 has been marked as a duplicate of this issue. ***
Comment 5 oooforum (fr) 2024-02-06 13:33:43 UTC 
Work in progress
Proposal PR at: https://github.com/apache/openoffice/pull/178