Spire.XLS 16.9.2 supports the TRANSPOSS formula

2026-09-15 09:21:14

We're pleased to announce the release of Spire.XLS 16.9.2. This version supports the TRANSPOSS formula and also fixes several issues that occurred when converting Excel to PDF and exporting data. More details are shown below.

Here is a list of changes made in this release

Category ID Description
New Feature SPIREXLS-6200 Added support for TRANSPOSS formula.
sheet.Range["F1:H4"].FormulaArray = "=TRANSPOSE(A2:D4)";  
Bug Fix SPIREXLS-6204 Fixed the issue where column widths were inconsistent when converting Excel to PDF.
Bug Fix SPIREXLS-6206 Fixed the issue where borders appeared thicker when converting Excel to PDF.
Bug Fix SPIREXLS-6209 Fixed the issue where incorrect data was exported when using ExportDataTable.
Click the link to download Spire.XLS 16.9.2:
More information of Spire.XLS new release or hotfix: