com.mindfusion.spreadsheet.CellRange Members

CellRange Members

CollapseAll image

Members Options: Show All

Include Inherited Members
Include Protected Members

General Information

What's New in this Release

Version History

Programming Interface Overview

com.mindfusion.common

com.mindfusion.drawing

com.mindfusion.graphs

com.mindfusion.pdf

com.mindfusion.spreadsheet

ActivationEvent Class

AddItemCommand(T) Class

AdjustmentHandles Enumeration

Annotation Class

ArrowActions Enumeration

AutoFilter Class

AutoFilterChangedEvent Class

AutoFilterOperator Enumeration

CalcExporter Class

CalcImporter Class

CellAnnotation Class

CellChangeContext Enumeration

CellChangedEvent Class

CellCollection Class

CellEvent Class

CellIndex Class

CellMouseEvent Class

CellParsingEvent Class

CellRange Class

CellRange Members

CellRange Methods

CellRangeCollection Class

CellRangeEvent Class

CellRepainterListener Interface

CellsEvent Class

CellsInsertedEvent Class

CellsMovedEvent Class

CellsRemovedEvent Class

CellsSortedEvent Class

CellStorageEvent Class

CellValidationEvent Class

ChangeWorksheetCommand Class

CollectionChangedAction Enumeration

CollectionChangedEvent Class

CollectionListener Interface

ColumnChangedEvent Class

ColumnCollection Class

ColumnEvent Class

ColumnMouseEvent Class

ColumnRange Class

ColumnRangeEvent Class

ColumnsEvent Class

ColumnsMovedEvent Class

ColumnsRemovedEvent Class

ComparisonOperator Enumeration

CompositeCommand Class

ConditionalFormatType Enumeration

Converter Class

CsvExporter Class

CsvImporter Class

CurrencyCodeInfo Class

CurrencyCodes Class

CursorHint Enumeration

DataObjectTransferable Class

DefaultNumericFormats Class

DisposableCommand Class

DrawCellEvent Class

DrawColumnEvent Class

DrawRowEvent Class

DropDownEventObject Class

DropDownSelectionEventObject Class

DynamicFilterType Enumeration

ExcelExporter Class

ExcelImporter Class

ExternalizableImage Class

FillDate Enumeration

FillDirection Enumeration

FillType Enumeration

FindWithin Enumeration

FormattedText Class

FormulaTextBoxListener Interface

HorizontalAlignment Enumeration

HtmlExporter Class

HtmlExporterBase Class

Hyperlink Class

HyperlinkType Enumeration

IColumnStyle Interface

IConditionalFormat Interface

IConditionalFormatCollection Interface

IHasName Interface

IInplaceEditable Interface

ImageExporter Class

INotifyPropertyValueChanged Interface

InplaceEditEvent Class

InplaceEditValidationEvent Class

InteractiveObject Class

IRowStyle Interface

IStyle Interface

IValidation Interface

Localization Class

LookIn Enumeration

MeasureUnit Class

MergedCellsCollection Class

MetaTagNames Class

MhtmlExporter Class

MoveItemCommand(T) Class

NamedCollection(T) Class

NamedCollectionListener(T) Interface

NamedRange Class

NamedRangeCollection Class

NumericFormatInfo Class

ObjectAnchor Enumeration

ObjectAnchorPosition Enumeration

ObjectChangedEvent Class

ObjectEvent Class

ObjectInteractionEvent Class

ObjectInteractionValidationEvent Class

ObjectMouseEvent Class

ObjectValidationEvent Class

OffscreenContext Class

OutlineEvent Class

PageOrder Enumeration

PasteToMerged Enumeration

PdfExporter Class

PrintOptions Class

PrintPreview Class

PushDirection Enumeration

RemoveItemCommand(T) Class

RenderContext Class

ReplaceItemCommand(T) Class

ResetCollectionCommand(T) Class

Rotate Enumeration

RowChangedEvent Class

RowCollection Class

RowMouseEvent Class

RowRangeEvent Class

RowReceiver Interface

RowsEvent Class

RowsMovedEvent Class

RowsRemovedEvent Class

SearchDirection Enumeration

SearchOrder Enumeration

Selection Class

SelectionAdapter Class

SelectionListener Interface

SelectionType Enumeration

SerializeColumnTagEvent Class

SerializeDataEvent Class

SerializeRowTagEvent Class

SerializeTagEvent Class

ShiftDirection Enumeration

SortDirection Enumeration

SortOptions Class

SortOrder Enumeration

StateButtonListener Interface

StyleChangedEvent Class

StyleData Class

TabAdapter Class

TabAlignment Enumeration

TabListener Interface

TimeSpanUtilities Class

TrackChangesCommand Class

UndoableCollection(T) Class

UndoEvent Class

ValidationErrorAction Enumeration

ValidationFailedEvent Class

ValidationType Enumeration

VerticalAlignment Enumeration

ViewListener Interface

WorkbookAdapter Class

WorkbookListener Interface

WorkbookView Class

WorkbookViewAdapter Class

WorkbookViewListener Interface

Worksheet Class

WorksheetAdapter Class

WorksheetChangedEvent Class

WorksheetCollection Class

WorksheetEvent Class

WorksheetListener Interface

WorksheetMouseEvent Class

WorksheetValidationEvent Class

WorksheetView Class

WorksheetViewAdapter Class

WorksheetViewListener Interface

XmlContext Class

com.mindfusion.spreadsheet.charts

com.mindfusion.spreadsheet.expressions

com.mindfusion.spreadsheet.standardforms

Function Reference

Technical Support

MindFusion Products

Identifies a range of cells in a Worksheet.

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

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.
	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.
	getBottom	Gets the bottom side of the range.
	getConditionalFormats	Gets a list with format objects that can be used to customize the appearance of the cells in the range based on various conditions.
	getLeft	Gets the left side of the range.
	getRight	Gets the right side of the range.
	getStyle	Gets an IStyle object that can be used to customize the appearance of all cells in the range.
	getTop	Gets the top side of the range.
	getValidation	Gets an IValidation object that can be used to specify validation rules for the data in the cell 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.
	iterator	Returns an enumerator object that can be used to iterate through the cells in the range.
	merge	Merges the cells in this range into a single cell.
	moveTo	Overloaded. Moves the data from the current range to another range.
	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.
	sum	Returns the sum of Numeric cell values.
	toString
	unmerge	Unmerges all merged cells intersecting with this range.

See Also

CellRange Class
com.mindfusion.spreadsheet Namespace