Dokumentacija HotXLS Vsebina Domov Pregled IXLSWorkbook TCondFormat Domov Vsebina Pregled

AddCondFormatDataBar metoda

Adds an Excel 2007+ Data Bar conditional formatting rule over a cell range, returning the new TCondFormatRule so the rule's per-stop tuning can be refined before save. Internally creates a CONDFMT12 block and a CF12 record on BIFF8 save; for XLSX output the same rule is rendered through the OOXML <cfRule type="dataBar"> element. (Available since v2.34.0.)

Skladnja

function AddCondFormatDataBar(const ARange: WideString;
  AColor: LongWord;
  AMinKind: TXLSCfValueKind = cfvMinOfRange; const AMinValue: WideString = '';
  AMaxKind: TXLSCfValueKind = cfvMaxOfRange; const AMaxValue: WideString = ''): TCondFormatRule; ARange WideString. Sqref string, e.g. 'A1:A10' or 'B2:C20' AColor LongWord. Bar fill color in Delphi BGR format (R in the low byte). For a blue fill use $00FF0000; for green $0000FF00 AMinKind / AMaxKind TXLSCfValueKind. Threshold types: cfvNumber, cfvMinOfRange, cfvMaxOfRange, cfvPercent, cfvPercentile, cfvFormula, cfvAutoMin, cfvAutoMax. Defaults map min→cfvMinOfRange and max→cfvMaxOfRange, matching Excel's default "automatic" bar bounds AMinValue / AMaxValue WideString. Threshold literal (numeric text for cfvNumber/cfvPercent/cfvPercentile, A1-range or formula text for cfvFormula). Ignored for cfvMinOfRange / cfvMaxOfRange / cfvAutoMin / cfvAutoMax

Primer

This example adds a blue data bar over A1:A10 using the default min/max-of-range bounds
Sheet.AddCondFormatDataBar('A1:A10', $00FF0000);

AddCondFormatDataBar metoda

Skladnja

Primer

Glej tudi