[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format

Interpretation of the formulas in f

Yüklə 3,69 Mb. səhifə 56/180 tarix 09.01.2022 ölçüsü 3,69 Mb. #95757

Interpretation of the formulas in f

cellIs	f elements that specify the formulas, numeric values, or cell references that specify the operands for the ST_ConditionalFormattingOperator ([ISO/IEC29500-1:2011] section 18.18.15) specified by operator. If operator is "between" or "notBetween", f MUST contain two formulas; otherwise, f MUST contain one formula.
expression	An f element that specifies a formula. When the formula returns zero, conditional formatting is not displayed. When the formula returns a nonzero value, conditional formatting is displayed.
colorScale, dataBar, iconSet	An f element that specifies a formula. When the formula returns zero, conditional formatting is not displayed. When the formula returns a nonzero value, or is not present, conditional formatting is displayed.
containsText, notContainsText, beginsWith, endsWith, containsBlanks, notContainsBlanks, containsErrors, notContainsErrors	An f element that specifies a formula that implements the operation specified by type. When the formula returns zero, conditional formatting is not displayed. When the formula returns a nonzero value, conditional formatting is displayed.

colorScale: A CT_ColorScale element that specifies a color scale.

dataBar: A CT_DataBar element that specifies a data bar.

Yüklə 3,69 Mb.

Dostları ilə paylaş: