HotXLS BelgeleriİçindekilerXLSX Facade
Ana sayfaİçindekilerTXLSXWorksheet
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 üyeleri
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
Örnek
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;
Ayrıca bkz.
Copyright © 2010-2026 losLab Software