Forum

Hello,

There's no release date for phpxlsx 2.5. The next week phppptx (https://www.phppptx.com/) will be officially announced. After phppptx has been launched the dev team will choose a date to release phpxlsx 2.5 and we'll send a newsletter.

phpxlsx 2.5 will include the following features:

=== What's new on phpxlsx 2.5? ===

- New methods to insert comments: addComment and addCommentAuthor.
- New method to insert defined names: addDefinedName.
- New method to add a macro: addMacroFromXlsx.
- Indexer (Advanced and Premium licenses):
  - Comments.
  - Defined names.
  - Cell positions.
  - Cell formats.
- Enabled fullCalcOnLoad option in the default base template.
- HTML to XLSX supports transforming tables.
- Improvements working with tables:
  - Add title and description properties.
  - Apply content types to contents and totals.
  - addTable returns the position range used.
- New options in setWorkbookSettings: readOnly, fullCalcOnLoad, forceFullCalc.
- New options in addSlide: position, color.
- New setCellValue method to set a cell value keeping existing styles.
- The getCell method returns the style index value.
- Images can be added from files, streams and base64 contents.
- Applied htmlspecialchars to content values when using template methods.
- Improved handle XLSX templates that use uppercase ContentType extensions.
- Added '/' as delimiter in preg_quote when extracting the template variables.
- The static variables $_templateSymbolStart and $_templateSymbolEnd available in the CreateXlsxFromTemplate class have been changed to class attributes.
- Free DOMDocument resources when using Indexer (Advanced and Premium licenses).
- The overwrite option has been renamed to replace in all methods.
- Sign class avoid generating partial signed files in the latest revisions of MS Office (Premium licenses).

Regards.