oo has a test sheet:

http://www.openoffice.org/sc/testdocs/condformat_import_xml_12.xlsx

Note: this file contains formulas even for things like "containsErrors".
We do not write that -- need to check what Excel does.

    <cfRule type="containsText" dxfId="77" priority="36" operator="containsText" te
xt="DE">
      <formula>NOT(ISERROR(SEARCH("DE",B18)))</formula>
    </cfRule>
    <cfRule type="notContainsText" dxfId="76" priority="35" operator="notContains" text="DE">
      <formula>ISERROR(SEARCH("DE",B19))</formula>
    </cfRule>

The above match our alternate expressions.


   <cfRule type="beginsWith" dxfId="75" priority="34" operator="beginsWith" text="DE">
      <formula>LEFT(B20,2)="DE"</formula>
    </cfRule>
    <cfRule type="endsWith" dxfId="74" priority="33" operator="endsWith" text="DE">
      <formula>RIGHT(B21,2)="DE"</formula>
    </cfRule>

The above use "=", not "EXACT".  We are case sensitive, Excel probably not.


    <cfRule type="containsBlanks" dxfId="63" priority="20">
      <formula>LEN(TRIM(B39))=0</formula>
    </cfRule>
    <cfRule type="notContainsBlanks" dxfId="62" priority="19">
      <formula>LEN(TRIM(B40))&gt;0</formula>
    </cfRule>

Totally different from our.  We check for *any*, the above checks for *all*.



   <cfRule type="containsErrors" dxfId="61" priority="18">
      <formula>ISERROR(B41)</formula>
    </cfRule>
    <cfRule type="notContainsErrors" dxfId="60" priority="17">
      <formula>NOT(ISERROR(B42))</formula>
    </cfRule>

Matches what we do.



    <cfRule type="endsWith" dxfId="45" priority="1" operator="endsWith" text="&quot;D&quot;">
      <formula>RIGHT(B22,3)="""D"""</formula>
    </cfRule>

What's up with the tripple quotes?