Released: Apr 9, 2026

V26.4 での更新項目

機能

• Added support for calculating REGEXEXTRACT and REGEXREPLACE functions.
• Added the ability to expand a table when copying ranges.
• Added support for shifting formulas after inserting cut ranges.
• Added support for formatting a whole row or column of pivot table.
• Added support for exporting the label of a table column to an XLS file.
• You can now copy rich values from another workbook.

不具合の修正

• Final punctuation mark missing in the output PDF - Excel to PDF conversion,
• Failed to set font color for shape,
• Shape.Id changed after save,
• NullPointerException was thrown when setting dynamic array formula for a cell with custom values,
• Array formula with volatile functions is not saved properly when saving XLSX file.
• CalculateFormula fails on chained dynamic array formulas.
• AND function in shared formula was calculated incorrectly.
• INDEX function in shared formula was calculated incorrectly.
• Defined Name staring with a pair of square brackets and enclosed content is taken as invalid.
• Setting formula failed when referencing to defined name starting with square brackets.
• Cell.StringValue does not format the value with rich value of formatted number.
• MAP function was calculated as #VALUE! but in Excel it should be #CALC!.
• Pillars incomplete when rendering image.
• Excel chart data labels corrupted with 'CELLR' text and oversized balloons during rendering.
• Missing label in the legend of a PivotChart on Chart.ToPdf method.
• Abnormal 'Infinity' data appears in the XPS file.
• Chart legend incorrectly displays hidden 'Lower Bound' series and omits 'Range' series during export.
• Indent of pivot item is not same as Excel.
• Copying sheets between workbooks causes issues when textjoin is used in a formula.
• STOCKHISTORY formula caused circular reference error in XLSB.
• The line graph (Sparklines) under the column Trend (line) is different from Excel.
• Lost data source of pivot chart.
• Structured table references in formulas are corrupted after Cells.InsertCutCells.
• Removing the first row of a table gives error.
• Issue with AutoFitColumns function.
• An extra blank row was inserted when pivot table does not contain grand total row.
• Data corruption and '#VALUE!' errors after XLSX to XLSM to XLSX conversion.
• Invalid row subheading area if blank rows are inserted for the next level pivot file.