Interface IXLPivotValueStyleFormat

Namespace

SlapKit.Excel.Excel

Assembly

SlapKit.Excel.dll

public interface IXLPivotValueStyleFormat : IXLPivotStyleFormat

Inherited Members

IXLPivotStyleFormat.AppliesTo

IXLPivotStyleFormat.PivotField

IXLPivotStyleFormat.Style

Extension Methods

AttributeExtensions.GetMethod<T>(T, Expression<Action<T>>)

AttributeExtensions.GetMethod<T>(T, Expression<Func<T, object>>)

Methods

AndWith(IXLPivotField)

IXLPivotValueStyleFormat AndWith(IXLPivotField field)

Parameters

field IXLPivotField

Returns

IXLPivotValueStyleFormat

AndWith(IXLPivotField, Predicate<XLCellValue>)

Adds a further limitation so the Style is only applied to cells in a pivot table that are are within the field that has some values.

IXLPivotValueStyleFormat AndWith(IXLPivotField field, Predicate<XLCellValue> predicate)

Parameters

field IXLPivotField

Only cells in a pivot table under this field will be styled.

predicate Predicate<XLCellValue>

A predicate to determine which index of the field should be styled.

Returns

IXLPivotValueStyleFormat

Remarks

The pivot style is bound by the field index in a pivot table, not field value. E.g. if field values are Jan, Feb and the predicate marks Feb (offset 1) = second field (Feb) will be highlighted. If user later reverses order in Excel to Feb, Jan, the style would still apply to the second value - Jan.

ForValueField(IXLPivotValue)

IXLPivotValueStyleFormat ForValueField(IXLPivotValue valueField)

Parameters

valueField IXLPivotValue

Returns

IXLPivotValueStyleFormat