Skip to content

2.10.0

Latest

Choose a tag to compare

@iliaal iliaal released this 20 Nov 13:34
· 2 commits to master since this release
2.10.0
4e2afe4

Added

  • Windows release DLLs for PHP 8.6 (x64 and x86, TS and NTS).

Fixed

  • On thread-safe PHP builds such as FrankenPHP on Linux with glibc, the locale changes LibXL makes while it creates, loads, saves, or releases a workbook, and in setLocale(), no longer reach other threads or PHP code. Concurrent saves could leave LC_NUMERIC set to C for the whole process, and an open workbook switched LC_CTYPE for every thread. LibXL now runs on a per-thread locale built from its own changes on top of C. phpinfo() reports the state as "LibXL locale isolation".
  • ExcelBook::packDateValues() rejects calendar years before 1900 and calendar serials below 1, matching packDate() boundaries while preserving explicit all-zero date fields for time-only values. Other LibXL calendar normalization remains unchanged.
  • ExcelBook::packDate() accepts supported pre-epoch timestamps instead of rejecting every negative timestamp. packDate() and AS_DATE writes reject local dates before 1900-01-01 (1900 system) or 1904-01-02 (1904 system), whose serials are unsupported, collide, or are reserved for time-only values.
  • Reject unsupported data-validation types, operators, and error styles with a warning and false instead of silently omitting the corresponding XLSX attributes.
  • Reject unsupported custom-filter operators with a warning and false before LibXL writes empty XLSX operator attributes. All six documented operators and the optional second-criterion sentinel remain accepted.
  • Reject unsupported conditional-formatting rule and color-scale value types with a warning and false before LibXL writes empty XLSX type attributes. All documented types remain accepted.
  • Reject unsupported operators in conditional-formatting numeric and string rules with a warning and false before LibXL can write an empty XLSX operator. All twelve documented operators remain accepted.

Documentation

  • Correct lastFilledRow() and lastFilledCol() documentation: both return exclusive ends, not the last filled cell indexes.
  • Clarify null getter mode for ExcelFormat alignment and boolean properties, ExcelSheet gridline/zoom parameter types, and getIndexRange() warnings for indexes outside the native integer range.
  • Clarify nullable integer parameters and getter mode for individual ExcelFormat borders and fill properties.
  • Document the name returned by ExcelSheet::getIndexRange(), its zero-based index, and false result for missing ranges.
  • Clarify that ExcelFormat::borderStyle() and borderColor() are write-only setters: omitted or null arguments leave borders unchanged, rather than reading their values.
  • Document that ExcelTable::autoFilter() creates the filter when absent, and show checking its handle before chaining; isAutoFilter() is a read-only probe on LibXL 5.2.0 and later.
  • Document null|false returns for ExcelSheet and ExcelBook setters that extension validation can reject, and false returns from ExcelConditionalFormat, ExcelFormControl, and ExcelTable getters on an uninitialized or stale wrapper.
  • Document that a successful ExcelSheet::removeFilter() or ExcelTable::removeFilter() invalidates every ExcelAutoFilter and ExcelFilterColumn wrapper in the workbook.
  • Correct the print-repeat row and column parameter types to int in the ExcelSheet docs.

Changed

  • On thread-safe PHP builds on Linux with glibc, LibXL no longer follows the locale PHP code sets with setlocale(). It starts from C and changes only through setLocale() and its own requests, so code that relied on setlocale() reaching LibXL must call ExcelBook::setLocale() instead. Non-thread-safe builds still follow setlocale().
  • Reuse the shared row-coordinate validator in setRowHeight() and setRowPx(), preserving workbook-specific bounds and warning order.
  • Remove unreachable range-order checks from print-repeat and print-area setters; shared validators retain the existing warnings and return values.