1.29.0

• 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

• 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

• Nothing

• Nothing

• 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 PHPOffice#3529](PHPOffice#3529 PR #3535

• Allow Index_number as Array for VLOOKUP/HLOOKUP [Issue PHPOffice#3561](PHPOffice#3561 PR #3570

• Add Unsupported Options in Xml Spreadsheet [Issue PHPOffice#3566](PHPOffice#3566 [Issue PHPOffice#3568](PHPOffice#3568 [Issue PHPOffice#3569](PHPOffice#3569 PR #3567

• Changes to NUMBERVALUE, VALUE, DATEVALUE, TIMEVALUE [Issue PHPOffice#3574](PHPOffice#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