ContextQMD
Back to Devexpress

How to: Use Names in Formulas

wpf-16371-controls-and-libraries-spreadsheet-examples-formulas-how-to-use-names-in-formulas.md

latest1.3 KB
Original Source

How to: Use Names in Formulas

  • Jun 07, 2019

This example demonstrates how to use a named cell range in a formula. In some cases, it can be useful to name individual cells and cell ranges to make it easier to understand what information they contain.

View Example

csharp
// Access the "A2:C5" range of cells in the worksheet.
CellRange range = worksheet.Range["A2:C5"];

// Specify the name for the created range.
range.Name = "myRange";

// Create a formula that sums up the values of all cells included in the specified named range.
worksheet.Cells["F3"].Formula = "= SUM(myRange)";
vb
' Access the "A2:C5" range of cells in the worksheet.
Dim range As CellRange = worksheet.Range("A2:C5")

' Specify the name for the created range.
range.Name = "myRange"

' Create a formula that sums up the values of all cells included in the specified named range.
worksheet.Cells("F3").Formula = "= SUM(myRange)"