Click or drag to resize

ExcelFileAutomaticFormulaUpdate Property

Gets or sets a value indicating whether the formula address references are automatically updated.

Namespace:  GemBox.Spreadsheet
Assembly:  GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 41.3.30.1132
Syntax
public bool AutomaticFormulaUpdate { get; set; }

Property Value

Type: Boolean
Remarks

If you use address references in a formula, those references will be automatically updated if you insert or delete rows or columns and those changes affect the address reference in some way.

If this property is , formula address references will not update automatically. This should be used only for performance reasons when working on large files.

Default value of this property is .

See Also