v2.0.2

Feature release

Features

• #357 / #437 / #473 / #297 / #449 — insertImageOpt($row, $col, $path, $options) extends image placement beyond the width/height scale factors of insertImage(): pixel-precise x_offset / y_offset within the anchor cell, a "don't move or size with cells" anchor mode (so constMemory + dynamic row heights stop warping the image), plus a mouseover tip, alt text (description / decorative) and a url hyperlink overlay. Object positioning is exposed via new Excel::OBJECT_POSITION_DEFAULT / MOVE_AND_SIZE / MOVE_DONT_SIZE / DONT_MOVE_DONT_SIZE / MOVE_AND_SIZE_AFTER constants. The original insertImage() signature is untouched.
• #503 — insertDynamicFormula() and insertDynamicArrayFormula() emit the t="array" + ref-range XML that Excel 365 dynamic array functions (UNIQUE, FILTER, SORT, SEQUENCE, XLOOKUP, …) require. insertFormula() does not produce that markup, so those functions previously did not spill.
• #540 — outlineSettings(bool $visible = true, bool $below = true, bool $right = true, bool $autoStyle = false) configures worksheet outline (grouping) display.

Fixes

• #543 — PHP true / false passed to data() / writeSheet() now writes a real boolean cell (xlsx type="b") instead of falling through type_writer() silently and emitting a blank cell.

Install

The self-contained xlswriter-2.0.2.tgz attached below is what pecl install xlswriter and pie install viest/xlswriter consume; the packagist zipball has no submodules and cannot build.