HotXLS-dokumentasjonInnholdXLSX Facade
HjemInnholdTXLSXWorksheet
TXLSXConditionalFormat and TXLSXConditionalFormats classes
TXLSXConditionalFormats is the rule collection exposed by TXLSXWorksheet.ConditionalFormats and supports cell, visual, text, ranking and average rules
Collection methods
function Add(const ARange: WideString; AOp: TXLSXCfOperator; const AFormula1: WideString): Integer;
function AddDataBar(const ARange: WideString; AColor: LongWord; AMinKind: TXLSCfValueKind; const AMinValue: WideString; AMaxKind: TXLSCfValueKind; const AMaxValue: WideString): Integer;
function AddColorScale2(...): Integer;
function AddColorScale3(...): Integer;
function AddIconSet(const ARange: WideString; ASetType: TXLSIconSetType): Integer;
function AddExpression(const ARange, AFormula: WideString): Integer;
function AddTextRule(const ARange: WideString; AKind: TXLSCfKind; const AText: WideString): Integer;
function AddTop10(const ARange: WideString; ARank: Integer; ABottom, APercent: Boolean): Integer;
function AddAboveAverage(const ARange: WideString; AAbove: Boolean): Integer;
function AddSimpleRule(const ARange: WideString; AKind: TXLSCfKind): Integer;
Rule medlemmer
Range, Op, Formula1 and Formula2Define a standard cell comparison rule
StyleLazy differential format used by cell and expression rules
DataBar, ColorScale and IconSetVisual payloads for their respective rule kinds
Priority and StopIfTrueControl worksheet rule order and short-circuit behaviour
Text, Rank, Percent, Bottom and AboveAverageParameters for text, top or bottom and average rules
TimePeriodRelative-date band for time-period rules
Eksempel
var Index: Integer;
begin
Index := Sheet.ConditionalFormats.AddExpression('B2:B100', 'B2<0');
Sheet.ConditionalFormats[Index].Style.SetFillBgColor($0000FF);
Sheet.ConditionalFormats.AddColorScale3('C2:C100', $0000FF, $00FFFF, $00FF00, cfvMinOfRange, '', cfvPercentile, '50', cfvMaxOfRange, '');
end;
Se også
Copyright © 2010-2026 losLab Software