Click or drag to resize

ExcelFileGroupMethodsAffectedCellsLimit Property

Maximum number of affected cells in group set methods.

Namespace:  GemBox.Spreadsheet
Assembly:  GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version:
public int GroupMethodsAffectedCellsLimit { get; set; }

Property Value

Type: Int32
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