XlsRange

Overview

Package

Class

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.spire.xls.core.spreadsheet
Class XlsRange

java.lang.Object
  com.spire.xls.core.spreadsheet.XlsObject
      com.spire.xls.core.spreadsheet.XlsRange

All Implemented Interfaces:: ICombinedRange, IXLSRange, java.lang.Iterable

Direct Known Subclasses:: CellRange

public class XlsRange
extends XlsObject
implements ICombinedRange, java.lang.Iterable
extends XlsObject
implements ICombinedRange, java.lang.Iterable

Represents the XlsRange.

Constructor Summary
`XlsRange(java.lang.Object parent)`
`XlsRange(java.lang.Object parent, int column, int row)`
`XlsRange(java.lang.Object parent, int firstCol, int firstRow, int lastCol, int lastRow)`

Method Summary
`IXLSRange`	`activate()` Active single cell in the worksheet
`IXLSRange`	`activate(boolean scroll)` Activates a single cell, scroll to it and activates the corresponding sheet.
`CellRange`	`addCombinedRange(CellRange cr)` Add combined range
`ICommentShape`	`addComment()` Adds a comment to the range.
`ICommentShape`	`addComment(boolean bIsParseOptions)` Adds a comment to the range.
`void`	`autoFitColumns()` Changes the width of the columns in the range to achieve the best fit.
`void`	`autoFitRows()` Automatically adjust the height and width of the rows
`void`	`borderAround()` Sets around border for current range.
`void`	`borderAround(LineStyleType borderLine)` Sets around border for current range.
`void`	`borderAround(LineStyleType borderLine, java.awt.Color borderColor)` Sets around border for current range.
`void`	`borderAround(LineStyleType borderLine, ExcelColors borderColor)` Sets around border for current range.
`void`	`borderInside()` Sets inside border for current range.
`void`	`borderInside(LineStyleType borderLine)` Sets inside border for current range.
`void`	`borderInside(LineStyleType borderLine, java.awt.Color borderColor)` Sets inside border for current range.
`void`	`borderInside(LineStyleType borderLine, ExcelColors borderColor)` Sets inside border for current range.
`void`	`borderNone()` Sets none border for current range.
`void`	`clear(ExcelClearOptions option)` Clears the cell based on clear options.
`void`	`clearAll()` Clears the entire object.
`void`	`clearConditionalFormats()` Clears conditional formats.
`void`	`clearContents()` Clear the contents of the Range.
`void`	`collapseGroup(GroupByType groupBy)` Collapses current group.
`void`	`convertToNumber()` Convert number that stored as text to number
`IXLSRange`	`deepClone(java.lang.Object parent, java.util.HashMap rangeNames, XlsWorkbook book)` Clones current IXLSRange.
`void`	`dispose()` This method is called when disposing the object.
`void`	`expandGroup(GroupByType groupBy)` Expands current group.
`void`	`freezePanes()` Freezes panes at the current range in the worksheet.
`IXLSRange`	`get(int row, int column)` Gets / sets cell by row and column index.
`IXLSRange`	`get(int row, int column, int lastRow, int lastColumn)` Get cell range.
`IXLSRange`	`get(java.lang.String name)` Gets cell range.
`IXLSRange`	`get(java.lang.String name, boolean IsR1C1Notation)` Gets cell range.
`boolean`	`getBooleanValue()` Returns or sets the bool value of the specified range.
`IBorders`	`getBorders()` Returns a Borders collection that represents the borders of a style or a range of cells (including a range defined as part of a conditional format).
`BuiltInStyles`	`getBuiltInStyle()` Gets/sets built in style.
`java.util.ArrayList<CellRange>`	`getCellList()` Returns a Range object that represents the cells in the specified range.
`int`	`getCellsCount()` Gets number of cells.
`java.lang.String`	`getCellStyleName()` Gets/sets name of the style for the current range.
`int`	`getColumn()` Returns the number of the first column in the first area in the specified range.
`int`	`getColumnCount()` Gets number of columns.
`int`	`getColumnGroupLevel()` Column group level.
`IXLSRange[]`	`getColumns()` For a Range object, it returns an array of Range objects that represent the columns in the specified range.
`double`	`getColumnWidth()` Returns or sets the width of all columns in the specified range.
`ICommentShape`	`getComment()` Returns a Comment object that represents the comment associated with the cell in the upper-left corner of the range.
`ConditionalFormats`	`getConditionalFormats()` Collection of conditional formats for the range.
`int`	`getCount()` Returns the number of objects in the collection.
`Validation`	`getDataValidation()` Gets dataValidation of the sheet.
`java.util.Date`	`getDateTimeValue()` Gets DateTime value of the range.
`java.lang.String`	`getDisplayedText()` Gets cell displayed text.
`IXLSRange`	`getEndCell()` Returns a Range object that represents the cell at the end of the region that contains the source range.
`IXLSRange`	`getEntireColumn()` Returns a Range object that represents the entire column (or columns) that contains the specified range.
`IXLSRange`	`getEntireRow()` Returns a Range object that represents the entire row (or rows) that contains the specified range.
`java.lang.String`	`getEnvalutedValue()` Returns the calculated value of a formula.
`java.lang.String`	`getErrorValue()` Gets or sets error value of this range.
`int`	`getExtendedFormatIndex()` Sets / gets index of extended format.
`java.lang.String`	`getFormula()` Returns the object's formula in A1-style notation and in the language of the macro.
`java.lang.String`	`getFormulaArray()` Returns or sets the array formula of a range.
`java.lang.String`	`getFormulaArrayR1C1()` Returns or sets the formula for the object, using R1C1-style notation in the language of the macro
`boolean`	`getFormulaBoolValue()` Gets or sets bool value of the formula.
`java.util.Date`	`getFormulaDateTime()` Gets or sets bool value of the formula.
`java.lang.String`	`getFormulaErrorValue()` Gets or sets error value of the formula.
`double`	`getFormulaNumberValue()` Gets the double value of the formula.
`java.lang.String`	`getFormulaR1C1()` Returns or sets the formula for the object, using R1C1-style notation in the language of the macro
`java.lang.String`	`getFormulaStringValue()` Gets or sets string value of the range.
`java.lang.Object`	`getFormulaValue()` Gets formula value.
`HorizontalAlignType`	`getHorizontalAlignment()` Returns or sets the horizontal alignment for the specified object.
`IHyperLinks`	`getHyperlinks()` Returns hyperlinks for this range.
`java.util.EnumSet<IgnoreErrorType>`	`getIgnoreErrorOptions()` Represents ignore error options.
`int`	`getIndentLevel()` Returns or sets the indent level for the cell or range.
`int`	`getLastColumn()` Gets or sets last column of the range.
`int`	`getLastRow()` Gets or sets last row of the range.
`IXLSRange`	`getMergeArea()` Returns a Range object that represents the merged range containing the specified cell.
`java.lang.String`	`getNewRangeLocation(java.util.HashMap names, java.lang.String[] sheetName)` Gets new range location.
`java.lang.String`	`getNumberFormat()` Returns or sets the format code for the object.
`java.lang.String`	`getNumberText()` Returns cell text for number format.
`double`	`getNumberValue()` Gets or sets number value of the range.
`java.lang.Object`	`getParent()` Parent object for this object.
`java.lang.String`	`getRangeAddress()` Returns the range reference in the language of the macro.
`java.lang.String`	`getRangeAddressLocal()` Returns the range reference for the specified range in the language of the user.
`java.lang.String`	`getRangeGlobalAddress()` Returns the range reference in the language of the macro.
`java.lang.String`	`getRangeGlobalAddress2007()` Gets address global in the format required by Excel 2007.
`java.lang.String`	`getRangeGlobalAddressWithoutSheetName()` Return global address without worksheet name.
`java.lang.String`	`getRangeR1C1Address()` Returns the range reference using R1C1 notation.
`java.lang.String`	`getRangeR1C1AddressLocal()` Returns the range reference using R1C1 notation.
`java.awt.Rectangle[]`	`getRectangles()` Gets rectangle information of current range.
`IRichTextString`	`getRichText()` Returns a RichTextString object that represents the rich text style.
`int`	`getRow()` Returns the number of the first row of the first area in the range.
`int`	`getRowCount()` Gets number of rows.
`int`	`getRowGroupLevel()` Row group level.
`double`	`getRowHeight()` Returns the height of all the rows in the range specified, measured in points.
`IXLSRange[]`	`getRows()` For a Range object, it returns an array of Range objects that represent the rows in the specified range.
`IStyle`	`getStyle()` Returns a Style object that represents the style of the specified range.
`java.lang.String`	`getText()` Gets / sets text of range.
`java.lang.String`	`getValue()` Returns the value of the specified range.
`java.lang.Object`	`getValue2()` Returns or sets the cell value.
`VerticalAlignType`	`getVerticalAlignment()` Returns or sets the vertical alignment of the specified object.
`IWorksheet`	`getWorksheet()` Returns a worksheet object that represents the worksheet containing the specified range.
`java.lang.String`	`getWorksheetName()` Returns name of the parent worksheet.
`CellRange`	`groupByColumns(boolean isCollapsed)` Groups columns.
`CellRange`	`groupByRows(boolean isCollapsed)` Groups row.
`boolean`	`hasBoolean()` Indicates whether range contains bool value.
`boolean`	`hasComment()`
`boolean`	`hasConditionFormats()` Indicates whether each cell of the range has some conditional formatting.
`boolean`	`hasDataValidation()` Indicates whether specified range object has data validation.
`boolean`	`hasDateTime()` Determines if all cells in the range contain datetime.
`boolean`	`hasError()` Indicates whether range contains error value.
`boolean`	`hasExternalFormula()` Check if the formula in the range has external links.
`boolean`	`hasFormula()` True if all cells in the range contain formulas;
`boolean`	`hasFormulaArray()` Determines if all cells in the range contain array-entered formula.
`boolean`	`hasFormulaBoolValue()` Determines if all cells in the range contain formula bool value..
`boolean`	`hasFormulaDateTime()` Indicates if current range has formula value formatted as DateTime.
`boolean`	`hasFormulaErrorValue()` Determines if all cells in the range contain error value.
`boolean`	`hasFormulaNumberValue()` Indicates whether current range has formula number value.
`boolean`	`hasFormulaStringValue()` Indicates whether current range contains formula value which evaluated as string.
`boolean`	`hasMerged()` Indicates whether this range is part of merged range.
`boolean`	`hasNumber()` Determines if any one cell in the range contain number.
`boolean`	`hasPictures()` Indicates whether the range is blank.
`boolean`	`hasRichText()` Determines if all cells in the range contain rich text string.
`boolean`	`hasString()` Determines if all cells in the range contain string.
`boolean`	`hasStyle()` Determines if all cells in the range contain differs from default style.
`IXLSRange`	`intersect(IXLSRange range)` Returns intersection of this range with the specified one.
`boolean`	`isAllNumber()` Determines if all cells in the range contain number.
`boolean`	`isBlank()` Indicates whether the range is blank.
`boolean`	`isFormulaHidden()` Determines if the formula will be hidden when the worksheet is protected.
`void`	`isFormulaHidden(boolean value)`
`boolean`	`isGroupedByColumn()` Indicates whether this range is grouped by column.
`boolean`	`isGroupedByRow()` Indicates whether this range is grouped by row.
`boolean`	`isInitialized()` Indicates whether range has been initialized.
`java.lang.Boolean`	`isStringsPreserved()` Indicates whether all values in the range are preserved as strings.
`void`	`isStringsPreserved(java.lang.Boolean value)` Indicates whether all values in the range are preserved as strings.
`boolean`	`isWrapText()` Determines if Microsoft Excel wraps the text in the object.
`void`	`isWrapText(boolean value)` True if Microsoft Excel wraps the text in the object.
`java.util.Iterator`	`iterator()`
`java.awt.geom.Dimension2D`	`measureString(java.lang.String measureString)` Measures size of the string.
`void`	`merge()` Creates a merged cell from the specified range object.
`void`	`merge(boolean clearCells)` Creates a merged cell from the specified Range object.
`IXLSRange`	`merge(IXLSRange range)` Creates a merged cell from the specified Range object.
`void`	`partialClear()` Partially clear range.
`void`	`replace(java.lang.String oldValue, DataColumn newValues, boolean isFieldNamesShown)` Replaces cells' values with new data.
`void`	`replace(java.lang.String oldValue, DataTable newValues, boolean isFieldNamesShown)` Replaces cells' values with new data.
`void`	`replace(java.lang.String oldValue, java.util.Date newValue)` Replaces cells' values with new data.
`void`	`replace(java.lang.String oldValue, double newValue)` Replaces cells' values with new data.
`void`	`replace(java.lang.String oldValue, double[] newValues, boolean isVertical)` Replaces cells' values with new data.
`void`	`replace(java.lang.String oldValue, int[] newValues, boolean isVertical)` Replaces cells' values with new data.
`void`	`replace(java.lang.String oldValue, java.lang.String newValue)` Replaces cells' values with new data.
`void`	`replace(java.lang.String oldValue, java.lang.String[] newValues, boolean isVertical)` Replaces cells' values with new data.
`void`	`set(int row, int column, IXLSRange value)` sets cell by row and column index.
`void`	`setBooleanValue(boolean value)` Returns or sets the bool value of the specified range.
`void`	`setBuiltInStyle(BuiltInStyles value)` Gets/sets built in style.
`void`	`setCellStyleName(java.lang.String cellStyleName)` Sets name of the style for the current range.
`void`	`setColumnWidth(double columnWidth)` Sets the width of the column.
`void`	`setDataValidation(XlsValidation dv)` Sets data validation for the range.
`void`	`setDateTimeValue(java.util.Calendar calendar)` Sets Calendar value of the range.
`void`	`setDateTimeValue(java.util.Date date)` Sets Date value of the range.
`void`	`setErrorValue(java.lang.String value)` Gets or sets error value of this range.
`void`	`setExtendedFormatIndex(int value)` Sets / gets index of extended format.
`void`	`setExtendedFormatIndexs(int index)` Sets index of extended format that defines style for this range..
`void`	`setFormula(java.lang.String formula)` Sets the object's formula in A1-style notation and in the language of the macro.
`void`	`setFormulaArray(java.lang.String value)` Returns or sets the array formula of a range.
`void`	`setFormulaArrayR1C1(java.lang.String value)` Returns or sets the formula for the object, using R1C1-style notation in the language of the macro
`void`	`setFormulaBoolValue(boolean value)` Gets or sets bool value of the formula.
`void`	`setFormulaDateTime(java.util.Date value)` Gets or sets bool value of the formula.
`void`	`setFormulaErrorValue(java.lang.String value)` Sets the error value of the formula.
`void`	`setFormulaNumberValue(double value)` Gets or sets double value of the formula.
`void`	`setFormulaR1C1(java.lang.String value)` Returns or sets the formula for the object, using R1C1-style notation in the language of the macro
`void`	`setFormulaStringValue(java.lang.String value)` Gets or sets string value of the range.
`void`	`setHorizontalAlignment(HorizontalAlignType value)` Returns or sets the horizontal alignment for the specified object.
`void`	`setIgnoreErrorOptions(java.util.EnumSet<IgnoreErrorType> ignoreErrorOptions)` Sets ignore error options.
`void`	`setIndentLevel(int value)` Returns or sets the indent level for the cell or range.
`void`	`setLastColumn(int value)` Gets or sets last column of the range.
`void`	`setLastRow(int value)` Gets or sets last row of the range.
`void`	`setNumberFormat(java.lang.String numberFormat)` Sets number format
`void`	`setNumberValue(double numberValue)` Sets number value
`void`	`setObjectValue(java.lang.Object value)` sets the cell value.
`void`	`setRowHeight(double rowHeight)` Sets the height of the row
`void`	`setRowHeight(double rowHeight, boolean bIsBadFontHeight)` Sets row height.
`void`	`setStyle(IStyle value)` Returns a Style object that represents the style of the specified range.
`void`	`setText(java.lang.String text)` Sets text
`void`	`setValue(java.lang.String value)` Sets the value of the specified range.
`void`	`setVerticalAlignment(VerticalAlignType value)` Returns or sets the vertical alignment of the specified object.
`CellRange`	`ungroupByColumns()` Ungroups column.
`CellRange`	`ungroupByRows()` Ungroups row.
`void`	`unMerge()` Separates a merged area into individual cells.
`void`	`updateRange(int startRow, int startColumn, int endRow, int endColumn)` Update region of range

