HeaderSizeForm Class

Represents a form that can be used to define row height or column width within a worksheet.

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

 Syntax

C#

public class HeaderSizeForm : Form

Visual Basic

Public Class HeaderSizeForm
    Inherits Form

 Remarks

This form can be used to prompt the user for the size of the column and row headers in a worksheet. To use the form, create an instance of the HeaderSizeForm class, optionally providing the title and label texts, and call the ShowDialog method. The user's choice can be obtained from the HeaderSize property. The following image shows the form:

 Example

The code below demonstrates how to use the form to resize a row in an existing worksheet.

C#

var form = new HeaderSizeForm("Row Height", "Height", row.Height);
if (form.ShowDialog(this) == DialogResult.OK)
{
    using (workbook.StartChangeOperation(worksheet))
        row.Height = form.HeaderSize;
}

Visual Basic

Dim form = New HeaderSizeForm("Row Height", "Height", row.Height)
If form.ShowDialog(Me) = DialogResult.OK Then

    Using workbook.StartChangeOperation(worksheet)
        row.Height = form.HeaderSize
    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.HeaderSizeForm