Tags: frpfan/PhpSpreadsheet
Tags
## 2024-08-07 - 2.2.2 ### Added - Nothing yet. ### Changed - Nothing yet. ### Deprecated - Nothing yet. ### Moved - Nothing yet. ### Fixed - Html Reader Preserve Unicode Whitespace. [Issue PHPOffice#1284](PHPOffice#1284) [PR PHPOffice#4106](PHPOffice#4106) - RATE Function Floating Point Number of Periods. [PR PHPOffice#4107](PHPOffice#4107) - Parameter Name Change Xlsx Writer Workbook. [Issue PHPOffice#4108](PHPOffice#4108) [PR PHPOffice#4111](PHPOffice#4111) - New Algorithm for TRUNC, ROUNDUP, ROUNDDOWN. [Issue PHPOffice#4113](PHPOffice#4113) [PR PHPOffice#4115](PHPOffice#4115) - Worksheet applyStylesFromArray Retain Active Cell (Excel 16 was having a problem with some files). [Issue PHPOffice#4128](PHPOffice#4128) [PR PHPOffice#4132](PHPOffice#4132)
2.2.1 ### Security Fix - Prevent XXE when loading files [PR PHPOffice#4119](PHPOffice#4119) ### Fixed - Add Sheet may leave Active Sheet uninitialized. [Issue PHPOffice#4112](PHPOffice#4112) [PR PHPOffice#4114](PHPOffice#4114) - Reference to Defined Name Specifying Worksheet. [Issue PHPOffice#206](PHPOffice#296) [PR PHPOffice#4096](PHPOffice#4096) - Xls Reader Print/Show Gridlines. [Issue PHPOffice#912](PHPOffice#912) [PR PHPOffice#4098](PHPOffice#4098) - ODS Reader Allow Omission of Page Settings Tags. [Issue PHPOffice#4099](PHPOffice#4099) [PR PHPOffice#4101](PHPOffice#4101)
Merge pull request PHPOffice#4109 from oleibman/changelog220 Changelog Prep for 2.2.0
2.1.0 ### MINOR BREAKING CHANGE - Writing of cell comments to Html will now sanitize all Html tags within the comment, so the tags will be rendered as plaintext and have no other effects when rendered. Styling can be achieved by using the Font property of of the TextRuns which make up the comment, as is already the cases for Xlsx. [PR PHPOffice#3957](PHPOffice#3957) ### Added - Default Style Alignment Property (workaround for bug in non-Excel spreadsheet apps) [Issue PHPOffice#3918](PHPOffice#3918) [PR PHPOffice#3924](PHPOffice#3924) - Additional Support for Date/Time Styles [PR PHPOffice#3939](PHPOffice#3939) ### Changed - Nothing ### Deprecated - Reader/Xml trySimpleXMLLoadString should not have had public visibility, and will be removed. ### Removed - Nothing ### Fixed - IF Empty Arguments. [Issue PHPOffice#3875](PHPOffice#3875) [Issue PHPOffice#2146](PHPOffice#2146) [PR PHPOffice#3879](PHPOffice#3879) - Changes to floating point in Php8.4. [Issue PHPOffice#3896](PHPOffice#3896) [PR PHPOffice#3897](PHPOffice#3897) - Handling User-supplied Decimal and Thousands Separators. [Issue PHPOffice#3900](PHPOffice#3900) [PR PHPOffice#3903](PHPOffice#3903) - Improve Performance of CSV Writer. [Issue PHPOffice#3904](PHPOffice#3904) [PR PHPOffice#3906](PHPOffice#3906) - Fix issue with prepending zero in percentage [Issue PHPOffice#3920](PHPOffice#3920) [PR PHPOffice#3921](PHPOffice#3921) - Incorrect SUMPRODUCT Calculation [Issue PHPOffice#3909](PHPOffice#3909) [PR PHPOffice#3916](PHPOffice#3916) - Formula Misidentifying Text as Cell After Insertion/Deletion [Issue PHPOffice#3907](PHPOffice#3907) [PR PHPOffice#3915](PHPOffice#3915) - Unexpected Absolute Address in Xlsx Rels [Issue PHPOffice#3730](PHPOffice#3730) [PR PHPOffice#3923](PHPOffice#3923) - Unallocated Cells Affected by Column/Row Insert/Delete [Issue PHPOffice#3933](PHPOffice#3933) [PR PHPOffice#3940](PHPOffice#3940) - Invalid Builtin Defined Name in Xls Reader [Issue PHPOffice#3935](PHPOffice#3935) [PR PHPOffice#3942](PHPOffice#3942) - Hidden Rows and Columns Tcpdf/Mpdf [PR PHPOffice#3945](PHPOffice#3945) - RTL Text Alignment in Xlsx Comments [Issue PHPOffice#4004](PHPOffice#4004) [PR PHPOffice#4006](PHPOffice#4006) - Protect Sheet But Allow Sort [Issue PHPOffice#3951](PHPOffice#3951) [PR PHPOffice#3956](PHPOffice#3956) - Default Value for Conditional::$text [PR PHPOffice#3946](PHPOffice#3946) - Table Filter Buttons [Issue PHPOffice#3988](PHPOffice#3988) [PR PHPOffice#3992](PHPOffice#3992) - Improvements to Xml Reader [Issue PHPOffice#3999](PHPOffice#3999) [Issue PHPOffice#4000](PHPOffice#4000) [Issue PHPOffice#4001](PHPOffice#4001) [Issue PHPOffice#4002](PHPOffice#4002) [PR PHPOffice#4003](PHPOffice#4003) [PR PHPOffice#4007](PHPOffice#4007) - Html Reader non-UTF8 [Issue PHPOffice#3995](PHPOffice#3995) [Issue PHPOffice#866](PHPOffice#866) [Issue PHPOffice#1681](PHPOffice#1681) [PR PHPOffice#4019](PHPOffice#4019)
2.0.0 ### 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 PHPOffice#3718](PHPOffice#3718) - All deprecated things have been removed, for details, see [816b91d](PHPOffice@816b91d) ### Added - Split screens (Xlsx and Xml only, not 100% complete). [Issue PHPOffice#3601](PHPOffice#3601) [PR PHPOffice#3622](PHPOffice#3622) - Permit Meta Viewport in Html. [Issue PHPOffice#3565](PHPOffice#3565) [PR PHPOffice#3623](PHPOffice#3623) - Hyperlink support for Ods. [Issue PHPOffice#3660](PHPOffice#3660) [PR PHPOffice#3669](PHPOffice#3669) - ListWorksheetInfo/Names for Html/Csv/Slk. [Issue PHPOffice#3706](PHPOffice#3706) [PR PHPOffice#3709](PHPOffice#3709) - Methods to determine if cell is actually locked, or hidden on formula bar. [PR PHPOffice#3722](PHPOffice#3722) - Add iterateOnlyExistingCells to Constructors. [Issue PHPOffice#3721](PHPOffice#3721) [PR PHPOffice#3727](PHPOffice#3727) - Support for Conditional Formatting Color Scale. [PR PHPOffice#3738](PHPOffice#3738) - Support Additional Tags in Helper/Html. [Issue PHPOffice#3751](PHPOffice#3751) [PR PHPOffice#3752](PHPOffice#3752) - Writer ODS : Write Border Style for cells [Issue PHPOffice#3690](PHPOffice#3690) [PR PHPOffice#3693](PHPOffice#3693) - Sheet Background Images [Issue PHPOffice#1649](PHPOffice#1649) [PR PHPOffice#3795](PHPOffice#3795) - Check if Coordinate is Inside Range [PR PHPOffice#3779](PHPOffice#3779) - Flipping Images [Issue PHPOffice#731](PHPOffice#731) [PR PHPOffice#3801](PHPOffice#3801) - Chart Dynamic Title and Font Properties [Issue PHPOffice#3797](PHPOffice#3797) [PR PHPOffice#3800](PHPOffice#3800) - Chart Axis Display Units and Logarithmic Scale. [Issue PHPOffice#3833](PHPOffice#3833) [PR PHPOffice#3836](PHPOffice#3836) - Partial Support of Fill Handles. [Discussion PHPOffice#3847](PHPOffice#3847) [PR PHPOffice#3855](PHPOffice#3855) ### Changed - **Drop support for PHP 7.4**, according to https://phpspreadsheet.readthedocs.io/en/latest/#php-version-support [PR PHPOffice#3713](PHPOffice#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 PHPOffice#3571](PHPOffice#3571) [PR PHPOffice#3640](PHPOffice#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 PHPOffice#3304](PHPOffice#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 PHPOffice#3577](PHPOffice#3577) - Html Writer will attempt to use Chart coordinates to determine image size. [Issue PHPOffice#3783](PHPOffice#3783) [PR PHPOffice#3787](PHPOffice#3787) ### Deprecated - Functions `_translateFormulaToLocale` and `_translateFormulaEnglish` are replaced by versions without leading underscore. [PR PHPOffice#3828](PHPOffice#3828) ### Removed - Nothing ### Fixed - Take advantage of mitoteam/jpgraph Extended mode to enable rendering of more graphs. [PR PHPOffice#3603](PHPOffice#3603) - Column widths, especially for ODS. [Issue PHPOffice#3609](PHPOffice#3609) [PR PHPOffice#3610](PHPOffice#3610) - Avoid NULL in String Function call (partial solution). [Issue PHPOffice#3613](PHPOffice#3613) [PR PHPOffice#3617](PHPOffice#3617) - Preserve transparency in Memory Drawing. [Issue PHPOffice#3624](PHPOffice#3624) [PR PHPOffice#3627](PHPOffice#3627) - Customizable padding for Exact Column Width. [Issue PHPOffice#3626](PHPOffice#3626) [PR PHPOffice#3628](PHPOffice#3628) - Ensure ROW function returns int (problem exposed in unreleased Php). [PR PHPOffice#3641](PHPOffice#3641) - Minor changes to Mpdf and Html Writers. [PR PHPOffice#3645](PHPOffice#3645) - Xlsx Reader Namespacing for Tables, Autofilters. [Issue PHPOffice#3665](PHPOffice#3665) [PR PHPOffice#3668](PHPOffice#3668) - Read Code Page for Xls ListWorksheetInfo/Names BIFF5. [Issue PHPOffice#3671](PHPOffice#3671) [PR PHPOffice#3672](PHPOffice#3672) - Read Data from Table on Different Sheet. [Issue PHPOffice#3635](PHPOffice#3635) [PR PHPOffice#3659](PHPOffice#3659) - Html Writer Styles Using Inline Css. [Issue PHPOffice#3678](PHPOffice#3678) [PR PHPOffice#3680](PHPOffice#3680) - Xlsx Read Ignoring Some Comments. [Issue PHPOffice#3654](PHPOffice#3654) [PR PHPOffice#3655](PHPOffice#3655) - Fractional Seconds in Date/Time Values. [PR PHPOffice#3677](PHPOffice#3677) - SetCalculatedValue Avoid Casting String to Numeric. [Issue PHPOffice#3658](PHPOffice#3658) [PR PHPOffice#3685](PHPOffice#3685) - Several Problems in a Very Complicated Spreadsheet. [Issue PHPOffice#3679](PHPOffice#3679) [PR PHPOffice#3681](PHPOffice#3681) - Inconsistent String Handling for Sum Functions. [Issue PHPOffice#3652](PHPOffice#3652) [PR PHPOffice#3653](PHPOffice#3653) - Recomputation of Relative Addresses in Defined Names. [Issue PHPOffice#3661](PHPOffice#3661) [PR PHPOffice#3673](PHPOffice#3673) - Writer Xls Characters Outside BMP (emojis). [Issue PHPOffice#642](PHPOffice#642) [PR PHPOffice#3696](PHPOffice#3696) - Xlsx Reader Improve Handling of Row and Column Styles. [Issue PHPOffice#3533](PHPOffice#3533) [Issue PHPOffice#3534](PHPOffice#3534) [PR PHPOffice#3688](PHPOffice#3688) - Avoid Allocating RowDimension Unneccesarily. [PR PHPOffice#3686](PHPOffice#3686) - Use Column Style when Row Dimension Exists Without Style. [Issue PHPOffice#3534](PHPOffice#3534) [PR PHPOffice#3688](PHPOffice#3688) - Inconsistency Between Cell Data and Explicitly Declared Type. [Issue PHPOffice#3711](PHPOffice#3711) [PR PHPOffice#3715](PHPOffice#3715) - Unexpected Namespacing in rels File. [Issue PHPOffice#3720](PHPOffice#3720) [PR PHPOffice#3722](PHPOffice#3722) - Break Some Circular References. [PR PHPOffice#3716](PHPOffice#3716) [PR PHPOffice#3707](PHPOffice#3707) - Missing Font Index in Some Xls. [PR PHPOffice#3734](PHPOffice#3734) - Load Tables even with READ_DATA_ONLY. [PR PHPOffice#3726](PHPOffice#3726) - Theme File Missing but Referenced in Spreadsheet. [Issue PHPOffice#3770](PHPOffice#3770) [PR PHPOffice#3772](PHPOffice#3772) - Slk Shared Formulas. [Issue PHPOffice#2267](PHPOffice#2267) [PR PHPOffice#3776](PHPOffice#3776) - Html omitting some charts. [Issue PHPOffice#3767](PHPOffice#3767) [PR PHPOffice#3771](PHPOffice#3771) - Case Insensitive Comparison for Sheet Names [PR PHPOffice#3791](PHPOffice#3791) - Performance improvement for Xlsx Reader. [Issue PHPOffice#3683](PHPOffice#3683) [PR PHPOffice#3810](PHPOffice#3810) - Prevent loop in Shared/File. [Issue PHPOffice#3807](PHPOffice#3807) [PR PHPOffice#3809](PHPOffice#3809) - Consistent handling of decimal/thousands separators between StringHelper and Php setlocale. [Issue PHPOffice#3811](PHPOffice#3811) [PR PHPOffice#3815](PHPOffice#3815) - Clone worksheet with tables or charts. [Issue PHPOffice#3820](PHPOffice#3820) [PR PHPOffice#3821](PHPOffice#3821) - COUNTIFS Does Not Require xlfn. [Issue PHPOffice#3819](PHPOffice#3819) [PR PHPOffice#3827](PHPOffice#3827) - Strip `xlfn.` and `xlws.` from Formula Translations. [Issue PHPOffice#3819](PHPOffice#3819) [PR PHPOffice#3828](PHPOffice#3828) - Recurse directories searching for font file. [Issue PHPOffice#2809](PHPOffice#2809) [PR PHPOffice#3830](PHPOffice#3830) - Reduce memory consumption of Worksheet::rangeToArray() when many empty rows are read. [Issue PHPOffice#3814](PHPOffice#3814) [PR PHPOffice#3834](PHPOffice#3834) - Reduce time used by Worksheet::rangeToArray() when many empty rows are read. [PR PHPOffice#3839](PHPOffice#3839) - Html Reader Tolerate Invalid Sheet Title. [PR PHPOffice#3845](PHPOffice#3845) - Do not include unparsed drawings when new drawing added. [Issue PHPOffice#3843](PHPOffice#3843) [PR PHPOffice#3846](PHPOffice#3846) - Do not include unparsed drawings when new drawing added. [Issue PHPOffice#3861](PHPOffice#3861) [PR PHPOffice#3862](PHPOffice#3862) - Excel omits `between` operator for data validation. [Issue PHPOffice#3863](PHPOffice#3863) [PR PHPOffice#3865](PHPOffice#3865) - Use less space when inserting rows and columns. [Issue PHPOffice#3687](PHPOffice#3687) [PR PHPOffice#3856](PHPOffice#3856) - Excel inconsistent handling of MIN/MAX/MINA/MAXA. [Issue PHPOffice#3866](PHPOffice#3866) [PR PHPOffice#3868](PHPOffice#3868)
1.29.0 - 2023-06-15 - Wizards for defining Number Format masks for Dates and Times, including Durations/Intervals. [PR PHPOffice#3458](PHPOffice#3458) - Specify data type in html tags. [Issue PHPOffice#3444](PHPOffice#3444) [PR PHPOffice#3445](PHPOffice#3445) - Provide option to ignore hidden rows/columns in `toArray()` methods. [PR PHPOffice#3494](PHPOffice#3494) - Font/Effects/Theme support for Chart Data Labels and Axis. [PR PHPOffice#3476](PHPOffice#3476) - Font Themes support. [PR PHPOffice#3486](PHPOffice#3486) - Ability to Ignore Cell Errors in Excel. [Issue PHPOffice#1141](PHPOffice#1141) [PR PHPOffice#3508](PHPOffice#3508) - Unzipped Gnumeric file [PR PHPOffice#3591](PHPOffice#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 PHPOffice#3476](PHPOffice#3476) - Memory and speed optimisations for Read Filters with Xlsx Files and Shared Formulae. [PR PHPOffice#3474](PHPOffice#3474) - Allow `CellRange` and `CellAddress` objects for the `range` argument in the `rangeToArray()` method. [PR PHPOffice#3494](PHPOffice#3494) - Stock charts will now read and reproduce `upDownBars` and subsidiary tags; these were previously ignored on read and hard-coded on write. [PR PHPOffice#3515](PHPOffice#3515) - Nothing - Nothing - Updates Cell formula absolute ranges/references, and Defined Name absolute ranges/references when inserting/deleting rows/columns. [Issue PHPOffice#3368](PHPOffice#3368) [PR PHPOffice#3402](PHPOffice#3402) - EOMONTH() and EDATE() Functions should round date value before evaluation. [Issue PHPOffice#3436](PHPOffice#3436) [PR PHPOffice#3437](PHPOffice#3437) - NETWORKDAYS function erroneously being converted to NETWORK_xlfn.DAYS in Xlsx Writer. [Issue PHPOffice#3461](PHPOffice#3461) [PR PHPOffice#3463](PHPOffice#3463) - Getting a style for a CellAddress instance fails if the worksheet is set in the CellAddress instance. [Issue PHPOffice#3439](PHPOffice#3439) [PR PHPOffice#3469](PHPOffice#3469) - Shared Formulae outside the filter range when reading with a filter are not always being identified. [Issue PHPOffice#3473](PHPOffice#3473) [PR PHPOffice#3474](PHPOffice#3474) - Xls Reader Conditional Styles. [PR PHPOffice#3400](PHPOffice#3400) - Allow use of # and 0 digit placeholders in fraction masks. [PR PHPOffice#3401](PHPOffice#3401) - Modify Date/Time check in the NumberFormatter for decimal/fractional times. [PR PHPOffice#3413](PHPOffice#3413) - Misplaced Xml Writing Chart Label FillColor. [Issue PHPOffice#3397](PHPOffice#3397) [PR PHPOffice#3404](PHPOffice#3404) - TEXT function ignores Time in DateTimeStamp. [Issue PHPOffice#3409](PHPOffice#3409) [PR PHPOffice#3411](PHPOffice#3411) - Xlsx Column Autosize Approximate for CJK. [Issue PHPOffice#3405](PHPOffice#3405) [PR PHPOffice#3416](PHPOffice#3416) - Correct Xlsx Parsing of quotePrefix="0". [Issue PHPOffice#3435](PHPOffice#3435) [PR PHPOffice#3438](PHPOffice#3438) - More Display Options for Chart Axis and Legend. [Issue PHPOffice#3414](PHPOffice#3414) [PR PHPOffice#3434](PHPOffice#3434) - Apply strict type checking to Complex suffix. [PR PHPOffice#3452](PHPOffice#3452) - Incorrect Font Color Read Xlsx Rich Text Indexed Color Custom Palette. [Issue PHPOffice#3464](PHPOffice#3464) [PR PHPOffice#3465](PHPOffice#3465) - Xlsx Writer Honor Alignment in Default Font. [Issue PHPOffice#3443](PHPOffice#3443) [PR PHPOffice#3459](PHPOffice#3459) - Support Border for Charts. [PR PHPOffice#3462](PHPOffice#3462) - Error in "this row" structured reference calculation (cached result from first row when using a range) [Issue PHPOffice#3504](PHPOffice#3504) [PR PHPOffice#3505](PHPOffice#3505) - Allow colour palette index references in Number Format masks [Issue PHPOffice#3511](PHPOffice#3511) [PR PHPOffice#3512](PHPOffice#3512) - Xlsx Reader formula with quotePrefix [Issue PHPOffice#3495](PHPOffice#3495) [PR PHPOffice#3497](PHPOffice#3497) - Handle REF error as part of range [Issue PHPOffice#3453](PHPOffice#3453) [PR PHPOffice#3467](PHPOffice#3467) - Handle Absolute Pathnames in Rels File [Issue PHPOffice#3553](PHPOffice#3553) [PR PHPOffice#3554](PHPOffice#3554) - Return Page Breaks in Order [Issue PHPOffice#3552](PHPOffice#3552) [PR PHPOffice#3555](PHPOffice#3555) - Add position attribute for MemoryDrawing in Html [Issue PHPOffice#3529](PHPOffice#3529 [PR PHPOffice#3535](PHPOffice#3535) - Allow Index_number as Array for VLOOKUP/HLOOKUP [Issue PHPOffice#3561](PHPOffice#3561 [PR PHPOffice#3570](PHPOffice#3570) - Add Unsupported Options in Xml Spreadsheet [Issue PHPOffice#3566](PHPOffice#3566 [Issue PHPOffice#3568](PHPOffice#3568 [Issue PHPOffice#3569](PHPOffice#3569 [PR PHPOffice#3567](PHPOffice#3567) - Changes to NUMBERVALUE, VALUE, DATEVALUE, TIMEVALUE [Issue PHPOffice#3574](PHPOffice#3574 [PR PHPOffice#3575](PHPOffice#3575) - Redo calculation of color tinting [Issue PHPOffice#3550](PHPOffice#3550) [PR PHPOffice#3580](PHPOffice#3580) - Accommodate Slash with preg_quote [PR PHPOffice#3582](PHPOffice#3582) [PR PHPOffice#3583](PHPOffice#3583) [PR PHPOffice#3584](PHPOffice#3584) - HyperlinkBase Property and Html Handling of Properties [Issue PHPOffice#3573](PHPOffice#3573) [PR PHPOffice#3589](PHPOffice#3589) - Improvements for Data Validation [Issue PHPOffice#3592](PHPOffice#3592) [Issue PHPOffice#3594](PHPOffice#3594) [PR PHPOffice#3605](PHPOffice#3605)
1.28.0 - 2023-02-25 - Support for configuring a Chart Title's overlay [PR PHPOffice#3325](PHPOffice#3325) - Wizards for defining Number Format masks for Numbers, Percentages, Scientific, Currency and Accounting [PR PHPOffice#3334](PHPOffice#3334) - Support for fixed value divisor in fractional Number Format Masks [PR PHPOffice#3339](PHPOffice#3339) - Allow More Fonts/Fontnames for Exact Width Calculation [PR PHPOffice#3326](PHPOffice#3326) [Issue PHPOffice#3190](PHPOffice#3190) - Allow override of the Value Binder when setting a Cell value [PR PHPOffice#3361](PHPOffice#3361) - Improved handling for @ placeholder in Number Format Masks [PR PHPOffice#3344](PHPOffice#3344) - Improved handling for ? placeholder in Number Format Masks [PR PHPOffice#3394](PHPOffice#3394) - Improved support for locale settings and currency codes when matching formatted strings to numerics in the Calculation Engine [PR PHPOffice#3373](PHPOffice#3373) and [PR PHPOffice#3374](PHPOffice#3374) - Improved support for locale settings and matching in the Advanced Value Binder [PR PHPOffice#3376](PHPOffice#3376) - Rationalisation of Pre-defined Currency Format Masks - Nothing - Calculation Engine doesn't evaluate Defined Name when default cell A1 is quote-prefixed [Issue PHPOffice#3335](PHPOffice#3335) [PR PHPOffice#3336](PHPOffice#3336) - XLSX Writer - Array Formulas do not include function prefix [Issue PHPOffice#3337](PHPOffice#3337) [PR PHPOffice#3338](PHPOffice#3338) - Permit Max Column for Row Breaks [Issue PHPOffice#3143](PHPOffice#3143) [PR PHPOffice#3345](PHPOffice#3345) - AutoSize Columns should allow for dropdown icon when AutoFilter is for a Table [Issue PHPOffice#3356](PHPOffice#3356) [PR PHPOffice#3358](PHPOffice#3358) and for Center Alignment of Headers [Issue PHPOffice#3395](PHPOffice#3395) [PR PHPOffice#3399](PHPOffice#3399) - Decimal Precision for Scientific Number Format Mask [Issue PHPOffice#3381](PHPOffice#3381) [PR PHPOffice#3382](PHPOffice#3382) - Xls Writer Parser Handle Boolean Literals as Function Arguments [Issue PHPOffice#3369](PHPOffice#3369) [PR PHPOffice#3391](PHPOffice#3391) - Conditional Formatting Improvements for Xlsx [Issue PHPOffice#3370](PHPOffice#3370) [Issue PHPOffice#3202](PHPOffice#3302) [PR PHPOffice#3372](PHPOffice#3372) - Coerce Bool to Int for Mathematical Operations on Arrays [Issue PHPOffice#3389](PHPOffice#3389) [Issue PHPOffice#3396](PHPOffice#3396) [PR PHPOffice#3392](PHPOffice#3392)
1.27.0 - 2023-01-24 - Option to specify a range of columns/rows for the Row/Column `isEmpty()` methods [PR PHPOffice#3315](PHPOffice#3315) - Option for Cell Iterator to return a null value or create and return a new cell when accessing a cell that doesn't exist [PR PHPOffice#3314](PHPOffice#3314) - Support for Structured References in the Calculation Engine [PR PHPOffice#3261](PHPOffice#3261) - Limited Support for Form Controls [PR PHPOffice#3130](PHPOffice#3130) [Issue PHPOffice#2396](PHPOffice#2396) [Issue PHPOffice#1770](PHPOffice#1770) [Issue PHPOffice#2388](PHPOffice#2388) [Issue PHPOffice#2904](PHPOffice#2904) [Issue PHPOffice#2661](PHPOffice#2661) - Nothing - Nothing - Shared/JAMA is removed. [PR PHPOffice#3260](PHPOffice#3260) - Namespace-Aware Code for SheetViewOptions, SheetProtection [PR PHPOffice#3230](PHPOffice#3230) - Additional Method for XIRR if Newton-Raphson Doesn't Converge [Issue PHPOffice#689](PHPOffice#689) [PR PHPOffice#3262](PHPOffice#3262) - Better Handling of Composite Charts [Issue PHPOffice#2333](PHPOffice#2333) [PR PHPOffice#3265](PHPOffice#3265) - Update Column Reference for Columns Beginning with Y and Z [Issue PHPOffice#3263](PHPOffice#3263) [PR PHPOffice#3264](PHPOffice#3264) - Honor Fit to 1-Page Height Html/Pdf [Issue PHPOffice#3266](PHPOffice#3266) [PR PHPOffice#3279](PHPOffice#3279) - AND/OR/XOR Handling of Literal Strings [PR PHPOffice#3287](PHPOffice#3287) - Xls Reader Vertical Break and Writer Page Order [Issue PHPOffice#3305](PHPOffice#3305) [PR PHPOffice#3306](PHPOffice#3306)
PreviousNext