com.mindfusion.spreadsheet.CellRange.insert Method

CellRange.insert Method

See Also

Introduction

General Information

What's New in this Release

Version History

Licensing

Programming Interface Overview

Reference

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

Cell Class

CellAnnotation Class

CellChangeContext Enumeration

CellChangedEvent Class

CellCollection Class

CellData Class

CellEvent Class

CellIndex Class

CellMouseEvent Class

CellParsingEvent Class

CellRange Class

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

Column Class

ColumnChangedEvent Class

ColumnCollection Class

ColumnEvent Class

ColumnMouseEvent Class

ColumnRange Class

ColumnRangeEvent Class

ColumnsEvent Class

ColumnsMovedEvent Class

ColumnsRemovedEvent Class

Command 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

Drawing Class

DrawRowEvent Class

DropDownEventObject Class

DropDownSelectionEventObject Class

DynamicFilterType Enumeration

ExcelExporter Class

ExcelImporter Class

ExternalizableImage Class

FillDate Enumeration

FillDirection Enumeration

FillType Enumeration

Filter Class

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

Measure Class

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

Picture Class

PrintOptions Class

PrintPreview Class

PushDirection Enumeration

RemoveItemCommand(T) Class

RenderContext Class

ReplaceItemCommand(T) Class

ResetCollectionCommand(T) Class

Rotate Enumeration

Row Class

RowChangedEvent Class

RowCollection Class

RowEvent Class

RowMouseEvent Class

RowRange Class

RowRangeEvent Class

RowReceiver Interface

RowsEvent Class

RowsMovedEvent Class

RowsRemovedEvent Class

Run 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

SortKey Class

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

Workbook Class

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

XUtils Class

com.mindfusion.spreadsheet.charts

com.mindfusion.spreadsheet.expressions

com.mindfusion.spreadsheet.standardforms

Function Reference

Technical Support

MindFusion Products

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

Namespace: com.mindfusion.spreadsheet
Package: com.mindfusion.spreadsheet

Syntax

Java Copy Code
public void insert ( PushDirection direction )

Parameters

direction: Specifies the direction to push the existing cells in the range.

Remarks

This method will raise an IllegalStateException exception if the operation would cause filled cells to be shifted beyond the sheet.