Released: Aug 23, 2023

Updates in V23.8

Features

• Improved UI display for dropdowns with long lists of data.
• Added support for preserving padding space in formulas.
• Conditional formatting formulas can now be ignored when saving to XLSB format.

Fixes

• CHAR function returns error value when calling CalculateFormula.
• DataSorter does not clear old data when new data is blank.
• Incorrect result of calculating NUMBERVALUE Formula.
• Function’s calculated value changes from “#REF!” to “#VALUE!” after changing file format from xlsx to xls.
• Symbols are not aligned with chart.
• Wrong labels at x-axis of chart when saving file to pdf.
• Chart.ToImage results in different axes ticks compared to Excel chart.
• Row 10000 is cut off while converting workbook to PDF with OnePagePerSheet set to true.
• Issue with rendering contents layout in Excel to HTML conversion.
• Keep the same paper size when converting Excel to Word.
• Multiplies the controls after resaving the file.
• Conditional formatting range error after shifting a range of cells.
• Image setting properties of header and footer are changed when resaving the file.
• Conditional formatting does not work for xlsb file if operator type is between.
• Cell range merge error after refreshing pivot table.
• Data not filled into worksheet cells when Smart Markers field names contain special characters.
• Table data becomes images when converting Excel file to docx.
• Some borders of merged areas disappeared when converting Excel to docx.
• The exported columns' width in docx is not same in xlsx.
• Top 10 calculation error in Values Filter after refreshing pivot table.
• Greater than calculation error in Values Filter after refreshing pivot table.
• Exception occurred while refreshing pivot table.
• The value of pivot calculated field is not same as MS Excel..
• Range.CurrentRegion is taking very long time for big tables in workbook.
• Grand Total value is not correct with pivot table filter.
• Copying a range does not copy all borders.