« Changelog History


PhpSpreadsheet v1.25.0 Release Notes

Release Date: 2022-09-25 // over 1 year ago

  • ➕ Added

    • Implementation of the new TEXTBEFORE(), TEXTAFTER() and TEXTSPLIT() Excel Functions
    • Implementation of the ARRAYTOTEXT() and VALUETOTEXT() Excel Functions
    • 👌 Support for mitoteam/jpgraph implementation of JpGraph library to render charts added.
    • Charts: Add Gradients, Transparency, Hidden Axes, Rounded Corners, Trendlines, Date Axes.

    🔄 Changed

    • 👍 Allow variant behaviour when merging cells Issue #3065
      • Merge methods now allow an additional $behaviour argument. Permitted values are:
      • Worksheet::MERGE_CELL_CONTENT_EMPTY - Empty the content of the hidden cells (the default behaviour)
      • Worksheet::MERGE_CELL_CONTENT_HIDE - Keep the content of the hidden cells
      • Worksheet::MERGE_CELL_CONTENT_MERGE - Move the content of the hidden cells into the first cell

    🗄 Deprecated

    • 🗄 Axis getLineProperty deprecated in favor of getLineColorProperty.
    • 🚚 Moved majorGridlines and minorGridlines from Chart to Axis. Setting either in Chart constructor or through Chart methods, or getting either using Chart methods is deprecated.
    • Chart::EXCEL_COLOR_TYPE_* copied from Properties to ChartColor; use in Properties is deprecated.
    • ChartColor::EXCEL_COLOR_TYPE_ARGB deprecated in favor of EXCEL_COLOR_TYPE_RGB ("A" component was never allowed).
    • 💅 Misspelled Properties::LINE_STYLE_DASH_SQUERE_DOT deprecated in favor of LINE_STYLE_DASH_SQUARE_DOT.
    • 👯 Clone not permitted for Spreadsheet. Spreadsheet->copy() can be used instead.

    ✂ Removed

    • Nothing

    🛠 Fixed