Skip to main content

IXlCell.SetFormula(String) Method

Assigns the specified formula string to a cell.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

void SetFormula(
    string formula
)

Parameters

Name Type Description
formula String

A string that is a formula contained in the cell.

Remarks

A spreadsheet formula is an equation that performs a calculation on data contained in worksheet cells. A string specified as the worksheet formula should conform to the formula syntax rules and contain only supported elements (refer to the Excel Export and Spreadsheet Document API Feature Comparison document for a list of supported features).

Before a formula is assigned to a cell, it is analyzed with a formula parser specified in the XlExport.CreateExporter method. If the use of named ranges (defined names) is detected or other unsupported elements are found, an exception is thrown.

If the parser is not specified, the export to the Excel 97-2003 (.xls) format fails because this format requires a parsed formula to assign to a cell. Export to OpenXml (.xlsx) format without a parser leaves the string formula unvalidated.

Example

Note

A complete sample project is available at https://github.com/DevExpress-Examples/excel-export-api-examples

// Create data rows using string formulas.
for (int i = 0; i < 4; i++) {
    using (IXlRow row = sheet.CreateRow()) {
        using (IXlCell cell = row.CreateCell()) {
            cell.Value = product[i];
        }
        using (IXlCell cell = row.CreateCell()) {
            cell.Value = qty[i];
        }
        using (IXlCell cell = row.CreateCell()) {
            cell.Value = price[i];
        }
        using (IXlCell cell = row.CreateCell()) {
            // Set the formula to calculate the amount per product.
            cell.SetFormula(String.Format("B{0}*C{0}", i + 2));
        }
    }
}

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the SetFormula(String) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also