GrapeCity.Documents.Excel.DeserializationOptions.DoNotRecalculateAfterLoad

DoNotRecalculateAfterLoad Property

DoNotRecalculateAfterLoad

Gets or sets whether to skip marking formulas dirty after loading JSON data.

This option is used by JSON deserialization APIs such as FromJson(string, DeserializationOptions) and Open(string, DeserializationOptions). The default value is false.

When this property is true, formulas are not marked dirty after loading, so the formula results loaded from JSON are returned when calculation is triggered. When this property is false, formulas are marked dirty after loading, so formula results are recalculated when calculation is triggered. Calculation can be triggered by operations such as getting formula values or calling Calculate().

Declaration

public bool DoNotRecalculateAfterLoad { get; set; }

Public Property DoNotRecalculateAfterLoad As Boolean

Examples

DeserializationOptions openOptions = new DeserializationOptions();
openOptions.DoNotRecalculateAfterLoad = true;
bool doNotRecalculate = openOptions.DoNotRecalculateAfterLoad;
workbook.Open("source.json", openOptions);