Table mappings & style extensions

Taken from Excel or Word:
- Cell alignment
- bold / italic
- number formatting
- relative width of table columns (can be overrules)
Map table styles in Excel and Word to template styles with style name or alias. Start name with “Table.” For non-styled cell template style “Table.Standard” is used (or “Standard” if not available).
Use border-top / bottom / left / right styles for borders
Use filters to map styles to background-color

Template extensions

Element border-top / border-bottom / border-left / border-right
Border attributes
- color
  color of border
- width
  width of border
Element filter
Map table style layout to extra styling. Inside the filter element all style elements are allowed.
Attributes:
- type
  optional: possible value: not (=inverse)
- background-color
  rgb value of cell background in Excel/Word
Table styles with special meaning:
- Heading 1: table heading
- Total: row with totals
- SubTotal: row with subtotals or sums
- Layout (first row in table)
  Relative width of columns

Example

    <styles>
       <style name="tabel-text">
            <color html="#000000" cmyk="0,0,0,100"/>
            <font-family html="arial" pdf="helvetica_neue_lt_std_55_roman"/>
            <font-size html="12px" pdf="10pt"/>
            <line-height html="14px" pdf="12pt"/>
            <font-style html="normal" pdf="normal"/>
            <font-weight html="normal" pdf="normal"/>
            <letter-spacing html="0px" pdf="0px"/>
            <filter type="not" background-color="#000000">
                <setting name="type" optionvalue="type1">
                    <background-color html="#da8a19" cmyk="0,13,25,0"/>
                </setting>
                ....
            </filter>
             <alias name="Table.Standard"/>
        </style>
        <style name="Tabel_header">
            <color html="#ffffff" cmyk="0,0,0,0"/>
            <font-family html="arial" pdf="helvetica_neue_lt_std_75_bold"/>
            ....
            <setting name="type" optionvalue="type1">
                <background-color html="#da8a19" cmyk="0,53,100,0"/>
            </setting>
            ...
            <alias name="Table.Heading 1"/>
        </style>
        <style name="Tabel_som">
            <color html="#ffffff" cmyk="0,0,0,100"/>
            <border-top>
                <width html="1px" pdf="0.5pt"/>
                <setting name="type" optionvalue="type1">
                    <color html="#da8a19" cmyk="0,53,100,0"/>
                </setting>
                ....   
            </border-top>
            <font-family html="arial" pdf="helvetica_neue_lt_std_75_bold"/>
            <font-size html="12px" pdf="10pt"/>
            <line-height html="14px" pdf="12pt"/>
            <font-style html="normal" pdf="normal"/>
            <font-weight html="normal" pdf="normal"/>
            <letter-spacing html="0px" pdf="0px"/>
            <text-align html="left" pdf="left"/>
            <alias name="Table.SubTotal"/>
        </style>
     </styles>

Example files excel:

Example files Word: