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