Methods inherited from interface com.spire.xls.core.ICombinedRange
`getRectanglesCount`

Methods inherited from interface com.spire.xls.core.IXLSRange
`expandGroup, getInnerFormulaDateTime, getTimeSpanValue`

Constructor Detail

XlsRange

public XlsRange(java.lang.Object parent)

XlsRange

public XlsRange(java.lang.Object parent,
                int column,
                int row)

XlsRange

public XlsRange(java.lang.Object parent,
                int firstCol,
                int firstRow,
                int lastCol,
                int lastRow)

Method Detail

getBooleanValue

public boolean getBooleanValue()

Returns or sets the bool value of the specified range.

Specified by:: getBooleanValue in interface IXLSRange

setBooleanValue

public void setBooleanValue(boolean value)

Returns or sets the bool value of the specified range.

Specified by:: setBooleanValue in interface IXLSRange

Parameters:: value -

getBorders

public IBorders getBorders()

Returns a Borders collection that represents the borders of a style or a range of cells (including a range defined as part of a conditional format).

Specified by:: getBorders in interface IXLSRange

getBuiltInStyle

public BuiltInStyles getBuiltInStyle()

Gets/sets built in style.

Specified by:: getBuiltInStyle in interface IXLSRange

setBuiltInStyle

public void setBuiltInStyle(BuiltInStyles value)

