Missing conditional formats (Excel2007)

PHPOffice / PHPExcel

ARCHIVED

Other

11.46k stars 4.19k forks source link

Missing conditional formats (Excel2007) #126

Open msbit opened 11 years ago

msbit commented 11 years ago

I've encountered a few conditional formats that are ignored in Excel2007.php:1046-1052 when reading an Excel2007 formatted file.

SimpleXMLElement Object
(
    [@attributes] => Array
        (
            [type] => notContainsBlanks
            [dxfId] => 124
            [priority] => 14
        )

    [formula] => LEN(TRIM(B35))>0
)

SimpleXMLElement Object
(
    [@attributes] => Array
        (
            [type] => containsBlanks
            [dxfId] => 117
            [priority] => 1
        )

    [formula] => LEN(TRIM(F41))=0
)

MarkBaker commented 11 years ago

Currently, conditional formatting only supports the basic types of

none
cellIs
containsText
expression

The following types are ignored

aboveAverage
beginsWith
colorScale
containsBlanks
containsErrors
dataBar
duplicateValues
endsWith
iconSet
notContainsBlanks
notContainsErrors
notContainsText
timePeriod
top10
uniqueValues

marthom commented 10 years ago

Any news?

type "dataBar"

<conditionalFormatting sqref="A1:A3">
    <cfRule type="dataBar" priority="1">
        <dataBar>
            <cfvo type="min" val="0"/>
            <cfvo type="max" val="0"/>
            <color rgb="FFFF555A"/>
        </dataBar>
    </cfRule>
</conditionalFormatting>