Protects the worksheet with the specified password. Syntax Parameters password The password used to protect the Worksheet.allowEditStructure Optional boolean indicating the new value for the WorkbookProtection.AllowEditStructure.allowEditWindows Optional boolean indicating the new value for the WorkbookProtection....
Protects the worksheet with the specified password. Overload List
Gets or sets the value which indicates whether the workbook is protected. Syntax Property Value The value which indicates whether the workbook is protected. Remarks If True, prevents changes to worksheet and to locked cells.
Returns an object that provides information used when the Workbook has been protected. Syntax
Recalculates all dirty formulas pending a calculation on the workbook. Syntax Remarks This can be used when the CalculationMode is Manual. In Manual mode, when cells are dirtied, formulas referencing those cells will not be recalculated until Recalculate is called or RecalculateBeforeSave is True and the workbook ...
Recalculates all formulas on the workbook. Syntax Parameters includeNonDirtyFormulas True to recalculate all formulas on the workbook regardless of whether they had a pending evaluation. False to only calculate dirty formulas. Remarks This can be used when the CalculationMode is Manual. In Manual mode, when cells ...
Recalculates all dirty formulas pending a calculation on the workbook. Overload List
Gets or sets the value which indicates whether the workbook should recalculate all formulas before saving. Syntax Property Value The value which indicates whether the workbook should recalculate all formulas before saving. Remarks This property only applies if the CalculationMode is set to Manual. Otherwise, it is...
Registers a single Infragistics.Documents.Excel.CalcEngine.ExcelCalcFunction instance. Syntax Parameters userDefinedFunction User defined function instance to register Return Value Returns true if the type was registered successfully, else false if the registration failed Remarks Users can build custom functions u...
Registers an assembly containing Infragistics.Documents.Excel.CalcEngine.ExcelCalcFunction derived types. Syntax Parameters assembly Loaded assembly to register Return Value Returns true if the assembly was registered successfully, else false if the registration failed Remarks All types within the registered assem...