FillSeriesForm Class

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

Namespace: MindFusion.Spreadsheet.Wpf.StandardForms
Assembly: MindFusion.Spreadsheet.Wpf.StandardForms

 Syntax

C#

public class FillSeriesForm : Window, INotifyPropertyChanged, IComponentConnector

Visual Basic

Public Class FillSeriesForm
    Inherits Window
    Implements INotifyPropertyChanged, IComponentConnector

 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) == true)
{
    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) = True Then

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

End If

 Inheritance Hierarchy

System.Object
    System.Windows.Threading.DispatcherObject
        System.Windows.DependencyObject
            System.Windows.Media.Visual
                System.Windows.UIElement
                    System.Windows.FrameworkElement
                        System.Windows.Controls.Control
                            System.Windows.Controls.ContentControl
                                System.Windows.Window
                                    MindFusion.Spreadsheet.Wpf.StandardForms.FillSeriesForm