2.1.521 Section 14.1.1, Style Mappings

a.   The standard defines the element <style:map>

This element is not supported in core Word 2007.

This element is not supported for a style applied to any of the following elements:

  • <draw:rect>

  • <draw:line>

  • <draw:polyline>

  • <draw:polygon>

  • <draw:regular-polygon>

  • <draw:path>

  • <draw:circle>

  • <draw:ellipse>

  • <draw:connector>

  • <draw:caption>

  • <draw:measure>

  • <draw:g>

  • <draw:frame>

  • <draw:image>

  • <draw:text-box>

  • <draw:custom-shape>

    This element is not supported on save for text in SmartArt and chart titles and labels.

b.   The standard defines the element <style:map>

This element is not supported for a style applied to any of the following elements:

  • <draw:rect>

  • <draw:line>

  • <draw:polyline>

  • <draw:polygon>

  • <draw:regular-polygon>

  • <draw:path>

  • <draw:circle>

  • <draw:ellipse>

  • <draw:connector>

  • <draw:caption>

  • <draw:measure>

  • <draw:g>

  • <draw:frame>

  • <draw:image>

  • <draw:text-box>

  • <draw:custom-shape>

    This element is not supported on load for text in any of the following elements:

  • <draw:rect>

  • <draw:polyline>

  • <draw:polygon>

  • <draw:regular-polygon>

  • <draw:path>

  • <draw:circle>

  • <draw:ellipse>

  • <draw:caption>

  • <draw:measure>

  • <draw:frame>

  • <draw:text-box>

  • <draw:custom-shape>

    This element is not supported on save for text in any of the following items:

  • text boxes

  • shapes

  • SmartArt

  • chart titles

  • labels

c.   The standard defines the attribute style:apply-style-name, contained within the element <style:map>, contained within the parent element <style:style>

This attribute is supported in core Excel 2007.

  1. Excel 2007 conditional formatting does not support the following formatting:

    alignment formatting

    font size

    font face

    thick and double borders

    diagonal borders

  2. Excel 2007 does not save pattern fills.

d.   The standard defines the attribute style:base-cell-address, contained within the element <style:map>, contained within the parent element <style:style>

This attribute is supported in core Excel 2007.

The value of this attribute is the address of the upper-left cell of the conditional formatting's bounding reference. This attribute may be used in discontiguous ranges with conditional formatting.

e.   The standard defines the attribute style:condition, contained within the element <style:map>, contained within the parent element <style:style>

This attribute is supported in core Excel 2007.

Excel 2007 conditional formatting does not support the following conditions:

  1. "Stop if true" condition; Excel always stops if the condition has been met.

  2. Conditions describing data bars, icon sets, or color scales.

  3. Conditions describing discontiguous ranges for Top 10, Top 10%, Bottom 10, Bottom 10%, Above Average with standard deviation, and Below Average with standard deviation rules.

    Excel 2007 conditional formatting supports the following conditions:

  4. Conditions using the following: is-true-formula, cell-content-is-between, cell-content-is-not-between, and cell-content.

  5. Conditions describing discontinuous ranges for Above and Below Average rules WITHOUT standard deviation.

    Additionally, the following features apply to Excel 2007's treatment of the style:condition attribute in conditional formatting:

  1. Multiple rules with the same criteria could round trip as a single rule.

    1. Some rules will round trip back as a formula instead of a friendly name (like highlight dups).

    f.   The standard defines the element <style:map>

    This element is not supported for a style applied to any of the following elements:

    • <draw:rect>

    • <draw:line>

    • <draw:polyline>

    • <draw:polygon>

    • <draw:regular-polygon>

    • <draw:path>

    • <draw:circle>

    • <draw:ellipse>

    • <draw:connector>

    • <draw:caption>

    • <draw:measure>

    • <draw:g>

    • <draw:frame>

    • <draw:image>

    • <draw:text-box>

    • <draw:custom-shape>

      This element is not supported on load for text in the following elements:

    • <draw:rect>

    • <draw:polyline>

    • <draw:polygon>

    • <draw:regular-polygon>

    • <draw:path>

    • <draw:circle>

    • <draw:ellipse>

    • <draw:caption>

    • <draw:measure>

    • <draw:text-box>

    • <draw:frame>

    • <draw:custom-shape>

Show: