GemBox.Spreadsheet

ExcelFile.GroupMethodsAffectedCellsLimit Property

Maximum number of affected cells in group set methods.

public int GroupMethodsAffectedCellsLimit {get; set;}

Remarks

If user tries to modify all cells in a group which has more cells than specified limit, exception will be thrown. This property was introduced to prevent users from accidentally modifying millions of cells which results in a long delay, a large memory allocation and a big resulting file. You can set this limit to value which suits your needs (minimum is 5).

See Also

ExcelFile Class | GemBox.Spreadsheet Namespace