Gets/sets built in style.

Specified by:: setBuiltInStyle in interface IXLSRange

getCellList

public java.util.ArrayList<CellRange> getCellList()

Returns a Range object that represents the cells in the specified range.

Specified by:: getCellList in interface IXLSRange

getCellStyleName

public java.lang.String getCellStyleName()

Gets/sets name of the style for the current range.

Specified by:: getCellStyleName in interface IXLSRange

setCellStyleName

public void setCellStyleName(java.lang.String cellStyleName)

Sets name of the style for the current range.

Parameters:: cellStyleName -

getColumn

public int getColumn()

Returns the number of the first column in the first area in the specified range.

Specified by:: getColumn in interface IXLSRange

getColumnGroupLevel

public int getColumnGroupLevel()

Column group level.

Specified by:: getColumnGroupLevel in interface IXLSRange

getColumns

public IXLSRange[] getColumns()

For a Range object, it returns an array of Range objects that represent the columns in the specified range.

Specified by:: getColumns in interface IXLSRange

getColumnWidth

public double getColumnWidth()

Returns or sets the width of all columns in the specified range.

Specified by:: getColumnWidth in interface IXLSRange

setColumnWidth

public void setColumnWidth(double columnWidth)

Sets the width of the column.

Parameters:: columnWidth -

