The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

DocumentSettings Interface

Contains workbook options related to formula calculation.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

public interface DocumentSettings
Public Interface DocumentSettings
public interface DocumentSettings
Public Interface DocumentSettings

Remarks

To access an object exposing the DocumentSettings interface, use the DocumentSettings property of the IWorkbook or Workbook object.

The notation for WinForms and WPF controls is as follows:


SpreadsheetControl.Document.DocumentSettings

Examples

This example demonstrates how to create formulas using the R1C1 reference style. To do this, switch on the DocumentSettings.R1C1ReferenceStyle option and assign a formula string containing R1C1 cell references to the Range.Formula property. To obtain a cell reference in the R1C1 reference style, you can use the Range.GetReferenceR1C1 method.

// Switch on the R1C1 reference style in a workbook.
workbook.DocumentSettings.R1C1ReferenceStyle = true;

// Specify a formula with relative R1C1 references in cell D2
// to add values contained in cells A2 through A11.
worksheet.Cells["D2"].Formula = "=SUM(RC[-3]:R[9]C[-3])";

// Specify a formula with absolute R1C1 references 
// to add values contained in cells A2 through A11.
worksheet.Cells["D3"].Formula = "=SUM(R2C1:R11C1)";
See Also