ContextQMD
Back to Devexpress

How to: Create Shared Formulas

wpf-16374-controls-and-libraries-spreadsheet-examples-formulas-how-to-create-shared-formulas.md

latest1.2 KB
Original Source

How to: Create Shared Formulas

  • Jun 07, 2019

This example demonstrates how to apply a shared formula in a range of cells to avoid duplicating the same formula for each cell in the range, and reduce the size of the spreadsheet file. To do this, assign the formula string to the CellRange.Formula property of the cell range. The shared formula will be created and applied automatically.

View Example

csharp
worksheet.Cells["A2"].Value = 1;

// Use the shared formula in the "A3:A11" range of cells.
worksheet.Range["A3:A11"].Formula = "=SUM(A2+1)";

// Use the shared formula in the "B2:B11" range of cells.
worksheet.Range["B2:B11"].Formula = "=A2+2";
vb
worksheet.Cells("A2").Value = 1

' Use the shared formula in the "A3:A11" range of cells.
worksheet.Range("A3:A11").Formula = "=SUM(A2+1)"

' Use the shared formula in the "B2:B11" range of cells.
worksheet.Range("B2:B11").Formula = "=A2+2"