PhpSpreadsheet 发布版本:

Added

  • Add excel function EXACT(value1, value2) support - #595
  • Support workbook view attributes for Xlsx format - #523
  • Read and write hyperlink for drawing image - #490
  • Added calculation engine support for the new bitwise functions that were added in MS Excel 2013
    • BITAND() Returns a Bitwise 'And' of two numbers
    • BITOR() Returns a Bitwise 'Or' of two number
    • BITXOR() Returns a Bitwise 'Exclusive Or' of two numbers
    • BITLSHIFT() Returns a number shifted left by a specified number of bits
    • BITRSHIFT() Returns a number shifted right by a specified number of bits
  • Added calculation engine support for other new functions that were added in MS Excel 2013 and MS Excel 2016
    • Text Functions
      • CONCAT() Synonym for CONCATENATE()
      • NUMBERVALUE() Converts text to a number, in a locale-independent way
      • UNICHAR() Synonym for CHAR() in PHPSpreadsheet, which has always used UTF-8 internally
      • UNIORD() Synonym for ORD() in PHPSpreadsheet, which has always used UTF-8 internally
      • TEXTJOIN() Joins together two or more text strings, separated by a delimiter
    • Logical Functions
      • XOR() Returns a logical Exclusive Or of all arguments
    • Date/Time Functions
      • ISOWEEKNUM() Returns the ISO 8601 week number of the year for a given date
    • Lookup and Reference Functions
      • FORMULATEXT() Returns a formula as a string
    • Financial Functions
      • PDURATION() Calculates the number of periods required for an investment to reach a specified value
      • RRI() Calculates the interest rate required for an investment to grow to a specified future value
    • Engineering Functions
      • ERF.PRECISE() Returns the error function integrated between 0 and a supplied limit
      • ERFC.PRECISE() Synonym for ERFC
    • Math and Trig Functions
      • SEC() Returns the secant of an angle
      • SECH() Returns the hyperbolic secant of an angle
      • CSC() Returns the cosecant of an angle
      • CSCH() Returns the hyperbolic cosecant of an angle
      • COT() Returns the cotangent of an angle
      • COTH() Returns the hyperbolic cotangent of an angle
      • ACOT() Returns the cotangent of an angle
      • ACOTH() Returns the hyperbolic cotangent of an angle
  • Refactored Complex Engineering Functions to use external complex number library
  • Added calculation engine support for the new complex number functions that were added in MS Excel 2013
    • IMCOSH() Returns the hyperbolic cosine of a complex number
    • IMCOT() Returns the cotangent of a complex number
    • IMCSC() Returns the cosecant of a complex number
    • IMCSCH() Returns the hyperbolic cosecant of a complex number
    • IMSEC() Returns the secant of a complex number
    • IMSECH() Returns the hyperbolic secant of a complex number
    • IMSINH() Returns the hyperbolic sine of a complex number
    • IMTAN() Returns the tangent of a complex number

Fixed

  • Fix ISFORMULA() function to work with a cell reference to another worksheet
  • Xlsx reader crashed when reading a file with workbook protection - #553
  • Cell formats with escaped spaces were causing incorrect date formatting - #557
  • Could not open CSV file containing HTML fragment - #564
  • Exclude the vendor folder in migration - #481
  • Chained operations on cell ranges involving borders operated on last cell only #428
  • Avoid memory exhaustion when cloning worksheet with a drawing #437
  • Migration tool keep variables containing $PHPExcel untouched #598
  • Rowspans/colspans were incorrect when adding worksheet using loadIntoExisting #619