21.2
21.1
20.2
20.1
19.2
19.1
18.2
18.1
17.2

# IXlCell.SetSharedFormula(XlCellPosition) Method

Creates the shared formula based on the formula contained in the host cell.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v21.2.Core.dll

## Declaration

``````void SetSharedFormula(
XlCellPosition hostCell
)``````

## Parameters

Name Type Description
hostCell XlCellPosition

An XlCellPosition structure that determines a cell which contains the host formula.

## Example

It takes two steps to build a shared formula. First, add a formula to the first cell in a range - it is the host formula. Next, add a reference to the host formula to any other cell of the range. The IXlCell.SetSharedFormula method with different parameters serves both steps, as illustrated in the code below.

``````// Create data rows.
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()) {
// Use the shared formula to calculate the amount per product.
if (i == 0)
cell.SetSharedFormula("B2*C2", XlCellRange.FromLTRB(3, 1, 3, 4));
else
cell.SetSharedFormula(new XlCellPosition(3, 1));
}
}
}
``````

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the SetSharedFormula(XlCellPosition) 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.