getComment

public ICommentShape getComment()

Returns a Comment object that represents the comment associated with the cell in the upper-left corner of the range.

Specified by:: getComment in interface IXLSRange

getConditionalFormats

public ConditionalFormats getConditionalFormats()

Collection of conditional formats for the range.

Specified by:: getConditionalFormats in interface IXLSRange

getCount

public int getCount()

Returns the number of objects in the collection.

Specified by:: getCount in interface IXLSRange

getDataValidation

public Validation getDataValidation()

Gets dataValidation of the sheet. Read Only

Specified by:: getDataValidation in interface IXLSRange

getDateTimeValue

public java.util.Date getDateTimeValue()

Gets DateTime value of the range.

Specified by:: getDateTimeValue in interface IXLSRange

setDateTimeValue

public void setDateTimeValue(java.util.Date date)

Sets Date value of the range.

setDateTimeValue

public void setDateTimeValue(java.util.Calendar calendar)

Sets Calendar value of the range.

getEndCell

public IXLSRange getEndCell()

Returns a Range object that represents the cell at the end of the region that contains the source range.

Specified by:: getEndCell in interface IXLSRange

getEntireColumn

public IXLSRange getEntireColumn()

Returns a Range object that represents the entire column (or columns) that contains the specified range.

Specified by:: getEntireColumn in interface IXLSRange

getEntireRow

public IXLSRange getEntireRow()

Returns a Range object that represents the entire row (or rows) that contains the specified range. Read-only.

Specified by:: getEntireRow in interface IXLSRange

getEnvalutedValue

public java.lang.String getEnvalutedValue()

Returns the calculated value of a formula.

Specified by:: getEnvalutedValue in interface IXLSRange

getErrorValue

public java.lang.String getErrorValue()

Gets or sets error value of this range.

Specified by:: getErrorValue in interface IXLSRange

setErrorValue

public void setErrorValue(java.lang.String value)

Gets or sets error value of this range.

Parameters:: value -

getFormula

public java.lang.String getFormula()

Returns the object's formula in A1-style notation and in the language of the macro.

Specified by:: getFormula in interface IXLSRange

setFormula

public void setFormula(java.lang.String formula)

Sets the object's formula in A1-style notation and in the language of the macro. Write variant.

Parameters:: formula -

getFormulaArray

public java.lang.String getFormulaArray()

Returns or sets the array formula of a range.

Specified by:: getFormulaArray in interface IXLSRange

setFormulaArray

public void setFormulaArray(java.lang.String value)

Returns or sets the array formula of a range.

Parameters:: value -

