GrapeCity.Windows.SpreadSheet.Data Namespace > Worksheet Class > SetCustomName Method : SetCustomName(String,Int32,Int32,String) Method |
'Declaration Public Overloads Sub SetCustomName( _ ByVal name As System.String, _ ByVal baseRow As System.Integer, _ ByVal baseColumn As System.Integer, _ ByVal formula As System.String _ )
'Usage Dim instance As Worksheet Dim name As System.String Dim baseRow As System.Integer Dim baseColumn As System.Integer Dim formula As System.String instance.SetCustomName(name, baseRow, baseColumn, formula)
public void SetCustomName( System.string name, System.int baseRow, System.int baseColumn, System.string formula )
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)");
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)")
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6