MSDN Library

Web Development

SharePoint Products and Technologies

SharePoint 2010

SDK Documentation

SharePoint 2010 Class Libraries and Web Service References

SharePoint Foundation 2010 Class Libraries

Core Class Library

Microsoft.SharePoint

DefaultItemOpen Enumeration

DraftVisibilityType Enumeration

ExternalSecurityWebProperty Structure

IAlertNotifyHandler Interface

IAlertUpdateHandler Interface

IAuditLogTrimmingCallout Interface

IContextInitialize Interface

IConverterForPostProcessor Interface

IExternalSecurityWeb Interface

IFileDialogPostProcessor Interface

IFileDialogPostProcessor2 Interface

IListEventSink Interface

IRequestResources Interface

ISecurableObject Interface

ISPConversionProcessor Interface

ISPEventReceiversHost Interface

ITopologyWebServiceApplication Interface

NameValuePair Class

OfficialFileResult Enumeration

PAGETYPE Enumeration

RecordsRepositoryProperty Class

RequestResources Enumeration

SPAddFieldOptions Enumeration

SPAdministrationSiteType Enumeration

SPAlert Class

SPAlertCollection Class

SPAlertDeliveryChannels Enumeration

SPAlertEventData Structure

SPAlertFrequency Enumeration

SPAlertHandlerParams Structure

SPAlertStatus Enumeration

SPAlertTemplate Class

SPAlertTemplateCollection Class

SPAlertType Enumeration

SPAttachmentCollection Class

SPAudit Class

SPAuditEntry Class

SPAuditEntryCollection Class

SPAuditEventSource Enumeration

SPAuditEventType Enumeration

SPAuditItemType Enumeration

SPAuditLocationType Enumeration

SPAuditMaskType Enumeration

SPAuditQuery Class

SPBaseCollection Class

SPBasePermissions Enumeration

SPBaseType Enumeration

SPBrowserFileHandling Enumeration

SPBuiltInContentTypeId Class

SPBuiltInFieldId Class

SPBusinessDataField Class

SPCalculationOptions Enumeration

SPCalendarOrderType Enumeration

SPCalendarType Enumeration

SPCalendarViewStyle Class

SPCalendarViewStyleCollection Class

SPChange Class

SPChangeAlert Class

SPChangeCollection Class

SPChangeCollection.CollectionScope Enumeration

SPChangeContentType Class

SPChangeField Class

SPChangeFile Class

SPChangeFolder Class

SPChangeGroup Class

SPChangeItem Class

SPChangeList Class

SPChangeQuery Class

SPChangeSecurityPolicy Class

SPChangeSite Class

SPChangeToken Class

SPChangeTokenCollection Class

SPChangeType Enumeration

SPChangeUser Class

SPChangeView Class

SPChangeWeb Class

SPChannelFactoryOperations Class

SPCheckedOutFile Class

SPCheckinType Enumeration

SPChoiceFormatType Enumeration

SPCompositeIndexableStatus Enumeration

SPContentType Class

SPContentTypeCollection Class

SPContentTypeId Structure

SPContentTypeReadOnlyException Class

SPContentTypeSealedException Class

SPContentTypeUsage Class

SPContext Class

SPContext.GetCachedField Delegate

SPContext.SetCachedField Delegate

SPContextPageInfo Class

SPCopyDestination Class

SPCopyDestinationCollection Class

SPCopyDestinationType Enumeration

SPCopyErrorCode Enumeration

SPCopyFieldInformation Class

SPCopyFieldMask Class

SPCurrencyFieldFormats Enumeration

SPCustomizedPageStatus Enumeration

SPCustomWebTemplate Class

SPDailySchedule Class

SPDataRetrievalServicesSettings Class

SPDateTimeFieldFormatType Enumeration

SPDistributionGroupException Class

SPDistributionGroupJobData Class

SPDistributionGroupJobType Enumeration

SPDocDiscussion Class

SPDocDiscussionCollection Class

SPDocTemplate Class

SPDocTemplateCollection Class

SPDocumentLibrary Class

SPDuplicateValuesFoundException Class

SPEmailEventReceiver Class

SPEncodedResourceExpressionBuilder Class

SPEndpointAddressNotFoundException Class

