Table of Contents

ExcelFile.ConditionallyModifyFormat Method

Overloads

ExcelFile.ConditionallyModifyFormat(TFlxFormat, Int32, Int32, TDrawingConditionalFormat)

Modifies the format of the specified cell if it has a conditional format active. Returns a modified format with the applied conditional format if there was any change, null otherwise.

Syntax

Namespace: FlexCel.Core

public TFlxFormat ConditionallyModifyFormat(TFlxFormat format, Int32 row, Int32 col, out TDrawingConditionalFormat extraInfo)

Parameters

<-> Parameter Type Description
format TFlxFormat Original format of the cell.
row Int32 Row of the cell (1 based)
col Int32 Column of the cell (1 based)
out extraInfo TDrawingConditional​Format Extra information about the format of the cell, like if it has to draw an icon or a databar.

Returns

If the format is modified by a conditional format, it returns the new format. If there are no changes returns null, to avoid creating new instances of TFlxFormat.

See also

ExcelFile.ConditionallyModifyFormat(TFlxFormat, Int32, Int32, Boolean, TDrawingConditionalFormat)

Modifies the format of the specified cell if it has a conditional format active. Returns a modified format with the applied conditional format if there was any change, null otherwise.

Syntax

Namespace: FlexCel.Core

public abstract TFlxFormat ConditionallyModifyFormat(TFlxFormat format, Int32 row, Int32 col, Boolean includeTables, out TDrawingConditionalFormat extraInfo)

Parameters

<-> Parameter Type Description
format TFlxFormat Original format of the cell.
row Int32 Row of the cell (1 based)
col Int32 Column of the cell (1 based)
includeTables Boolean If true and the cell is inside a table, the format for the table will be also taken in account.
out extraInfo TDrawingConditional​Format Extra information about the format of the cell, like if it has to draw an icon or a databar.

Returns

If the format is modified by a conditional format, it returns the new format. If there are no changes returns null, to avoid creating new instances of TFlxFormat.

See also