getFormulaArrayR1C1

public java.lang.String getFormulaArrayR1C1()

Returns or sets the formula for the object, using R1C1-style notation in the language of the macro

Specified by:: getFormulaArrayR1C1 in interface IXLSRange

setFormulaArrayR1C1

public void setFormulaArrayR1C1(java.lang.String value)

Returns or sets the formula for the object, using R1C1-style notation in the language of the macro

Parameters:: value -

getFormulaBoolValue

public boolean getFormulaBoolValue()

Gets or sets bool value of the formula.

Specified by:: getFormulaBoolValue in interface IXLSRange

setFormulaBoolValue

public void setFormulaBoolValue(boolean value)

Gets or sets bool value of the formula.

Parameters:: value -

getFormulaDateTime

public java.util.Date getFormulaDateTime()

Gets or sets bool value of the formula.

setFormulaDateTime

public void setFormulaDateTime(java.util.Date value)

Gets or sets bool value of the formula.

getFormulaErrorValue

public java.lang.String getFormulaErrorValue()

Gets or sets error value of the formula.

Specified by:: getFormulaErrorValue in interface IXLSRange

setFormulaErrorValue

public void setFormulaErrorValue(java.lang.String value)

Sets the error value of the formula.

Parameters:: value -

getFormulaNumberValue

public double getFormulaNumberValue()

Gets the double value of the formula.

Specified by:: getFormulaNumberValue in interface IXLSRange

setFormulaNumberValue

public void setFormulaNumberValue(double value)

Gets or sets double value of the formula.

Specified by:: setFormulaNumberValue in interface IXLSRange

Parameters:: value -

getFormulaR1C1

public java.lang.String getFormulaR1C1()

Returns or sets the formula for the object, using R1C1-style notation in the language of the macro

Specified by:: getFormulaR1C1 in interface IXLSRange

setFormulaR1C1

public void setFormulaR1C1(java.lang.String value)

Returns or sets the formula for the object, using R1C1-style notation in the language of the macro

Parameters:: value -

getFormulaStringValue

public java.lang.String getFormulaStringValue()

Gets or sets string value of the range.

Specified by:: getFormulaStringValue in interface IXLSRange

setFormulaStringValue

public void setFormulaStringValue(java.lang.String value)

Gets or sets string value of the range.

Specified by:: setFormulaStringValue in interface IXLSRange

Parameters:: value -

getFormulaValue

public java.lang.Object getFormulaValue()

Gets formula value.

hasBoolean

public boolean hasBoolean()

Indicates whether range contains bool value.

Specified by:: hasBoolean in interface IXLSRange

hasComment

public boolean hasComment()

getColumnCount

public int getColumnCount()

Gets number of columns.

getRowCount

public int getRowCount()

Gets number of rows.

hasDataValidation

public boolean hasDataValidation()

Indicates whether specified range object has data validation. If Range is not single cell, then returns true only if all cells have data validation. Read-only.

Specified by:: hasDataValidation in interface IXLSRange

hasDateTime

public boolean hasDateTime()

Determines if all cells in the range contain datetime.

Specified by:: hasDateTime in interface IXLSRange

hasError

public boolean hasError()

Indicates whether range contains error value.

Specified by:: hasError in interface IXLSRange

hasExternalFormula

public boolean hasExternalFormula()

Check if the formula in the range has external links. Read-only.

Specified by:: hasExternalFormula in interface IXLSRange

hasFormula

public boolean hasFormula()

True if all cells in the range contain formulas;

Specified by:: hasFormula in interface IXLSRange

hasFormulaArray

public boolean hasFormulaArray()

Determines if all cells in the range contain array-entered formula.

Specified by:: hasFormulaArray in interface IXLSRange

hasFormulaBoolValue

public boolean hasFormulaBoolValue()

Determines if all cells in the range contain formula bool value..

Specified by:: hasFormulaBoolValue in interface IXLSRange

hasFormulaDateTime

public boolean hasFormulaDateTime()

Indicates if current range has formula value formatted as DateTime. Read-only.

Specified by:: hasFormulaDateTime in interface IXLSRange

hasFormulaErrorValue

public boolean hasFormulaErrorValue()

Determines if all cells in the range contain error value.

Specified by:: hasFormulaErrorValue in interface IXLSRange

hasFormulaNumberValue

public boolean hasFormulaNumberValue()

Indicates whether current range has formula number value.

Specified by:: hasFormulaNumberValue in interface IXLSRange

hasFormulaStringValue

public boolean hasFormulaStringValue()

Indicates whether current range contains formula value which evaluated as string.

Specified by:: hasFormulaStringValue in interface IXLSRange

hasMerged

public boolean hasMerged()

Indicates whether this range is part of merged range.

Specified by:: hasMerged in interface IXLSRange

hasNumber

public boolean hasNumber()

Determines if any one cell in the range contain number.

Specified by:: hasNumber in interface IXLSRange

hasPictures

public boolean hasPictures()

Indicates whether the range is blank.

hasRichText

public boolean hasRichText()

Determines if all cells in the range contain rich text string.

Specified by:: hasRichText in interface IXLSRange

hasString

public boolean hasString()

Determines if all cells in the range contain string.

Specified by:: hasString in interface IXLSRange

hasStyle

public boolean hasStyle()

Determines if all cells in the range contain differs from default style.

Specified by:: hasStyle in interface IXLSRange

getHorizontalAlignment

public HorizontalAlignType getHorizontalAlignment()

Returns or sets the horizontal alignment for the specified object.