SPEvaluatorModeProvisioner Class

SPEvaluatorModeProvisioning Class

SPEventContext Class

SPEventHostType Enumeration

SPEventPropertiesBase Class

SPEventReceiverBase Class

SPEventReceiverDefinition Class

SPEventReceiverDefinitionCollection Class

SPEventReceiverStatus Enumeration

SPEventReceiverSynchronization Enumeration

SPEventReceiverType Enumeration

SPEventType Enumeration

SPException Class

SPExceptionEventArgs Class

SPExecutingConversionRequest Class

SPExternalApplicationRegistrationException Class

SPExternalApplicationRegistrationInformation Class

SPExternalApplicationRequestProperties Class

SPExternalApplicationRequestResult Class

SPExternalBinaryId Class

SPExternalBinaryIdCollection Class

SPFeature Class

SPFeatureCollection Class

SPFeatureDefinitionMissingException Class

SPFeatureDefinitionScope Enumeration

SPFeatureDependency Class

SPFeatureDependencyCollection Class

SPFeatureDependencyNotActivatedException Class

SPFeatureIsOrphanedException Class

SPFeatureProperty Class

SPFeaturePropertyCollection Class

SPFeatureQueryResultCollection Class

SPFeatureReceiver Class

SPFeatureReceiverProperties Class

SPFeatureScope Enumeration

SPFeatureUpgradeFatalErrorException Class

SPFeatureUpgradeInformativeWarningException Class

SPField Class

SPField.ListItemMenuState Enumeration

SPFieldAllDayEvent Class

SPFieldAttachments Class

SPFieldBoolean Class

SPFieldCalculated Class

SPFieldChoice Class

SPFieldCollection Class

SPFieldCollection.CreateSPFieldCallback Delegate

SPFieldComputed Class

SPFieldCrossProjectLink Class

SPFieldCurrency Class

SPFieldDateTime Class

SPFieldDecimal Class

SPFieldFile Class

SPFieldGuid Class

SPFieldIndex Class

SPFieldIndexCollection Class

SPFieldLink Class

SPFieldLinkCollection Class

SPFieldLookup Class

SPFieldLookupValue Class

SPFieldLookupValueCollection Class

SPFieldModStat Class

SPFieldMultiChoice Class

SPFieldMultiChoiceValue Class

SPFieldMultiColumn Class

SPFieldMultiColumnValue Class

SPFieldMultiLineText Class

SPFieldNumber Class

SPFieldPageSeparator Class

SPFieldRatingScale Class

SPFieldRatingScaleValue Class

SPFieldRecurrence Class

SPFieldTemplateUsage Class

SPFieldText Class

SPFieldType Enumeration

SPFieldTypeDefinition Class

SPFieldTypeDefinitionCollection Class

SPFieldUrl Class

SPFieldUrlValue Class

SPFieldUser Class

SPFieldUserSelectionMode Enumeration

SPFieldUserValue Class

SPFieldUserValueCollection Class

SPFieldValidationException Class

SPFieldValueException Class

SPFieldWorkflowStatus Class

SPFile Class

SPFile.CustomFileSubmissionPostProcessing Delegate

SPFile.SPCheckOutStatus Enumeration

SPFile.SPCheckOutType Enumeration

SPFile.SPLockType Enumeration

SPFileCheckOutException Class

SPFileCheckOutExceptionType Enumeration

SPFileCollection Class

SPFileCollectionAddParameters Class

SPFileConversionResult Enumeration

SPFileConversionState Enumeration

SPFileLevel Enumeration

SPFileLockException Class

SPFileLockExceptionType Enumeration

SPFileSaveBinaryParameters Class

SPFileStream Class

SPFileSystemObjectType Enumeration

SPFileVersion Class

SPFileVersionCollection Class

SPFolder Class

SPFolderCollection Class

SPForm Class

SPFormCollection Class

SPFormContext Class

SPGroup Class

SPGroupCollection Class

SPHourlySchedule Class

SPHtmlEncodedResourceExpressionBuilder Class

SPInvalidLookupValuesException Class

SPInvalidPropertyException Class

SPIssueList Class

SPIssueList.ReportType Enumeration

SPItem Class

SPItemEventDataCollection Class

