MindFusion.Wpf Pack Programmer's Guide
CellRange Members
Properties Methods
 


Identifies a range of cells in a Worksheet.

The following tables list the members exposed by the CellRange type.

 Public Properties

  Name Description

Bottom

Gets the bottom side of the range.

ConditionalFormats

Gets a list with format objects that can be used to customize the appearance of the cells in the range based on various conditions.

Left

Gets the left side of the range.

Right

Gets the right side of the range.

Style

Gets an IStyle object that can be used to customize the appearance of all cells in the range.

Top

Gets the top side of the range.

Validation

Gets an IValidation object that can be used to specify validation rules for the data in the cell range.

 Public Methods

  Name Description

AutoFill

Automatically fills the values of the cells in the specified range based on the values of the cells in this range.

AutoFilter

Overloaded. Enables or toggles autofiltering.

Clear

Clears the content of the cells in this range.

FillData

Fills the data in this range according to the current data and the specified options.

GetEnumerator

Returns an enumerator object that can be used to iterate through the cells in the range.

Insert

Inserts new cells in the current range of cells. The existing cells are pushed down or right based on the value of direction.

Merge

Merges the cells in this range into a single cell.

MoveTo

Overloaded. Moves the data from the current range to another location.

Remove

Remove the cells in the current range of cells.

Reset

Clears the contents of the cells in the range, as well as their associated styles, hyperlinks, annotations, conditional formatting and data validations.

Sort

Sorts the data in this range according to the specified options.

ToString

Object.ToString override.

Unmerge

Unmerges all merged cells intersecting with this range.

 See Also

CellRange Class
MindFusion.Spreadsheet.Wpf Namespace