Changelog History
Page 1
-
v1.25.2 Changes
September 25, 2022โ Added
- Nothing
๐ Changed
- Nothing
๐ Deprecated
- Nothing
โ Removed
- Nothing
๐ Fixed
- Composer dependency clash with ezyang/htmlpurifier
-
v1.25.0 Changes
September 25, 2022โ Added
- Implementation of the new
TEXTBEFORE()
,TEXTAFTER()
andTEXTSPLIT()
Excel Functions - Implementation of the
ARRAYTOTEXT()
andVALUETOTEXT()
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
- Merge methods now allow an additional
๐ 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
- ๐ Fix update to defined names when inserting/deleting rows/columns Issue #3076 PR #3077
- ๐ Fix DataValidation sqRef when inserting/deleting rows/columns Issue #3056 PR #3074
- Named ranges not usable as anchors in OFFSET function Issue #3013
- Fully flatten an array Issue #2955 PR #2956
- ๐ cellExists() and getCell() methods should support UTF-8 named cells Issue #2987 PR #2988
- ๐ฏ Spreadsheet copy fixed, clone disabled. PR #2951
- ๐ Fix PDF problems with text rotation and paper size. Issue #1747 Issue #1713 PR #2960
- ๐ Limited support for chart titles as formulas Issue #2965 Issue #749 PR #2971
- โ Add Gradients, Transparency, and Hidden Axes to Chart Issue #2257 Issue #2229 Issue #2935 PR #2950
- ๐ Chart Support for Rounded Corners and Trendlines Issue #2968 Issue #2815 PR #2976
- โ Add setName Method for Chart Issue #2991 PR #3001
- Eliminate partial dependency on php-intl in StringHelper Issue #2982 PR #2994
- Minor changes for Pdf Issue #2999 PR #3002 PR #3006
- 0๏ธโฃ Html/Pdf Do net set background color for cells using (default) nofill PR #3016
- โ Add support for Date Axis to Chart Issue #2967 PR #3018
- Reconcile Differences Between Css and Excel for Cell Alignment PR #3048
- ๐ R1C1 Format Internationalization and Better Support for Relative Offsets Issue #1704 PR #3052
- Minor Fix for Percentage Formatting Issue #1929 PR #3053
- Implementation of the new
-
v1.24.1 Changes
July 18, 2022โ Added
- ๐ Support for SimpleCache Interface versions 1.0, 2.0 and 3.0
- โ Add Chart Axis Option textRotation Issue #2705 PR #2940
๐ Changed
- Nothing
๐ Deprecated
- Nothing
โ Removed
- Nothing
๐ Fixed
- Fix Encoding issue with Html reader (PHP 8.2 deprecation for mb_convert_encoding) Issue #2942 PR #2943
- โ Additional Chart fixes
- Pie chart with part separated unwantedly Issue #2506 PR #2928
- Chart styling is lost on simple load / save process Issue #1797 Issue #2077 PR #2930
- Can't create contour chart (surface 2d) Issue #2931 PR #2933
- VLOOKUP Breaks When Array Contains Null Cells Issue #2934 PR #2939
-
v1.24.0 Changes
July 09, 2022๐ Note that this will be the last 1.x branch release before the 2.x release. We will maintain both branches in parallel for a time; but users are requested to update to version 2.0 once that is fully available.
โ Added
- โ Added
removeComment()
method for Worksheet PR #2875 - โ Add point size option for scatter charts Issue #2298 PR #2801
- ๐ Basic support for Xlsx reading/writing Chart Sheets PR #2830
Note that a ChartSheet is still only written as a normal Worksheet containing a single chart, not as an actual ChartSheet.
- โ Added Worksheet visibility in Ods Reader PR #2851 and Gnumeric Reader PR #2853
- โ Added Worksheet visibility in Ods Writer PR #2850
- ๐ Allow Csv Reader to treat string as contents of file Issue #1285 PR #2792
- ๐ Allow Csv Reader to store null string rather than leave cell empty Issue #2840 PR #2842
- Provide new Worksheet methods to identify if a row or column is "empty", making allowance for different definitions of "empty":
- Treat rows/columns containing no cell records as empty (default)
- Treat cells containing a null value as empty
- Treat cells containing an empty string as empty
๐ Changed
- Modify
rangeBoundaries()
,rangeDimension()
andgetRangeBoundaries()
Coordinate methods to work with row/column ranges as well as with cell ranges and cells PR #2926 - ๐ Better enforcement of value modification to match specified datatype when using
setValueExplicit()
- ๐ Relax validation of merge cells to allow merge for a single cell reference Issue #2776
- Memory and speed improvements, particularly for the Cell Collection, and the Writers.
See the Discussion section on github for details of performance across versions
- ๐ Improved performance for removing rows/columns from a worksheet
๐ Deprecated
- Nothing
โ Removed
- Nothing
๐ Fixed
- Xls Reader resolving absolute named ranges to relative ranges Issue #2826 PR #2827
- Null value handling in the Excel Math/Trig PRODUCT() function Issue #2833 PR #2834
- ๐จ Invalid Print Area defined in Xlsx corrupts internal storage of print area Issue #2848 PR #2849
- Time interval formatting Issue #2768 PR #2772
- Copy from Xls(x) to Html/Pdf loses drawings PR #2788
- Html Reader converting cell containing 0 to null string Issue #2810 PR #2813
- ๐ Many fixes for Charts, especially, but not limited to, Scatter, Bubble, and Surface charts. Issue #2762 Issue #2299 Issue #2700 Issue #2817 Issue #2763 Issue #2219 Issue #2863 PR #2828 PR #2841 PR #2846 PR #2852 PR #2856 PR #2865 PR #2872 PR #2879 PR #2898 PR #2906 PR #2922 PR #2923
- Adjust both coordinates for two-cell anchors when rows/columns are added/deleted. Issue #2908 PR #2909
- Keep calculated string results below 32K. PR #2921
- Filter out illegal Unicode char values FFFE/FFFF. Issue #2897 PR #2910
- ๐ Better handling of REF errors and propagation of all errors in Calculation engine. PR #2902
- Calculating Engine regexp for Column/Row references when there are multiple quoted worksheet references in the formula Issue #2874 PR #2899
- โ Added
-
v1.23.0 Changes
April 24, 2022โ Added
- ๐ Ods Writer support for Freeze Pane Issue #2013 PR #2755
- ๐ Ods Writer support for setting column width/row height (including the use of AutoSize) Issue #2346 PR #2753
- Introduced CellAddress, CellRange, RowRange and ColumnRange value objects that can be used as an alternative to a string value (e.g.
'C5'
,'B2:D4'
,'2:2'
or'B:C'
) in appropriate contexts. - Implementation of the FILTER(), SORT(), SORTBY() and UNIQUE() Lookup/Reference (array) functions.
- Implementation of the ISREF() Information function.
- โ Added support for reading "formatted" numeric values from Csv files; although default behaviour of reading these values as strings is preserved.
(i.e a value of "12,345.67" can be read as numeric
12345.67
, not simply as a string"12,345.67"
, if thecastFormattedNumberToNumeric()
setting is enabled.This functionality is locale-aware, using the server's locale settings to identify the thousands and decimal separators.
- ๐ Support for two cell anchor drawing of images. #2532 #2674
- ๐ Limited support for Xls Reader to handle Conditional Formatting:
Ranges and Rules are read, but style is currently limited to font size, weight and color; and to fill style and color.
- โ Add ability to suppress Mac line ending check for CSV #2623
- ๐ Initial support for creating and writing Tables (Xlsx Writer only) PR #2671
See
/samples/Table
for examples of use.Note that PreCalculateFormulas needs to be disabled when saving spreadsheets containing tables with formulae (totals or column formulae).
๐ Changed
- Gnumeric Reader now loads number formatting for cells.
- Gnumeric Reader now correctly identifies selected worksheet and selected cells in a worksheet.
- ๐จ Some Refactoring of the Ods Reader, moving all formula and address translation from Ods to Excel into a separate class to eliminate code duplication and ensure consistency.
- ๐ Make Boolean Conversion in Csv Reader locale-aware when using the String Value Binder.
This is determined by the Calculation Engine locale setting.
(i.e.
"Vrai"
wil be converted to a booleantrue
if the Locale is set tofr
.)- ๐ Allow
psr/simple-cache
2.x
๐ Deprecated
- ๐ All Excel Function implementations in
Calculation\Functions
(including the Error functions) have been moved to dedicated classes for groups of related functions. See the docblocks against all the deprecated methods for details of the new methods to call instead. At some point, these old classes will be deleted. - Worksheet methods that reference cells "byColumnandRow". All such methods have an equivalent that references the cell by its address (e.g. '
E3'
rather than5, 3
).
These functions now accept either a cell address string (
'E3')
or an array with columnId and rowId ([5, 3]
) or a newCellAddress
object as theircellAddress
/coordinate
argument. This includes the methods:setCellValueByColumnAndRow()
use the equivalentsetCellValue()
setCellValueExplicitByColumnAndRow()
use the equivalentsetCellValueExplicit()
getCellByColumnAndRow()
use the equivalentgetCell()
cellExistsByColumnAndRow()
use the equivalentcellExists()
getStyleByColumnAndRow()
use the equivalentgetStyle()
setBreakByColumnAndRow()
use the equivalentsetBreak()
mergeCellsByColumnAndRow()
use the equivalentmergeCells()
unmergeCellsByColumnAndRow()
use the equivalentunmergeCells()
protectCellsByColumnAndRow()
use the equivalentprotectCells()
unprotectCellsByColumnAndRow()
use the equivalentunprotectCells()
setAutoFilterByColumnAndRow()
use the equivalentsetAutoFilter()
freezePaneByColumnAndRow()
use the equivalentfreezePane()
getCommentByColumnAndRow()
use the equivalentgetComment()
setSelectedCellByColumnAndRow()
use the equivalentsetSelectedCells()
This change provides more consistency in the methods (not every "by cell address" method has an equivalent "byColumnAndRow" method); and the "by cell address" methods often provide more flexibility, such as allowing a range of cells, or referencing them by passing the defined name of a named range as the argument.
โ Removed
- Nothing
๐ Fixed
- ๐ Make allowance for the AutoFilter dropdown icon in the first row of an Autofilter range when using Autosize columns. Issue #2413 PR #2754
- ๐ Support for "chained" ranges (e.g.
A5:C10:C20:F1
) in the Calculation Engine; and also support for using named ranges with the Range operator (e.g.NamedRange1:NamedRange2
) Issue #2730 PR #2746 - โก๏ธ Update Conditional Formatting ranges and rule conditions when inserting/deleting rows/columns Issue #2678 PR #2689
- ๐ Allow
INDIRECT()
to accept row/column ranges as well as cell ranges PR #2687 - ๐ Fix bug when deleting cells with hyperlinks, where the hyperlink was then being "inherited" by whatever cell moved to that cell address.
- ๐ Fix bug in Conditional Formatting in the Xls Writer that resulted in a broken file when there were multiple conditional ranges in a worksheet.
- ๐ Fix Conditional Formatting in the Xls Writer to work with rules that contain string literals, cell references and formulae.
- ๐ Fix for setting Active Sheet to the first loaded worksheet when bookViews element isn't defined Issue #2666 PR #2669
- ๐ Fixed behaviour of XLSX font style vertical align settings PR #2619
- ๐ Resolved formula translations to handle separators (row and column) for array functions as well as for function argument separators; and cleanly handle nesting levels.
Note that this method is used when translating Excel functions between
en_us
and other locale languages, as well as when converting formulae between different spreadsheet formats (e.g. Ods to Excel).Nor is this a perfect solution, as there may still be issues when function calls have array arguments that themselves contain function calls; but it's still better than the current logic.
- ๐ Fix for escaping double quotes within a formula Issue #1971 PR #2651
- ๐ Change open mode for output from
wb+
towb
Issue #2372 PR #2657 - ๐ Use color palette if supplied Issue #2499 PR #2595
- Xls reader treat drawing offsets as int rather than float PR #2648
- ๐ Handle booleans in conditional styles properly PR #2654
- ๐ Fix for reading files in the root directory of a ZipFile, which should not be prefixed by relative paths ("./") as dirname($filename) does by default.
- ๐ Fix invalid style of cells in empty columns with columnDimensions and rows with rowDimensions in added external sheet. PR #2739
- Time Interval Formatting Issue #2768 PR #2772
-
v1.22.0 Changes
February 18, 2022โ Added
๐ Namespacing phase 2 - styles. PR #2471
๐ Improved support for passing of array arguments to Excel function implementations to return array results (where appropriate). Issue #2551
This is the first stage in an ongoing process of adding array support to all appropriate function implementations,
- ๐ Support for the Excel365 Math/Trig SEQUENCE() function PR #2536
- ๐ Support for the Excel365 Math/Trig RANDARRAY() function PR #2540
Note that the Spill Operator is not yet supported in the Calculation Engine; but this can still be useful for defining array constants.
๐ Improved support for Conditional Formatting Rules PR #2491
- Provide support for a wider range of Conditional Formatting Rules for Xlsx Reader/Writer:
- Cells Containing (cellIs)
- Specific Text (containing, notContaining, beginsWith, endsWith)
- Dates Occurring (all supported timePeriods)
- Blanks/NoBlanks
- Errors/NoErrors
- Duplicates/Unique
- Expression
- Provision of CF Wizards (for all the above listed rule types) to help create/modify CF Rules without having to manage all the combinations of types/operators, and the complexities of formula expressions, or the text/timePeriod attributes.
See documentation for details
- Full support of the above CF Rules for the Xlsx Reader and Writer; even when the file being loaded has CF rules listed in the
<extLst><ext><ConditionalFormattings>
element for the worksheet rather than the<ConditionalFormatting>
element. - Provision of a CellMatcher to identify if rules are matched for a cell, and which matching style will be applied.
- Improved documentation and examples, covering all supported CF rule types.
- Add support for one digit decimals (FORMAT_NUMBER_0, FORMAT_PERCENTAGE_0). PR #2525
- Initial work enabling Excel function implementations for handling arrays as arguments when used in "array formulae" #2562
- Enable most of the Date/Time functions to accept array arguments #2573
- Array ready functions - Text, Math/Trig, Statistical, Engineering and Logical #2580
๐ Changed
- โ Additional Russian translations for Excel Functions (courtesy of aleks-samurai).
- ๐ Improved code coverage for NumberFormat. PR #2556
- Extract some methods from the Calculation Engine into dedicated classes #2537
- Eliminate calls to
flattenSingleValue()
that are no longer required when we're checking for array values as arguments #2590
๐ Deprecated
- Nothing
โ Removed
- Nothing
๐ Fixed
- ๐ Fixed
ReferenceHelper@insertNewBefore
behavior when removing column before last column with null value PR #2541 - ๐ Fix bug with
DOLLARDE()
andDOLLARFR()
functions when the dollar value is negative Issue #2578 PR #2579 - ๐ Fix partial function name matching when translating formulae from Russian to English Issue #2533 PR #2534
- Various bugs related to Conditional Formatting Rules, and errors in the Xlsx Writer for Conditional Formatting PR #2491
- ๐ Xlsx Reader merge range fixes. Issue #2501 PR #2504
- ๐ Handle explicit "date" type for Cell in Xlsx Reader. Issue #2373 PR #2485
- ๐ Recalibrate Row/Column Dimensions after removeRow/Column. Issue #2442 PR #2486
- Refinement for XIRR. Issue #2469 PR #2487
- Xlsx Reader handle cell with non-null explicit type but null value. Issue #2488 PR #2489
- Xlsx Reader fix height and width for oneCellAnchorDrawings. PR #2492
- Fix rounding error in NumberFormat::NUMBER_PERCENTAGE, NumberFormat::NUMBER_PERCENTAGE_00. PR #2555
- Don't treat thumbnail file as xml. Issue #2516 PR #2517
- โ Eliminating Xlsx Reader warning when no sz tag for RichText. Issue #2542 PR #2550
- ๐ Fix Xlsx/Xls Writer handling of inline strings. Issue #353 PR #2569
- Richtext colors were not being read correctly after namespace change #2458
- ๐ Fix discrepancy between the way markdown tables are rendered in ReadTheDocs and in PHPStorm #2520
- โก๏ธ Update Russian Functions Text File #2557
- ๐ Fix documentation, instantiation example #2564
-
v1.21.0 Changes
January 06, 2022โ Added
- ๐ Ability to add a picture to the background of the comment. Supports four image formats: png, jpeg, gif, bmp. New
Comment::setSizeAsBackgroundImage()
to change the size of a comment to the size of a background image. Issue #1547 PR #2422 - 0๏ธโฃ Ability to set default paper size and orientation PR #2410
- Ability to extend AutoFilter to Maximum Row PR #2414
๐ Changed
- Xlsx Writer will evaluate AutoFilter only if it is as yet unevaluated, or has changed since it was last evaluated PR #2414
๐ Deprecated
- Nothing
โ Removed
- Nothing
๐ Fixed
- Rounding in
NumberFormatter
Issue #2385 PR #2399 - ๐ Support for themes Issue #2075 Issue #2387 PR #2403
- Read spreadsheet with
#
in name Issue #2405 PR #2409 - ๐ Improve PDF support for page size and orientation Issue #1691 PR #2410
- Wildcard handling issues in text match Issue #2430 PR #2431
- Respect DataType in
insertNewBefore
PR #2433 - ๐ Handle rows explicitly hidden after AutoFilter Issue #1641 PR #2414
- Special characters in image file name Issue #1470 Issue #2415 PR #2416
- ๐ Mpdf with very many styles Issue #2432 PR #2434
- ๐ Name clashes between parsed and unparsed drawings Issue #1767 Issue #2396 PR #2423
- Fill pattern start and end colors Issue #2441 PR #2444
- ๐ General style specified in wrong case Issue #2450 PR #2451
- Null passed to
AutoFilter::setRange()
Issue #2281 PR #2454 - Another undefined index in Xls reader (#2470) Issue #2463 PR #2470
- ๐ Allow single-cell checks on conditional styles, even when the style is configured for a range of cells (#) PR #2483
- ๐ Ability to add a picture to the background of the comment. Supports four image formats: png, jpeg, gif, bmp. New
-
v1.20.0 Changes
November 23, 2021โ Added
- ๐ Xlsx Writer Support for WMF Files #2339
- ๐ Use standard temporary file for internal use of HTMLPurifier #2383
๐ Changed
- โฌ๏ธ Drop support for PHP 7.2, according to https://phpspreadsheet.readthedocs.io/en/latest/#php-version-support
- ๐ Use native typing for objects that were already documented as such
๐ Deprecated
- Nothing
โ Removed
- Nothing
๐ Fixed
- ๐ Fixed null conversation for strToUpper #2292
- ๐ Fixed Trying to access array offset on value of type null (Xls Reader) #2315
- Don't corrupt XLSX files containing data validation #2377
- โก๏ธ Non-fixed cells were not updated if shared formula has a fixed cell #2354
- Declare key of generic ArrayObject
- ๐ CSV reader better support for boolean values #2374
- Some ZIP file could not be read #2376
- ๐ Fix regression were hyperlinks could not be read #2391
- AutoFilter Improvements #2393
- Don't corrupt file when using chart with fill color #589
- โช Restore imperfect array formula values in xlsx writer #2343
- โช Restore explicit list of changes to PHPExcel migration document #1546
-
v1.19.0 Changes
October 31, 2021โ Added
- ๐ Ability to set style on named range, and validate input to setSelectedCells Issue #2279 PR #2280
- ๐จ Process comments in Sylk file Issue #2276 PR #2277
- โ Addition of Custom Properties to Ods Writer, and 32-bit-safe timestamps for Document Properties PR #2113
- โ Added callback to CSV reader to set user-specified defaults for various properties (especially for escape which has a poor PHP-inherited default of backslash which does not correspond with Excel) PR #2103
- ๐ Phase 1 of better namespace handling for Xlsx, resolving many open issues PR #2173 PR #2204 PR #2303
- โ Add ability to extract images if source is a URL Issue #1997 PR #2072
- ๐ Support for passing flags in the Reader
load()
and Writersave()
methods, and through the IOFactory, to set behaviours PR #2136- See documentation for details
- More flexibility in the StringValueBinder to determine what datatypes should be treated as strings PR #2138
- Helper class for conversion between css size Units of measure (
px
,pt
,pc
,in
,cm
,mm
) PR #2152 - ๐ Allow Row height and Column Width to be set using different units of measure (
px
,pt
,pc
,in
,cm
,mm
), rather than only in points or MS Excel column width units PR #2152 - Ability to stream to an Amazon S3 bucket Issue #2249
- Provided a Size Helper class to validate size values (pt, px, em) PR #1694
๐ Changed
- Nothing.
๐ Deprecated
- PHP 8.1 will deprecate auto_detect_line_endings. As a result of this change, Csv Reader using some release after PHP8.1 will no longer be able to handle a Csv with Mac line endings.
โ Removed
- Nothing.
๐ Fixed
- Unexpected format in Xlsx Timestamp Issue #2331 PR #2332
- Corrections for HLOOKUP Issue #2123 PR #2330
- Corrections for Xlsx Read Comments Issue #2316 PR #2329
- Lowercase Calibri font names Issue #2273 PR #2325
- isFormula Referencing Sheet with Space in Title Issue #2304 PR #2306
- Xls Reader Fatal Error due to Undefined Offset Issue #1114 PR #2308
- Permit Csv Reader delimiter to be set to null Issue #2287 PR #2288
- Csv Reader did not handle booleans correctly PR #2232
- Problems when deleting sheet with local defined name Issue #2266 PR #2284
- Worksheet passwords were not always handled correctly Issue #1897 PR #2197
- Gnumeric Reader will now distinguish between Created and Modified timestamp PR #2133
- Xls Reader will now handle MACCENTRALEUROPE with or without hyphen Issue #549 PR #2213
- ๐ Tweaks to input file validation Issue #1718 PR #2217
- Html Reader did not handle comments correctly Issue #2234 PR #2235
- Apache OpenOffice Uses Unexpected Case for General format Issue #2239 PR #2242
- Problems with fraction formatting Issue #2253 PR #2254
- ๐ Xlsx Reader had problems reading file with no styles.xml or empty styles.xml Issue #2246 PR #2247
- Xlsx Reader did not read Data Validation flags correctly Issue #2224 PR #2225
- ๐ Better handling of empty arguments in Calculation engine PR #2143
- ๐ Many fixes for Autofilter Issue #2216 PR #2141 PR #2162 PR #2218
- ๐ Locale generator will now use Unix line endings even on Windows Issue #2172 PR #2174
- ๐ Support differences in implementation of Text functions between Excel/Ods/Gnumeric PR #2151
- ๐ Fixes to places where PHP8.1 enforces new or previously unenforced restrictions PR #2137 PR #2191 PR #2231
- ๐ฏ Clone for HashTable was incorrect PR #2130
- ๐ Xlsx Reader was not evaluating Document Security Lock correctly PR #2128
- Error in COUPNCD handling end of month Issue #2116 PR #2119
- ๐ Xls Writer Parser did not handle concatenation operator correctly PR #2080
- Xlsx Writer did not handle boolean false correctly Issue #2082 PR #2087
- SUM needs to treat invalid strings differently depending on whether they come from a cell or are used as literals Issue #2042 PR #2045
- Html reader could have set illegal coordinates when dealing with embedded tables Issue #2029 PR #2032
- ๐ Documentation for printing gridlines was wrong PR #2188
- ๐ Return Value Error - DatabaseAbstruct::buildQuery() return null but must be string Issue #2158 PR #2160
- Xlsx reader not recognize data validations that references another sheet Issue #1432 Issue #2149 PR #2150 PR #2265
- Don't calculate cell width for autosize columns if a cell contains a null or empty string value Issue #2165 PR #2167
- ๐ Allow negative interest rate values in a number of the Financial functions (
PPMT()
,PMT()
,FV()
,PV()
,NPER()
, etc) Issue #2163 PR #2164 - Xls Reader changing grey background to black in Excel template Issue #2147 PR #2156
- ๐ Column width and Row height styles in the Html Reader when the value includes a unit of measure Issue #2145.
- Data Validation flags not set correctly when reading XLSX files Issue #2224 PR #2225
- ๐ Reading XLSX files without styles.xml throws an exception Issue #2246
- ๐ Improved performance of
Style::applyFromArray()
when applied to several cells PR #1785. - ๐ Improve XLSX parsing speed if no readFilter is applied (again) - #772
-
v1.18.0 Changes
May 31, 2021โ Added
- โจ Enhancements to CSV Reader, allowing options to be set when using
IOFactory::load()
with a callback to set delimiter, enclosure, charset etc. PR #2103 - See documentation for details. - Implemented basic AutoFiltering for Ods Reader and Writer PR #2053
- Implemented basic AutoFiltering for Gnumeric Reader PR #2055
- ๐ Improved support for Row and Column ranges in formulae Issue #1755 PR #2028
- ๐ Implemented URLENCODE() Web Function
- โ Implemented the CHITEST(), CHISQ.DIST() and CHISQ.INV() and equivalent Statistical functions, for both left- and right-tailed distributions.
- ๐ Support for ActiveSheet and SelectedCells in the ODS Reader and Writer. PR #1908
- ๐ Support for notContainsText Conditional Style in xlsx Issue #984
๐ Changed
- ๐ Use of
nb
rather thanno
as the locale code for Norsk Bokmรฅl.
๐ Deprecated
- ๐ All Excel Function implementations in
Calculation\Database
,Calculation\DateTime
,Calculation\Engineering
,Calculation\Financial
,Calculation\Logical
,Calculation\LookupRef
,Calculation\MathTrig
,Calculation\Statistical
,Calculation\TextData
andCalculation\Web
have been moved to dedicated classes for individual functions or groups of related functions. See the docblocks against all the deprecated methods for details of the new methods to call instead. At some point, these old classes will be deleted.
โ Removed
- ๐ Use of
nb
rather thanno
as the locale language code for Norsk Bokmรฅl.
๐ Fixed
- ๐ Fixed error in COUPNCD() calculation for end of month Issue #2116 - PR #2119
- 0๏ธโฃ Resolve default values when a null argument is passed for HLOOKUP(), VLOOKUP() and ADDRESS() functions Issue #2120 - PR #2121
- ๐ Fixed incorrect R1C1 to A1 subtraction formula conversion (
R[-2]C-R[2]C
) Issue #2076 PR #2086 - Correctly handle absolute A1 references when converting to R1C1 format PR #2060
- ๐ Correct default fill style for conditional without a pattern defined Issue #2035 PR #2050
- ๐ Fixed issue where array key check for existince before accessing arrays in Xlsx.php. PR #1970
- ๐ Fixed issue with quoted strings in number format mask rendered with toFormattedString() Issue 1972# PR #1978
- ๐ Fixed issue with percentage formats in number format mask rendered with toFormattedString() Issue 1929# PR #1928
- ๐ Fixed issue with _ spacing character in number format mask corrupting output from toFormattedString() Issue 1924# PR #1927
- ๐ Fix for Issue #1887 - Lose Track of Selected Cells After Save
- ๐ Fixed issue with Xlsx@listWorksheetInfo not returning any data
- ๐ Fixed invalid arguments triggering mb_substr() error in LEFT(), MID() and RIGHT() text functions. Issue #640
- ๐ Fix for Issue #1916 - Invalid signature check for XML files
- ๐ Fix change in
Font::setSize()
behavior for PHP8. PR #2100
- โจ Enhancements to CSV Reader, allowing options to be set when using