PHPOffice/PhpSpreadsheet 1.29.0

on GitHub

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

• Updates Cell formula absolute ranges/references, and Defined Name absolute ranges/references when inserting/deleting rows/columns. Issue #3368 PR #3402
• EOMONTH() and EDATE() Functions should round date value before evaluation. Issue #3436 PR #3437
• NETWORKDAYS function erroneously being converted to NETWORK_xlfn.DAYS in Xlsx Writer. Issue #3461 PR #3463
• Getting a style for a CellAddress instance fails if the worksheet is set in the CellAddress instance. Issue #3439 PR #3469
• Shared Formulae outside the filter range when reading with a filter are not always being identified. Issue #3473 PR #3474
• Xls Reader Conditional Styles. PR #3400
• Allow use of # and 0 digit placeholders in fraction masks. PR #3401
• Modify Date/Time check in the NumberFormatter for decimal/fractional times. PR #3413
• Misplaced Xml Writing Chart Label FillColor. Issue #3397 PR #3404
• TEXT function ignores Time in DateTimeStamp. Issue #3409 PR #3411
• Xlsx Column Autosize Approximate for CJK. Issue #3405 PR #3416
• Correct Xlsx Parsing of quotePrefix="0". Issue #3435 PR #3438
• More Display Options for Chart Axis and Legend. Issue #3414 PR #3434
• Apply strict type checking to Complex suffix. PR #3452
• Incorrect Font Color Read Xlsx Rich Text Indexed Color Custom Palette. Issue #3464 PR #3465
• Xlsx Writer Honor Alignment in Default Font. Issue #3443 PR #3459
• Support Border for Charts. PR #3462
• Error in "this row" structured reference calculation (cached result from first row when using a range) Issue #3504 PR #3505
• Allow colour palette index references in Number Format masks Issue #3511 PR #3512
• Xlsx Reader formula with quotePrefix Issue #3495 PR #3497
• Handle REF error as part of range Issue #3453 PR #3467
• Handle Absolute Pathnames in Rels File Issue #3553 PR #3554
• Return Page Breaks in Order Issue #3552 PR #3555
• Add position attribute for MemoryDrawing in Html [Issue #3529](#3529 PR #3535
• Allow Index_number as Array for VLOOKUP/HLOOKUP [Issue #3561](#3561 PR #3570
• Add Unsupported Options in Xml Spreadsheet [Issue #3566](#3566 [Issue #3568](#3568 [Issue #3569](#3569 PR #3567
• Changes to NUMBERVALUE, VALUE, DATEVALUE, TIMEVALUE [Issue #3574](#3574 PR #3575
• Redo calculation of color tinting Issue #3550 PR #3580
• Accommodate Slash with preg_quote PR #3582 PR #3583 PR #3584
• HyperlinkBase Property and Html Handling of Properties Issue #3573 PR #3589
• Improvements for Data Validation Issue #3592 Issue #3594 PR #3605