SPCalculationOptions Enumeration

Enumerator that indicates options for how calculated field formulas, list data, validation formulas, and default value formulas are evaluated.

This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

Namespace:  Microsoft.SharePoint
Assembly:  Microsoft.SharePoint (in Microsoft.SharePoint.dll)
Available in Sandboxed Solutions: Yes
Available in SharePoint Online


<FlagsAttribute> _
<SubsetCallableExcludeMemberAttribute(SubsetCallableExcludeMemberType.UnsupportedSPType)> _
Public Enumeration SPCalculationOptions
Dim instance As SPCalculationOptions
public enum SPCalculationOptions


Member name Description
None Enumerator value = 0x0 indicates that no options are specified.
PreserveEmptyValues Enumerator value = 0x1 indicates that empty field values should be propagated through calculations which are more consistent with calculations in relational databases. If this option is not specified empty field values can be coerced to zero or false.
StrictTypeCoercion Enumerator value = 0x2 indicates that formulas requiring coercion from one data type to another or comparisons between different data types should return error values instead of attempting the conversion.

See Also


Microsoft.SharePoint Namespace