avadim/fast-excel-writer

Fixed

• The hidden attribute of a column and a row was treated as a flag, not as a value of xs:boolean type. Excel writes it as 0/1, but LibreOffice writes false/true, and the string 'false' is truthy in PHP, so the check !empty($attributes['hidden']) turned a visible column into a hidden one. A template made or edited in LibreOffice was saved with all its columns hidden, see #140
• A column whose hidden resolves to false gets the default width again – the attribute is removed now instead of being written as hidden="0", which used to suppress the width
• Sheet::setColVisible($col, true) raised an Undefined array key warning on PHP 8 when the column had no attributes yet

Fixed

• Shared state between workbooks – with two workbooks open in one process the number formats of the locale (@money, @DATETIME, …) and the default font of the workbook created last were applied to the other one, so a report could be saved with a foreign currency or date format. StyleManager kept a reference to itself in a static property and the static normalizeFont() / numberFormatStandardized() read the state from there. There was no workaround: unset() of the foreign workbook did not help, the static property held it alive
• The style cache shared between workbooks – Sheet::_writeRow() kept the cache of cell styles in a static variable common to all sheets of all workbooks. Because the current row is flushed lazily, writing into two workbooks alternately gave the cells of one of them the style indexes of the other, which silently lost their formats
• An R1C1 reference shifted out of the sheet (=R[-4]C[-1] written to B2) was written to the file as is, and Excel refused to open such a file. It becomes #REF! now, the way Excel does it
• A range in R1C1 notation was converted by halves – the pattern did not know about :, so =SUM(R[-4]C[-1]:RC[-1]) could produce a hybrid like SUM(R[-4]C[-1]:A2). A range is captured as a whole now

API

• StyleManager::normalizeFont() takes an optional second argument – the style manager whose default font is used as the base. The old signature keeps working (the last created workbook is used then), but a caller that knows its own manager should pass it
• StyleManager::numberFormatStandardized() became a method of the instance (it was private static)

Fixed

• The cell type of a pre-calculated formula result – a text result was written without t="str", so Excel treated it as a number and showed #VALUE!; boolean and error results are now written as t="b"/t="e" too (#139)
• A formula with a null pre-calculated result (['=A1+B1', null]) – the cell was written empty and the formula was lost; now it is written without a cached value, so Excel calculates it on open
• Writer prevented garbage collection – it registered [$this, 'removeFiles'] as a shutdown function, which held a global reference to every instance, so the destructor never ran and memory grew in long-running/CLI processes (#138)

Added

• A Style object can be created directly from an options array – new Style($options)
• New method Excel::getSharedStringsRefCount()

Fixed

• Reused DataValidation/Conditional objects – applying one object to several ranges kept only the last range (#137)
• Sheet::setStateVeryHidden() made the sheet visible instead of very hidden
• Sheet::writeCell() rejected the last valid row (1048576) and column (XFD)
• Excel::rangeDimensionRelative() collapsed a range given as two associative points to a single cell
• A cell value containing invalid UTF-8 was silently dropped (xmlSpecialChars() now uses ENT_SUBSTITUTE)
• Numbers/dates under a comma LC_NUMERIC locale (e.g. de_DE) on PHP 7.4 produced invalid <v>3,14</v>
• Style corruption when two workbooks are open in the same process (StyleManager read default-font state from the wrong instance)
• Duplicate sheet names, and reuse of sheetN.xml after removeSheet() + makeSheet()
• Missing XML escaping of image names, chart names and hyperlink targets/locations
• Sheet::writeCells() dropped positional (integer-keyed) cell styles
• Formulas with escaped quotes "" and national function names containing regex metacharacters
• Shared strings lost leading/trailing spaces (xml:space="preserve")
• Area::getOffsetAddress() ignored its offset argument
• Sheet::skipRow(null) skipped no rows
• PHP 8.1+ deprecations from strtolower()/htmlspecialchars() on non-string arguments
• ZipArchive handle was not closed if saving threw an exception

Security

• Excel::download() strips CR/LF and quotes from the file name (header injection), sends the correct xlsx MIME type, adds an RFC 5987 filename* and checks headers_sent()
• Excel::loadImageFile() rejects dangerous stream wrappers (php://, phar://, glob://, zip://, data://, expect://, …)

Optimized

• Formula conversion skips the heavy _xlfn/_xlws passes when the formula contains no (
• sharedStrings.xml is streamed to disk instead of built entirely in memory (much lower peak memory when shared_string is enabled)
• Sheet::writeRow() hot path

Changed

• After removeSheet() + makeSheet(), new worksheet files use a monotonic index and never reuse a previous sheetN.xml

• New demos: rich text (demo-14), images & notes (demo-15); errors fixed in other demos, deprecated chart methods replaced
• Documentation: Russian translation, upgrade guide, ImageStyle and Options pages, rewritten README
• Optimized Writer::_writeCell()
• Fixed Charts\Layout::getXMode() and Charts\Layout::getYMode() - fatal TypeError when adding pie/donut charts
• Fixed RichTextFragment::outXml() - font size set via setSize() was not written

The behavior of the Sheet::setColFormats(), Sheet::setColStyleArray() and Sheet::setColDataStyleArray() methods has been changed when column numbers were used as keys (it was incorrect)

upd: numFmts index calculation;
upd: styles.xml for extra features;
upd: set style to cells without value;

rename Excel::$style to Excel::$styleManager and other updates for extra features