Specified by:: getHorizontalAlignment in interface IXLSRange

setHorizontalAlignment

public void setHorizontalAlignment(HorizontalAlignType value)

Returns or sets the horizontal alignment for the specified object.

getHyperlinks

public IHyperLinks getHyperlinks()

Returns hyperlinks for this range.

getIgnoreErrorOptions

public java.util.EnumSet<IgnoreErrorType> getIgnoreErrorOptions()

Represents ignore error options. If not single cell returs concatenateed flags.

Specified by:: getIgnoreErrorOptions in interface IXLSRange

Returns:

setIgnoreErrorOptions

public void setIgnoreErrorOptions(java.util.EnumSet<IgnoreErrorType> ignoreErrorOptions)

Sets ignore error options. If not single cell returns concatenateed flags.

Specified by:: setIgnoreErrorOptions in interface IXLSRange

getIndentLevel

public int getIndentLevel()

Returns or sets the indent level for the cell or range. value should be 0 between 15.

Specified by:: getIndentLevel in interface IXLSRange

setIndentLevel

public void setIndentLevel(int value)

Returns or sets the indent level for the cell or range. value should be 0 between 15.

isAllNumber

public boolean isAllNumber()

Determines if all cells in the range contain number.

isBlank

public boolean isBlank()

Indicates whether the range is blank.

Specified by:: isBlank in interface IXLSRange

isFormulaHidden

public boolean isFormulaHidden()

Determines if the formula will be hidden when the worksheet is protected.

Specified by:: isFormulaHidden in interface IXLSRange

isFormulaHidden

public void isFormulaHidden(boolean value)

isGroupedByColumn

public boolean isGroupedByColumn()

Indicates whether this range is grouped by column.

Specified by:: isGroupedByColumn in interface IXLSRange

isGroupedByRow

public boolean isGroupedByRow()

Indicates whether this range is grouped by row.

Specified by:: isGroupedByRow in interface IXLSRange

isInitialized

public boolean isInitialized()

Indicates whether range has been initialized.

Specified by:: isInitialized in interface IXLSRange

isStringsPreserved

public java.lang.Boolean isStringsPreserved()

Indicates whether all values in the range are preserved as strings.

Specified by:: isStringsPreserved in interface IXLSRange

isStringsPreserved

public void isStringsPreserved(java.lang.Boolean value)

Indicates whether all values in the range are preserved as strings.

Specified by:: isStringsPreserved in interface IXLSRange

isWrapText

public boolean isWrapText()

Determines if Microsoft Excel wraps the text in the object.

Specified by:: isWrapText in interface IXLSRange

isWrapText

public void isWrapText(boolean value)

Description copied from interface: IXLSRange

True if Microsoft Excel wraps the text in the object. Read/write Boolean.

Specified by:: isWrapText in interface IXLSRange

getLastColumn

public int getLastColumn()

Gets or sets last column of the range.

Specified by:: getLastColumn in interface IXLSRange

setLastColumn

public void setLastColumn(int value)

Gets or sets last column of the range.

getLastRow

public int getLastRow()

Gets or sets last row of the range.

Specified by:: getLastRow in interface IXLSRange

setLastRow

public void setLastRow(int value)

Gets or sets last row of the range.

getMergeArea

public IXLSRange getMergeArea()

Returns a Range object that represents the merged range containing the specified cell.

Specified by:: getMergeArea in interface IXLSRange

getDisplayedText

public java.lang.String getDisplayedText()

Gets cell displayed text.

hasConditionFormats

public boolean hasConditionFormats()

Indicates whether each cell of the range has some conditional formatting.

getNumberFormat

public java.lang.String getNumberFormat()

Returns or sets the format code for the object.

Specified by:: getNumberFormat in interface IXLSRange

setNumberFormat

public void setNumberFormat(java.lang.String numberFormat)

Sets number format

getNumberText

public java.lang.String getNumberText()

Returns cell text for number format.

Specified by:: getNumberText in interface IXLSRange

getNumberValue

public double getNumberValue()

Gets or sets number value of the range.

Specified by:: getNumberValue in interface IXLSRange

setNumberValue

public void setNumberValue(double numberValue)

Sets number value

Parameters:: numberValue -

getParent

public java.lang.Object getParent()

Parent object for this object.

Overrides:: getParent in class XlsObject

getRangeAddress

public java.lang.String getRangeAddress()

Returns the range reference in the language of the macro. Read-only String.

Specified by:: getRangeAddress in interface IXLSRange

getRangeAddressLocal

public java.lang.String getRangeAddressLocal()

Returns the range reference for the specified range in the language of the user.

Specified by:: getRangeAddressLocal in interface IXLSRange

getRangeGlobalAddressWithoutSheetName

public java.lang.String getRangeGlobalAddressWithoutSheetName()

Return global address without worksheet name.

getRangeGlobalAddress

public java.lang.String getRangeGlobalAddress()

Returns the range reference in the language of the macro.

Specified by:: getRangeGlobalAddress in interface IXLSRange

getRangeR1C1Address

public java.lang.String getRangeR1C1Address()

Returns the range reference using R1C1 notation.

Specified by:: getRangeR1C1Address in interface IXLSRange

getRangeR1C1AddressLocal

public java.lang.String getRangeR1C1AddressLocal()

Returns the range reference using R1C1 notation.

Specified by:: getRangeR1C1AddressLocal in interface IXLSRange

getRichText

public IRichTextString getRichText()

Returns a RichTextString object that represents the rich text style.

