ManageNamedRangesForm Class

Represents a form which can be used to create, edit and remove named cell ranges from a workbook.

Namespace: MindFusion.Spreadsheet.WinForms
Assembly: MindFusion.Spreadsheet.WinForms.StandardForms

 Syntax

C#

public class ManageNamedRangesForm : Form

Visual Basic

Public Class ManageNamedRangesForm
    Inherits Form

 Remarks

This form can be used to add, edit, and remove named ranges from a workbook. To use the form, create an instance of the ManageNamedRangesForm class, by providing the related workbook, and call the ShowDialog method. To apply the changes made through the form, call the Apply method. The following image shows the form:

 Example

The code below demonstrates how to display the form for an existing range of cells.

C#

var form = new ManageNamedRangesForm(workbook, cellRange);
if (form.ShowDialog(this) == DialogResult.OK)
{
    using (workbook.StartCompositeOperation())
        form.Apply(workbook);
}

Visual Basic

Dim form = New ManageNamedRangesForm(workbook, cellRange)
If form.ShowDialog(Me) = DialogResult.OK Then

    Using workbook.StartCompositeOperation()
        form.Apply(workbook)
    End Using

End If

 Inheritance Hierarchy

System.Object
    System.MarshalByRefObject
        System.ComponentModel.Component
            System.Windows.Forms.Control
                System.Windows.Forms.ScrollableControl
                    System.Windows.Forms.ContainerControl
                        System.Windows.Forms.Form
                            MindFusion.Spreadsheet.WinForms.ManageNamedRangesForm