changes to patch fdo#44456 added calc function DATEDIF

* use operator && instead of 'and'
* use correct types
* long operator -(Date,Date)
* sal_uInt16 GetDay(), GetMonth(), GetYear()
* check for error after argument pop and bail out if so
* day difference can be pushed and return immediately without further
calculation
* ensure only one value is pushed
* correct calculation of years and months
* only complete years and months are to be returned, same day,month in
different years is a complete year (birthday-like), same day in different
months is a complete month.
* "y" returned 1 for 2012-02-29,2013-02-28 or 2012-03-29,2013-03-28
* must be 0 instead
* "y" returned 0 for 2011-03-28,2013-03-29
* must be 1 instead
* negative values are never returned
* reversed arguments are not allowed
* algorithm for "md" extracted from Excel behavior, see source
* changes to other intervals as well
* changed term Format to Interval in FormulaWizard (and code) for clarity
* mention interval arguments in FormulaWizard
* in sc/source/filter/oox/formulabase.cxx reverted the entry's move from
saFuncTableBiff5 to saFuncTableOdf
* saFuncTableOdf member's are "Functions defined by OpenFormula, but not
supported by Calc or by Excel", this function now is supported by both
* instead, changed FUNCFLAG_IMPORTONLY to 0 in entry of saFuncTableBiff5 and
added FunctionData::mpcOdfFuncName "DATEDIF"
* otherwise with the FUNCFLAG_MACROCALLODF a macro call is generated for
Excel export that Excel doesn't know and can only be imported by LibO
again, and without the BIFF function identifier the function could not be
imported from original binary Excel documents

0 files changed, 0 insertions, 0 deletions