Specified by:: getRichText in interface IXLSRange

getRow

public int getRow()

Returns the number of the first row of the first area in the range.

Specified by:: getRow in interface IXLSRange

getRowGroupLevel

public int getRowGroupLevel()

Row group level.

Specified by:: getRowGroupLevel in interface IXLSRange

getRowHeight

public double getRowHeight()

Returns the height of all the rows in the range specified, measured in points.

Specified by:: getRowHeight in interface IXLSRange

setRowHeight

public void setRowHeight(double rowHeight)

Sets the height of the row

Parameters:: rowHeight -

getRows

public IXLSRange[] getRows()

For a Range object, it returns an array of Range objects that represent the rows in the specified range.

Specified by:: getRows in interface IXLSRange

getExtendedFormatIndex

public int getExtendedFormatIndex()

Sets / gets index of extended format.

Throws:: "System.ArgumentException" - When method is applied for the range that contains more than one cell.

setExtendedFormatIndex

public void setExtendedFormatIndex(int value)

Sets / gets index of extended format.

Parameters:: value -

setExtendedFormatIndexs

public void setExtendedFormatIndexs(int index)

Sets index of extended format that defines style for this range..

Parameters:: index - Index to set.

setRowHeight

public void setRowHeight(double rowHeight,
                         boolean bIsBadFontHeight)

Sets row height.

Parameters:: rowHeight - Row height; bIsBadFontHeight - Indicates whether font and row height are not compatible.

getStyle

public IStyle getStyle()

Returns a Style object that represents the style of the specified range.

Specified by:: getStyle in interface IXLSRange

setStyle

public void setStyle(IStyle value)

Returns a Style object that represents the style of the specified range.

getText

public java.lang.String getText()

Gets / sets text of range.

Specified by:: getText in interface IXLSRange

setText

public void setText(java.lang.String text)

Sets text

Parameters:: text -

get

public IXLSRange get(int row,
                     int column,
                     int lastRow,
                     int lastColumn)

Get cell range. Row and column indexes are one-based. Read-only.

Specified by:: get in interface IXLSRange

get

public IXLSRange get(int row,
                     int column)

Gets / sets cell by row and column index. Row and column indexes are one-based.

Specified by:: get in interface IXLSRange

set

public void set(int row,
                int column,
                IXLSRange value)

Description copied from interface: IXLSRange

sets cell by row and column index. Row and column indexes are one-based.

Specified by:: set in interface IXLSRange

get

public IXLSRange get(java.lang.String name,
                     boolean IsR1C1Notation)

Gets cell range. Read-only.

Specified by:: get in interface IXLSRange

get

public IXLSRange get(java.lang.String name)

Gets cell range. Read-only.

Specified by:: get in interface IXLSRange

getValue

public java.lang.String getValue()

Returns the value of the specified range.

Specified by:: getValue in interface IXLSRange

setValue

public void setValue(java.lang.String value)

Sets the value of the specified range. Write variant.

Specified by:: setValue in interface IXLSRange

getValue2

public java.lang.Object getValue2()

Returns or sets the cell value. It's not use for current and datetime types.

Specified by:: getValue2 in interface IXLSRange

Returns:

setObjectValue

public void setObjectValue(java.lang.Object value)

sets the cell value. It's not use for current and datetime types.

Specified by:: setObjectValue in interface IXLSRange

getVerticalAlignment

public VerticalAlignType getVerticalAlignment()

Returns or sets the vertical alignment of the specified object.

Specified by:: getVerticalAlignment in interface IXLSRange

setVerticalAlignment

public void setVerticalAlignment(VerticalAlignType value)

Returns or sets the vertical alignment of the specified object.

Specified by:: setVerticalAlignment in interface IXLSRange

getWorksheet

public IWorksheet getWorksheet()

Returns a worksheet object that represents the worksheet containing the specified range.

Specified by:: getWorksheet in interface IXLSRange

getNewRangeLocation

public java.lang.String getNewRangeLocation(java.util.HashMap names,
                                            java.lang.String[] sheetName)

Gets new range location.

Specified by:: getNewRangeLocation in interface ICombinedRange

Parameters:: names - Worksheet names.; sheetName - New worksheet name.
Returns:: New name.

deepClone

public IXLSRange deepClone(java.lang.Object parent,
                           java.util.HashMap rangeNames,
                           XlsWorkbook book)

Clones current IXLSRange.

Specified by:: deepClone in interface ICombinedRange

Parameters:: parent - Parent object.; rangeNames - Hash table with new names.; book - Parent workbook.
Returns:: Returns clone of current instance.

clearConditionalFormats

public void clearConditionalFormats()

Clears conditional formats.

Specified by:: clearConditionalFormats in interface ICombinedRange

getRectangles

public java.awt.Rectangle[] getRectangles()

Gets rectangle information of current range.

Specified by:: getRectangles in interface ICombinedRange

Returns:: Rectangles information

getWorksheetName

public java.lang.String getWorksheetName()

Returns name of the parent worksheet.

Specified by:: getWorksheetName in interface ICombinedRange

getCellsCount

public int getCellsCount()

Gets number of cells.

Specified by:: getCellsCount in interface ICombinedRange

getRangeGlobalAddress2007

public java.lang.String getRangeGlobalAddress2007()

Gets address global in the format required by Excel 2007.

Specified by:: getRangeGlobalAddress2007 in interface ICombinedRange

activate

public IXLSRange activate(boolean scroll)

Activates a single cell, scroll to it and activates the corresponding sheet. To select a range of cells, use the Select method.

