FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetDataModel Class : RemoveCustomName Method |
'Usage Dim instance As DefaultSheetDataModel Dim name As String instance.RemoveCustomName(name)
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(10, 10) Dim dlg As DialogResult dataModel.AddCustomName("TWICESUM", "2*SUM(A1,A2)", 1, 1) dataModel.SetFormula(1, 1, "TWICESUM") dataModel.SetValue(0, 0, 10) dataModel.SetValue(1, 0, 10) FpSpread1.ActiveSheet.Models.Data = dataModel dlg = MessageBox.Show("Do you want to remove a custom name??", "RemoveCustomName", MessageBoxButtons.YesNo) If dlg = DialogResult.Yes Then dataModel.RemoveCustomName("TWICESUM") dataModel.RecalculateAll() End If
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5); DialogResult dlg; dataModel.AddCustomName("TWICESUM", "2*SUM(A1,A2)", 1, 1); dataModel.SetFormula(1, 1, "TWICESUM"); dataModel.SetValue(0, 0, 10); dataModel.SetValue(1, 0, 10); fpSpread1.ActiveSheet.Models.Data = dataModel; dlg = MessageBox.Show("Do you want to remove a custom name??", "RemoveCusotmName", MessageBoxButtons.YesNo); if (dlg == DialogResult.Yes) { dataModel.RemoveCustomName("TWICESUM"); dataModel.RecalculateAll(); }
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10