Released: Jul 6, 2023

2023.7.4 での更新項目

機能

• Added 'GetMergedRegions' method, which is used to retrieve a list of merged regions.
• Added 'RemoveColumn' method group to Range, RangeRow, RangeColumn, Worksheet.
• Improved performance of bulk data manipulation by 20-25%.
• WorkSheet's internal working range will now include the empty columns at the end of the range which hold any styling information.
• 'Range.RemoveColumn' and 'Range.RemoveRow' methods will now always remove the column/row entirely from the sheet, shifting up/to the left the rows/columns located below/to the right of the removed ones, if after the removal the column/row is empty.
• Added 'Range.Count' property, which returns the number of cells in the range without iterating over all cells.
• Changed the 'Range.ColumnCount' and 'Range.RowCount' properties to return the number of columns/rows in the range without iterating over all cells.
• Improved documentation for Range class and its heirs.
• 'InsertRow' and 'InsertColumn' methods will now return the inserted row/column. Same for 'InsertRows' and 'InsertColumns' methods but these will return lists of inserted columns/rows.
• Added 'WorkSheet.RangeAddress' property with the address of the area in use on the sheet.
• Updated IronSoftware.System.Drawing to 2023.7.1.
• Deprecated the 'Range.AllRowsInRange' and 'Range.AllColumnsInRange' properties, use 'Range.Rows' and 'Range.Columns 'instead. This is also true for the WorkSheet, RangeRowand RangeColumn classes.

不具合の修正

• Fixed a bug where the Clear method did not delete all worksheets in the collection.
• Fixed a bug where the InsertColumn method skip the last row.
• Fixed a bug where the Range.ToDataTable method wolud stop converting when it encountered an empty row.
• InsertColumn method group will now correctly shift the columns out of the way, updating the formulas and moving styles with the cells.
• WorkSheet's internal working range will now correctly update with all changes made to the worksheet.
• Fixed numerous bugs in Range.Trim method, including a bug where Trim would not trim empty columns.
• Range's address will now be correctly updated when the range is changed (with Trim/Insert/Remove/Subtract methods).