Spread WinForms 15
Spread Windows Forms 15.0 Product Documentation / Developer's Guide / Formulas in Cells / Setting up the Name Box
In This Topic
Setting up the Name Box
In This Topic

You can use the name box control to display or create custom names at run time. Custom names that are created by the name box can only refer to a cell or a range of cells.

Setting up the Name Box

Select the name box control from the Toolbox and draw it on the form or use the NameBox class to create the control at runtime. Then attach the control to Spread. The following image displays the NameBox control in the toolbox.

Name Box Control

Using the Name Box

To create a custom name, select a cell or range of cells in the Spread control, type a custom name in the name box control, and then press the equal key to create the custom name.

Use the drop-down list in the name box control to display the custom names. You can select one of the names to see the cell or cell range that the name refers to.

Custom names in the Name Box Control

Using Code

Create the name box and attach it to the control.

Example

This example code creates a name box control and a custom name.

C#
Copy Code
fpSpread1.ActiveSheet.AddCustomName("Alpha", "A1:B1", 0, 0);
                
                FarPoint.Win.Spread.NameBox namebox1 = new FarPoint.Win.Spread.NameBox();
                namebox1.Location = new Point(0, 0);
                namebox1.Size = new Size(80, 20);
                this.Controls.Add(namebox1);
                namebox1.Attach(fpSpread1);
VB
Copy Code
fpSpread1.ActiveSheet.AddCustomName("Alpha", "A1:B1", 0, 0)
                
                Dim namebox1 As New FarPoint.Win.Spread.NameBox()
                namebox1.Location = New Point(0, 0)
                namebox1.Size = New Size(80, 20)
                Controls.Add(namebox1)
                namebox1.Attach(fpSpread1)
See Also