com.spire.xls.core
Interface IConditionalFormatsCollection

All Known Implementing Classes:

WorksheetConditionalFormats, XlsWorksheetConditionalFormats

public interface IConditionalFormatsCollection

Represents IConditionalFormatsCollection.

Method Summary

XlsConditionalFormats	add() Adds new item to the collection.
XlsConditionalFormats	add(XlsConditionalFormats formats) Adds new item to the collection.
void	copyFrom(XlsWorksheetConditionalFormats srcFormats) Copies conditional formats from another formats collection.
XlsConditionalFormats	find(java.awt.Rectangle[] arrRanges) Search for collection that contains all specified ranges.
XlsConditionalFormats[]	findAll(java.awt.Rectangle[] arrRanges)
XlsConditionalFormats	get(int fieldIndex) Gets object at the special field.
XlsConditionalFormats	getByIndex(int index) Returns a single Filter object from a collection.
void	remove(java.awt.Rectangle[] arrRanges) Removes range from the collection of conditional formats.
void	removeAt(int index)

Method Detail

get

XlsConditionalFormats get(int fieldIndex)

Gets object at the special field.

Parameters:

fieldIndex - The integer offset of the field on which you want to base the filter (from the left of the list; the leftmost field is field 0).

Returns:

Returens object.

add

XlsConditionalFormats add()

Adds new item to the collection.

Returns:

add

XlsConditionalFormats add(XlsConditionalFormats formats)

Adds new item to the collection.

Parameters:

formats - Item to add.

Returns:

Object that contains required cells.

copyFrom

void copyFrom(XlsWorksheetConditionalFormats srcFormats)

Copies conditional formats from another formats collection.

Parameters:

srcFormats - Source collection of conditional formats to copy.

find

XlsConditionalFormats find(java.awt.Rectangle[] arrRanges)

Search for collection that contains all specified ranges.

Parameters:

arrRanges -

Returns:

findAll

XlsConditionalFormats[] findAll(java.awt.Rectangle[] arrRanges)

getByIndex

XlsConditionalFormats getByIndex(int index)

Returns a single Filter object from a collection.

remove

void remove(java.awt.Rectangle[] arrRanges)

Removes range from the collection of conditional formats.

Parameters:

arrRanges - Array of ranges to remove.

removeAt

void removeAt(int index)

Parameters:

index -