Released: Aug 9, 2023

V23.8 中的更新

特性

• Added support for validating formula expressions.
• Added support for preserving padding spaces in formulas.
• Added support for list validation.
• Added the ability to replace text with rich formatting text.
• Added support for using Aspose.Cells in AWS lambda function projects.
• Improved the UI display for dropdown lists with long lists of data.
• Added support for text length and decimal validation.

修補程式

• Formulas of some conditional formattings can be ignored when saving XLSB.
• 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.
• Validation render is not correct for the file deal_56.xlsx.
• Fail to show scrollbar in the worksheet for the customer's file.
• Fail to insert/search comment when the active cell is out of view range.
• After move/resize operation the image/shape will disappear after scroll down.
• Browser was locked or crashed when first column is hidden.
• 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.
• Web designer raise error after update DLL from 23.2 to 23.3 or higher for GridWeb.
• System.NullReferenceException is thrown when rendering combo chart in Excel file to SVG.