Specified by:: activate in interface IXLSRange

Parameters:: scroll - True to scroll to the cell
Returns:

activate

public IXLSRange activate()

Active single cell in the worksheet

Returns:

addComment

public ICommentShape addComment()

Adds a comment to the range.

Specified by:: addComment in interface IXLSRange

Returns:: Created comment or exists one.

autoFitColumns

public void autoFitColumns()

Changes the width of the columns in the range to achieve the best fit.

Specified by:: autoFitColumns in interface IXLSRange

autoFitRows

public void autoFitRows()

Automatically adjust the height and width of the rows

Specified by:: autoFitRows in interface IXLSRange

borderAround

public void borderAround()

Sets around border for current range.

Specified by:: borderAround in interface IXLSRange

borderAround

public void borderAround(LineStyleType borderLine)

Sets around border for current range.

Specified by:: borderAround in interface IXLSRange

Parameters:: borderLine - Represents border line.

borderAround

public void borderAround(LineStyleType borderLine,
                         java.awt.Color borderColor)

Sets around border for current range.

Specified by:: borderAround in interface IXLSRange

Parameters:: borderLine - Represents border line.; borderColor - Represents border color.

borderAround

public void borderAround(LineStyleType borderLine,
                         ExcelColors borderColor)

Sets around border for current range.

Specified by:: borderAround in interface IXLSRange

Parameters:: borderLine - Represents border line.; borderColor - Represents border color as ExcelColors.

borderInside

public void borderInside()

Sets inside border for current range.

Specified by:: borderInside in interface IXLSRange

borderInside

public void borderInside(LineStyleType borderLine)

Sets inside border for current range.

Specified by:: borderInside in interface IXLSRange

Parameters:: borderLine - Represents border line.

borderInside

public void borderInside(LineStyleType borderLine,
                         java.awt.Color borderColor)

Sets inside border for current range.

Specified by:: borderInside in interface IXLSRange

Parameters:: borderLine - Sets inside border for current range.; borderColor - Represents border color.

borderInside

public void borderInside(LineStyleType borderLine,
                         ExcelColors borderColor)

Sets inside border for current range.

Specified by:: borderInside in interface IXLSRange

Parameters:: borderLine - Represents border line.; borderColor - Represents border color as ExcelColors.

borderNone

public void borderNone()

Sets none border for current range.

Specified by:: borderNone in interface IXLSRange

clear

public void clear(ExcelClearOptions option)

Clears the cell based on clear options.

Specified by:: clear in interface IXLSRange

Parameters:: option -

clearAll

public void clearAll()

Clears the entire object.

clearContents

public void clearContents()

Clear the contents of the Range.

Specified by:: clearContents in interface IXLSRange

groupByColumns

public CellRange groupByColumns(boolean isCollapsed)

Groups columns.

Parameters:: isCollapsed - Indicates whether group should be collapsed.
Returns:

groupByRows

public CellRange groupByRows(boolean isCollapsed)

Groups row.

Parameters:: isCollapsed - Indicates whether group should be collapsed.
Returns:

ungroupByColumns

public CellRange ungroupByColumns()

Ungroups column.

Returns:

ungroupByRows

public CellRange ungroupByRows()

Ungroups row.

Returns:

collapseGroup

public void collapseGroup(GroupByType groupBy)

Collapses current group.

Specified by:: collapseGroup in interface IXLSRange

Parameters:: groupBy - This parameter specifies whether the grouping should be performed by rows or by columns.

dispose

public void dispose()

This method is called when disposing the object.

Overrides:: dispose in class XlsObject

expandGroup

public void expandGroup(GroupByType groupBy)

Expands current group.

Specified by:: expandGroup in interface IXLSRange

Parameters:: groupBy - This parameter specifies whether the grouping should be performed by rows or by columns.

freezePanes

public void freezePanes()

Freezes panes at the current range in the worksheet. current range should be single cell range.

Specified by:: freezePanes in interface IXLSRange

merge

public IXLSRange merge(IXLSRange range)

Creates a merged cell from the specified Range object.

Specified by:: merge in interface IXLSRange

Parameters:: range - The Range to merge with.
Returns:: Merged ranges or null if wasn't able to merge ranges.

intersect

public IXLSRange intersect(IXLSRange range)

Returns intersection of this range with the specified one.

Specified by:: intersect in interface IXLSRange

Parameters:: range - The Range with which to intersect.
Returns:: Range intersection. If there is no intersection, NULL is returned.

measureString

public java.awt.geom.Dimension2D measureString(java.lang.String measureString)

Measures size of the string.

Parameters:: measureString - String to measure.
Returns:: Size of the string.

merge

public void merge()

Creates a merged cell from the specified range object.

Specified by:: merge in interface IXLSRange

merge

public void merge(boolean clearCells)

Creates a merged cell from the specified Range object.

Specified by:: merge in interface IXLSRange

Parameters:: clearCells - Indicates whether to clear unnecessary cells.

partialClear

public void partialClear()

Partially clear range.

unMerge

public void unMerge()

Separates a merged area into individual cells.

Specified by:: unMerge in interface IXLSRange

iterator

public java.util.Iterator iterator()

addComment

public ICommentShape addComment(boolean bIsParseOptions)

Adds a comment to the range.

Parameters:: bIsParseOptions -
Returns:: Created comment or exists one.

setDataValidation

public void setDataValidation(XlsValidation dv)

Sets data validation for the range.

Parameters:: dv - Data validation to set.