SPItemEventProperties Class

SPItemEventReceiver Class

SPLanguage Class

SPLanguageCollection Class

SPLink Class

SPLinkCollection Class

SPList Class

SPListCategoryType Enumeration

SPListCollection Class

SPListDataSource Class

SPListDataSource.BDCProperties Class

SPListDataValidationException Class

SPListDataValidationException.SPFailure Class

SPListDataValidationException.SPReason Enumeration

SPListDataValidationException.SPValidationType Enumeration

SPListEvent Class

SPListEventProperties Class

SPListEventReceiver Class

SPListEventType Enumeration

SPListGetDataTableOptions Enumeration

SPListItem Class

SPListItemCollection Class

SPListItemCollectionPosition Class

SPListItemInfo Class

SPListItemVersion Class

SPListItemVersionCollection Class

SPListTemplate Class

SPListTemplate.QuickLaunchOptions Enumeration

SPListTemplateCollection Class

SPListTemplateType Enumeration

SPLocale Class

SPLocaleCollection Class

SPLocalizationCollection Class

SPLongOperation Class

SPLongOperation.BeginOperation Delegate

SPLongOperationState Class

SPMember Class

SPMemberCollection Class

SPMinuteSchedule Class

SPMobileContext Class

SPModerationInformation Class

SPModerationStatusType Enumeration

SPModule Class

SPModule.SPModulePropertyBag Class

SPModuleCollection Class

SPMonthlyByDaySchedule Class

SPMonthlySchedule Class

SPMoveOperations Enumeration

SPNumberFormatTypes Enumeration

SPObjectType Enumeration

SPOfficialFileAction Enumeration

SPOfficialFileHost Class

SPOfficialFileSubmissionMode Enumeration

SPOneTimeSchedule Class

SPOpenBinaryOptions Enumeration

SPPermission Class

SPPermissionCollection Class

SPPermissionGroup Enumeration

SPPermissionGroup64 Enumeration

SPPermissionInfo Class

SPPictureLibrary Class

SPPreviewValueSize Enumeration

SPPrincipal Class

SPQuery Class

SPQueryThrottledException Class

SPQueryThrottleOption Enumeration

SPRecycleBinItem Class

SPRecycleBinItemCollection Class

SPRecycleBinItemCollectionPosition Class

SPRecycleBinItemState Enumeration

SPRecycleBinItemType Enumeration

SPRecycleBinOrderBy Enumeration

SPRecycleBinQuery Class

SPRecycleBinType Enumeration

SPRegionalSettings Class

SPRelatedField Class

SPRelatedFieldCollection Class

SPRelationshipDeleteBehavior Enumeration

SPRequestContext Class

SPResource Class

SPResourceExpressionBuilder Class

SPResourceScope Enumeration

SPResourceType Enumeration

SPReusableAcl Class

SPRichTextMode Enumeration

SPRights Enumeration

SPRole Class

SPRoleAssignment Class

SPRoleAssignmentCollection Class

SPRoleCollection Class

SPRoleDefinition Class

SPRoleDefinitionBindingCollection Class

SPRoleDefinitionCollection Class

SPRoleType Enumeration

SPRoundRobinServiceLoadBalancer Class

SPRoundRobinServiceLoadBalancerContext Class

SPSchedule Class

SPSearchResult Class

SPSearchResultCollection Class

SPSearchResultCollectionPosition Class

SPSecurableObject Class

SPSecurity Class

SPSecurity.CodeToRunElevated Delegate

SPSecurity.SuppressAccessDeniedRedirectInScope Class

SPSecurityContext Class

SPServiceAuthenticationMode Enumeration

SPServiceContext Class

SPServiceContextScope Class

SPServiceHostOperations Class

SPServiceLoadBalancer Class

SPServiceLoadBalancerContext Class

SPServiceLoadBalancerStatus Enumeration

SPSimpleFormattingEncodedResourceExpressionBuilder Class

SPSimpleItem Class

SPSite Class

SPSite.StorageManagementInformationType Enumeration

SPSite.StorageManagementSortedOn Enumeration

SPSite.StorageManagementSortOrder Enumeration

SPSite.UsageInfo Structure

SPSite.WebVisualReport Class

