com.spire.xls.core
Interface ICombinedRange

All Superinterfaces:

java.lang.Iterable, IXLSRange

All Known Implementing Classes:

CellRange, XlsRange, XlsRangesCollection

public interface ICombinedRange
extends IXLSRange

Represents a combined Range.

Method Summary

void	clearConditionalFormats() Clears conditional formats.
IXLSRange	deepClone(java.lang.Object parent, java.util.HashMap hashNewNames, XlsWorkbook book) Clones current IXLSRange.
int	getCellsCount() Number of cells in the range.
java.lang.String	getNewRangeLocation(java.util.HashMap names, java.lang.String[] strSheetName) Gets new address of range.
java.lang.String	getRangeGlobalAddress2007() Gets address global in the format required by Excel 2007.
java.awt.Rectangle[]	getRectangles() Returns array that contains information about range.
int	getRectanglesCount() Returns number of rectangles returned by GetRectangles method.
java.lang.String	getWorksheetName() Gets name of the parent worksheet.

Methods inherited from interface com.spire.xls.core.IXLSRange

activate, addComment, autoFitColumns, autoFitRows, borderAround, borderAround, borderAround, borderAround, borderInside, borderInside, borderInside, borderInside, borderNone, clear, clearContents, collapseGroup, expandGroup, expandGroup, freezePanes, get, get, get, get, getBooleanValue, getBorders, getBuiltInStyle, getCellList, getCellStyleName, getColumn, getColumnGroupLevel, getColumns, getColumnWidth, getComment, getConditionalFormats, getCount, getDataValidation, getDateTimeValue, getEndCell, getEntireColumn, getEntireRow, getEnvalutedValue, getErrorValue, getFormula, getFormulaArray, getFormulaArrayR1C1, getFormulaBoolValue, getFormulaErrorValue, getFormulaNumberValue, getFormulaR1C1, getFormulaStringValue, getHorizontalAlignment, getIgnoreErrorOptions, getIndentLevel, getInnerFormulaDateTime, getLastColumn, getLastRow, getMergeArea, getNumberFormat, getNumberText, getNumberValue, getRangeAddress, getRangeAddressLocal, getRangeGlobalAddress, getRangeR1C1Address, getRangeR1C1AddressLocal, getRichText, getRow, getRowGroupLevel, getRowHeight, getRows, getStyle, getText, getTimeSpanValue, getValue, getValue2, getVerticalAlignment, getWorksheet, hasBoolean, hasDataValidation, hasDateTime, hasError, hasExternalFormula, hasFormula, hasFormulaArray, hasFormulaBoolValue, hasFormulaDateTime, hasFormulaErrorValue, hasFormulaNumberValue, hasFormulaStringValue, hasMerged, hasNumber, hasRichText, hasString, hasStyle, intersect, isBlank, isFormulaHidden, isGroupedByColumn, isGroupedByRow, isInitialized, isStringsPreserved, isStringsPreserved, isWrapText, isWrapText, merge, merge, merge, set, setBooleanValue, setBuiltInStyle, setFormulaNumberValue, setFormulaStringValue, setIgnoreErrorOptions, setObjectValue, setValue, setVerticalAlignment, unMerge

Method Detail

getNewRangeLocation

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

Gets new address of range.

Parameters:

names - HashTable with Worksheet names.

strSheetName - String that sets as a worksheet name.

Returns:

Returns string with new name.

deepClone

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

Clones current IXLSRange.

Parameters:

parent - Parent object.

hashNewNames - Hash table with new names.

book - Parent workbook.

Returns:

Returns clone of current instance.

clearConditionalFormats

void clearConditionalFormats()

Clears conditional formats.

getRectangles

java.awt.Rectangle[] getRectangles()

Returns array that contains information about range.

Returns:

Rectangles that describes range

getRectanglesCount

int getRectanglesCount()

Returns number of rectangles returned by GetRectangles method.

Returns:

Number of rectangles returned by GetRectangles method.

getCellsCount

int getCellsCount()

Number of cells in the range. Read-only.

getRangeGlobalAddress2007

java.lang.String getRangeGlobalAddress2007()

Gets address global in the format required by Excel 2007.

getWorksheetName

java.lang.String getWorksheetName()

Gets name of the parent worksheet.