Class FillSeriesController

Represents the class that provides support for extending the selection and auto fill the cells with data that completes a pattern in the Selected region.

Inheritance
System.Object
FillSeriesController
Implements
System.IDisposable
Namespace: Syncfusion.UI.Xaml.Spreadsheet
Assembly: Syncfusion.SfSpreadsheet.WPF.dll
Syntax
public class FillSeriesController : Object, IFillOptionChanged, IDisposable
Remarks

Fills the selected range of cells in the spreadsheet with a series of numbers, characters, or dates. The content of the first cell in the selected range is used as the starting value for the series.

Constructors

FillSeriesController(SpreadsheetGrid)

Initializes a new instance of FillSeriesController Class with the specified SpreadsheetGrid

Declaration
public FillSeriesController(SpreadsheetGrid spreadsheetGrid)
Parameters
Type Name Description
SpreadsheetGrid spreadsheetGrid

An instance of SpreadsheetGrid

Properties

AllowFillSeries

Determines whether to allow fill series or copy series operation

Declaration
public bool AllowFillSeries { get; set; }
Property Value
Type Description
System.Boolean

True or False

FillOptionListPopup

Gets or sets the popup for various fill option list. When click on any option, it will re-update the filled range accordingly.

Declaration
protected Popup FillOptionListPopup { get; set; }
Property Value
Type
System.Windows.Controls.Primitives.Popup

FillOptionPopup

Gets or sets the popup for fill options. It will be opened after performing drag fill operation. When click on this popup, it will open FillOptionListPopup which contains list of fill options.

Declaration
protected Popup FillOptionPopup { get; set; }
Property Value
Type
System.Windows.Controls.Primitives.Popup

FillRange

Returns the range for which has to be filled.

Declaration
protected GridRangeInfo FillRange { get; set; }
Property Value
Type
GridRangeInfo

MoveDirection

Returns the MovingDirection of drag fill.

Declaration
protected MovingDirection MoveDirection { get; set; }
Property Value
Type
MovingDirection

OriginalRange

OriginalRange is the range which is obtained before filling the data.

Declaration
protected GridRangeInfo OriginalRange { get; set; }
Property Value
Type
GridRangeInfo

ShowFillOptions

Determines whether fill options popup will be displayed or not after drag fill operation.

Declaration
public bool ShowFillOptions { get; set; }
Property Value
Type
System.Boolean

Worksheet

Returns the IWorksheet of the SpreadsheetGrid.

Declaration
protected IWorksheet Worksheet { get; set; }
Property Value
Type
IWorksheet

Methods

CopyCells(GridRangeInfo, GridRangeInfo)

Copys the OldRange to newRange based on the fillOption

Declaration
protected virtual void CopyCells(GridRangeInfo oldRange, GridRangeInfo newRange)
Parameters
Type Name Description
GridRangeInfo oldRange

OldRange
GridRangeInfo newRange

NewRange that has been selected

Dispose()

Dispose all the resources used by the FillSeriesController class

Declaration
public void Dispose()

Dispose(Boolean)

Declaration
protected virtual void Dispose(bool disposing)
Parameters
Type Name Description
System.Boolean disposing

FillOptionChanged(String)

Determines the operation to be performed based on the selected fillseries option

Declaration
public void FillOptionChanged(string Content)
Parameters
Type Name Description
System.String Content

The option to determine the operation

FillSeries(GridRangeInfo, GridRangeInfo)

Fills the Selected range based upon the content of the cell Like Numbers, string, Formula or DateTime

Declaration
protected virtual void FillSeries(GridRangeInfo oldRange, GridRangeInfo newRange)
Parameters
Type Name Description
GridRangeInfo oldRange

OldRange
GridRangeInfo newRange

NewRange that has been selected

PointerPressed(MouseEventArgs)

Determines the pressed position of pointer of the FillSeriesController

Declaration
protected bool PointerPressed(MouseEventArgs e)
Parameters
Type Name Description
System.Windows.Input.MouseEventArgs e

The System.Windows.Input.MouseEventArgs that contains the event data
Returns
Type Description
System.Boolean

True or False

PointerReleased(MouseEventArgs)

Determines the released position of pointer of the FillSeriesController

Declaration
protected bool PointerReleased(MouseEventArgs e)
Parameters
Type Name Description
System.Windows.Input.MouseEventArgs e

The System.Windows.Input.MouseEventArgs that contains the event data
Returns
Type Description
System.Boolean

True or False

ProcessFillSeriesDragSelection(MouseEventArgs)

Determines the state of the mouse position and the selected range of the FillSeries

Declaration
public virtual bool ProcessFillSeriesDragSelection(MouseEventArgs e)
Parameters
Type Name Description
System.Windows.Input.MouseEventArgs e

The System.Windows.Input.MouseEventArgs that contains the event data
Returns
Type Description
System.Boolean

True or False

UnWireEvents()

Unwire the events associated with FillSeriesController

Declaration
protected virtual void UnWireEvents()

Implements

System.IDisposable