FillSeriesForm Class

A form which can be used to specify fill patterns for filling cell ranges with data.

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

 Syntax

C#

public class FillSeriesForm : Form

Visual Basic

Public Class FillSeriesForm
    Inherits Form

 Remarks

This form can be used to prompt the user for information about filling worksheet cells with data. To use the form, create an instance of the FillSeriesForm class by providing the target cell range, and call the ShowDialog method. The user's choice can be obtained from the FillType, FillDirection, FillDate, FillStep, FillStop, and FillTrend properties. The following image shows the form:

 Example

The code below demonstrates how to use the form to fill the cells in an existing worksheet with data.

C#

var form = new FillSeriesForm(cellRange);
if (form.ShowDialog(this) == DialogResult.OK)
{
    cellRange.FillData(form.FillType, form.FillDirection,
        form.FillDate, form.FillStep, form.FillStop, form.FillTrend);
}

Visual Basic

Dim form = New FillSeriesForm(cellRange)
If form.ShowDialog(Me) = DialogResult.OK Then

    cellRange.FillData(form.FillType, form.FillDirection,
        form.FillDate, form.FillStep, form.FillStop, form.FillTrend)

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.FillSeriesForm