Custom, user-defined names are identifiers that represent information in the sheet. A custom name can refer to a range of cells or a formula. You can define a custom name and then use the name in formulas. When the formula is evaluated, the custom name's value is referenced and evaluated. Use the SetCustomName method to create a custom name.
The following example creates custom names and uses them in formulas.
| CS |
Copy Code |
|---|---|
gcSpreadSheet1.Sheets[0].SetValue(0, 0, 1); gcSpreadSheet1.Sheets[0].SetValue(0, 1, 2); gcSpreadSheet1.Sheets[0].SetValue(0, 2, 3); gcSpreadSheet1.Sheets[0].SetCustomName("customName1", 0, 0, new CalcDoubleExpression(12)); gcSpreadSheet1.Sheets[0].SetCustomName("customName2", 0, 0, "Average(20,45)"); gcSpreadSheet1.Sheets[0].SetCustomName("customName3", 0, 0, 1, 3); gcSpreadSheet1.Sheets[0].SetFormula(1, 0, "customName1"); gcSpreadSheet1.Sheets[0].SetFormula(1, 1, "customName2"); gcSpreadSheet1.Sheets[0].SetFormula(1, 2, "sum(customName3)"); | |
| VB.NET |
Copy Code |
|---|---|
GcSpreadSheet1.Sheets(0).SetValue(0, 0, 1) GcSpreadSheet1.Sheets(0).SetValue(0, 1, 2) GcSpreadSheet1.Sheets(0).SetValue(0, 2, 3) GcSpreadSheet1.Sheets(0).SetCustomName("customName1", 0, 0, New CalcDoubleExpression(12)) GcSpreadSheet1.Sheets(0).SetCustomName("customName2", 0, 0, "Average(20,45)") GcSpreadSheet1.Sheets(0).SetCustomName("customName3", 0, 0, 1, 3) GcSpreadSheet1.Sheets(0).SetFormula(1, 0, "customName1") GcSpreadSheet1.Sheets(0).SetFormula(1, 1, "customName2") GcSpreadSheet1.Sheets(0).SetFormula(1, 2, "sum(customName3)") | |