SPSiteDataQuery Class

SPSiteSolutionDailyResourceUsageRecord Class

SPSiteSolutionResourceUsageQuotaRecord Class

SPSiteSubscription Class

SPSiteSubscriptionCollection Class

SPSiteSubscriptionFeaturePack Class

SPSiteSubscriptionFeaturePackCollection Class

SPSiteSubscriptionIdentifier Class

SPSiteSubscriptionPropertyCollection Class

SPSiteSubscriptionSettings Class

SPSiteSubscriptionSettingsManager Class

SPSiteSubscriptionSettingsObject Class

SPSiteSubscriptionSiteCollection Class

SPSolutionExporter Class

SPSolutionExporter.ExportMode Enumeration

SPSolutionResourceUsageAggregator Class

SPSolutionResourceUsageAggregatorCount Class

SPSolutionResourceUsageAggregatorCountWeightedMean Class

SPSolutionResourceUsageAggregatorMean Class

SPSolutionResourceUsageAggregatorSum Class

SPSolutionResourceUsageAggregatorTimeWeightedMean Class

SPSolutionResourceUsageLog Class

SPSolutionResourceUsageRecord Class

SPStatefulLongOperation Class

SPStatefulLongOperation.BeginStatefulOperation Delegate

SPStatefulLongOperation.RunStatefulOperation Delegate

SPSystemTime Structure

SPTabularViewUpgradeInfo Class

SPTemplateFileType Enumeration

SPTimeZone Class

SPTimeZoneCollection Class

SPTimeZoneInformation Structure

SPTopologyWebServiceApplicationFault Class

SPTransformCacheType Enumeration

SPTransformServer Class

SPTransformUtilities Class

SPULSTraceListener Class

SPUrlFieldFormatType Enumeration

SPUser Class

SPUserCollection Class

SPUserCustomAction Class

SPUserCustomActionCollection Class

SPUserCustomActionRegistrationType Enumeration

SPUserCustomActionScope Enumeration

SPUserInfo Structure

SPUserResource Class

SPUserResourceCollection Class

SPUserSolution Class

SPUserSolutionCollection Class

SPUserSolutionStatus Enumeration

SPUserStorage Class

SPUserStorageCollection Class

SPUserToken Class

SPView Class

SPViewCollection Class

SPViewCollection.SPViewType Enumeration

SPViewContext Class

SPViewFieldCollection Class

SPViewFlags Enumeration

SPViewScope Enumeration

SPViewStyle Class

SPViewStyleCollection Class

SPVirusCheckStatus Enumeration

SPWeb Class

SPWeb.WebAnonymousState Enumeration

SPWebCollection Class

SPWebEventProperties Class

SPWebEventReceiver Class

SPWebInfo Class

SPWebListInfo Class

SPWebPartCollection Class

SPWebProvisioningProperties Class

SPWebProvisioningProvider Class

SPWebTemplate Class

SPWebTemplate.TeamCollaborationSiteConfiguration Enumeration

SPWebTemplate.WebTemplate Enumeration

SPWebTemplateCollection Class

SPWeeklySchedule Class

SPWikiPageHomePageFeatureReceiver Class

SPWikiWelcomeFeatureReceiver Class

SPWorkItem Class

SPWorkItemCollection Class

SPWorkItemStatus Enumeration

SPXmlDocumentCollection Class

SPYearlySchedule Class

SubscriptionSendToConnectionsCache Class

TriState Enumeration

WebASPXPageIndexMode Enumeration

WeekOfMonth Enumeration

WffRequestType Enumeration

Community Content

Add code samples and tips to enhance this topic.

More...

This topic has not yet been rated - Rate this topic

SPCalculationOptions Enumeration

SharePoint 2010

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

Copy

[FlagsAttribute]
[SubsetCallableExcludeMemberAttribute(SubsetCallableExcludeMemberType.UnsupportedSPType)]
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.

Reference

Microsoft.SharePoint Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

Annotations

FAQ

© 2012 Microsoft. All rights reserved.

Terms of Use | Trademarks | Privacy Statement | Site Feedback Site Feedback

Site Feedback

x

Tell us about your experience...

Did the page load quickly?

Yes No

Do you like the page design?

Yes No

Tell us more