Setting up the Name Box

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.

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.

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);

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)

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)