PhpSpreadsheet Versions Save

A pure PHP library for reading and writing spreadsheet files

2.0.0

3 months ago

BREAKING CHANGE

  • Typing was strengthened by leveraging native typing. This should not change any behavior. However, if you implement any interfaces or inherit from any classes, you will need to adapt your typing accordingly. If you use static analysis tools such as PHPStan or Psalm, new errors might be found. If you find actual bugs because of the new typing, please open a PR that fixes it with a detailed explanation of the reason. We'll try to merge and release typing-related fixes quickly in the coming days. PR #3718
  • All deprecated things have been removed, for details, see 816b91d0b4

Added

Changed

  • Drop support for PHP 7.4, according to https://phpspreadsheet.readthedocs.io/en/latest/#php-version-support PR #3713
  • RLM Added to NumberFormatter Currency. This happens depending on release of ICU which Php is using (it does not yet happen with any official release). PhpSpreadsheet will continue to use the value returned by Php, but a method is added to keep the result unchanged from release to release. Issue #3571 PR #3640
  • toFormattedString will now always return a string. This was introduced with 1.28.0, but was not properly documented at the time. This can affect the results of toArray, namedRangeToArray, and rangeToArray. PR #3304
  • Value of constants FORMAT_CURRENCY_EUR and FORMAT_CURRENCY_USD was changed in 1.28.0, but was not properly documented at the time. Issue #3577
  • Html Writer will attempt to use Chart coordinates to determine image size. Issue #3783 PR #3787

Deprecated

  • Functions _translateFormulaToLocale and _translateFormulaEnglish are replaced by versions without leading underscore. PR #3828

Removed

  • Nothing

Fixed

1.29.0

10 months ago

Added

  • Wizards for defining Number Format masks for Dates and Times, including Durations/Intervals. PR #3458
  • Specify data type in html tags. Issue #3444 PR #3445
  • Provide option to ignore hidden rows/columns in toArray() methods. PR #3494
  • Font/Effects/Theme support for Chart Data Labels and Axis. PR #3476
  • Font Themes support. PR #3486
  • Ability to Ignore Cell Errors in Excel. Issue #1141 PR #3508
  • Unzipped Gnumeric file PR #3591

Changed

  • Xlsx Color schemes read in will be written out (previously Excel 2007-2010 Color scheme was always written); manipulation of those schemes before write, including restoring prior behavior, is provided PR #3476
  • Memory and speed optimisations for Read Filters with Xlsx Files and Shared Formulae. PR #3474
  • Allow CellRange and CellAddress objects for the range argument in the rangeToArray() method. PR #3494
  • Stock charts will now read and reproduce upDownBars and subsidiary tags; these were previously ignored on read and hard-coded on write. PR #3515

Deprecated

  • Nothing

Removed

  • Nothing

Fixed

1.28.0

1 year ago

1.28.0 - 2023-02-25

Added

  • Support for configuring a Chart Title's overlay PR #3325
  • Wizards for defining Number Format masks for Numbers, Percentages, Scientific, Currency and Accounting PR #3334
  • Support for fixed value divisor in fractional Number Format Masks PR #3339
  • Allow More Fonts/Fontnames for Exact Width Calculation PR #3326 Issue #3190
  • Allow override of the Value Binder when setting a Cell value PR #3361

Changed

  • Improved handling for @ placeholder in Number Format Masks PR #3344
  • Improved handling for ? placeholder in Number Format Masks PR #3394
  • Improved support for locale settings and currency codes when matching formatted strings to numerics in the Calculation Engine PR #3373 and PR #3374
  • Improved support for locale settings and matching in the Advanced Value Binder PR #3376

Deprecated

  • Rationalisation of Pre-defined Currency Format Masks

Removed

  • Nothing

Fixed

1.27.1

1 year ago

Added

  • Nothing

Changed

  • Nothing

Deprecated

  • Nothing

Removed

  • Nothing

Fixed

  • Fix Composer --dev dependency issue with dealerdirect/phpcodesniffer-composer-installer renaming their master branch to main

1.27.0

1 year ago

Added

Changed

  • Nothing

Deprecated

  • Nothing

Removed

Fixed

1.26.0

1 year ago

1.26.0 - 2022-12-21

Added

  • Extended flag options for the Reader load() and Writer save() methods
  • Apply Row/Column limits (1048576 and XFD) in ReferenceHelper PR #3213
  • Allow the creation of In-Memory Drawings from a string of binary image data, or from a stream. PR #3157
  • Xlsx Reader support for Tables PR #2829
  • Permit Date/Time Entered on Spreadsheet to be calculated as Float Issue #1416 PR #3121

Changed

  • Nothing

Deprecated

  • Direct update of Calculation::suppressFormulaErrors is replaced with setter.
  • Font public static variable defaultColumnWidths replaced with constant DEFAULT_COLUMN_WIDTHS.
  • ExcelError public static variable errorCodes replaced with constant ERROR_CODES.
  • NumberFormat constant FORMAT_DATE_YYYYMMDD2 replaced with existing identical FORMAT_DATE_YYYYMMDD.

Removed

  • Nothing

Fixed

1.25.2

1 year ago

Added

  • Nothing

Changed

  • Nothing

Deprecated

  • Nothing

Removed

  • Nothing

Fixed

  • Composer dependency clash with ezyang/htmlpurifier

1.25.1

1 year ago

1.25.0

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

1.24.1

1 year ago

Added

Changed

  • Nothing

Deprecated

  • Nothing

Removed

  • Nothing

Fixed