Skip to content

1.25.0 - 2022-09-25

Compare
Choose a tag to compare
@github-actions github-actions released this 25 Sep 11:07

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