MindFusion.Spreadsheet.WinForms.FillSeriesForm Class | WinForms Spreadsheet Control

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# Copy Code
public class FillSeriesForm : Form

Visual Basic Copy Code
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# Copy Code
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 Copy Code
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

Syntax

Remarks

Example

Inheritance Hierarchy

See Also