Loads formulas that are deserialized, but not parsed yet, to be used after all sheets have been created and deserialized.
Syntax
Parameters
- recalculate
- Whether to recalculate all the formulas in cells that have changed
Remarks
Example
This example uses the LoadFormulas method.
C# | Copy Code |
---|
FarPoint.Win.Spread.Model.DefaultSheetDataModel dm = default(FarPoint.Win.Spread.Model.DefaultSheetDataModel);
dm = (FarPoint.Win.Spread.Model.DefaultSheetDataModel)FarPoint.Win.Serializer.LoadObject(typeof(FarPoint.Win.Spread.Model.DefaultSheetDataModel), "c:\\test.xml", "rootnode");
dm.LoadFormulas(true);
fpSpread1.Sheets.Count = 1;
fpSpread1.Sheets[0].Models.Data = dm; |
Visual Basic | Copy Code |
---|
Dim dm As FarPoint.Win.Spread.Model.DefaultSheetDataModel
dm = FarPoint.Win.Serializer.LoadObject(GetType(FarPoint.Win.Spread.Model.DefaultSheetDataModel()), "c:\test.xml", "rootnode")
dm.LoadFormulas(True)
FpSpread1.Sheets.Count = 1
FpSpread1.Sheets(0).Models.Data = dm
|
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also