[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
tarix09.01.2022
ölçüsü3,69 Mb.
#95757
1   ...   52   53   54   55   56   57   58   59   ...   180
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ş:
1   ...   52   53   54   55   56   57   58   59   ...   180




Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©muhaz.org 2024
rəhbərliyinə müraciət

gir | qeydiyyatdan keç
    Ana səhifə


yükləyin