OpenXML Filter: introduce font mappings for XLSX documents

Issue #972 resolved
Denis Konovalyenko created an issue

This is a follow up for issues #926, #937, #958. The already available common font mapping solution has to be applied to the corresponding font properties of the XLSX documents.

Comments (4)

  1. Denis Konovalyenko reporter

    A bit more details on the areas to look at:

    <styleSheet> (§3.8.39) (Style Sheet) (Root element of SpreadsheetML Styles part)
    > <fonts> (§3.8.22) (Fonts)
    > <font> (§3.8.21) (Font)
    > <name> (§3.8.29) (Font Name)
    
    <styleSheet> (§3.8.39) (Style Sheet) (Root element of SpreadsheetML Styles part)
    > <dxfs> (§3.8.15) (Formats)
    > <dxf> (§3.8.14) (Formatting)
    > <font> (§3.8.21) (Font)
    > <name> (§3.8.29) (Font Name)
    
    <revisions> (§3.11.1.16) (Revisions) (Root element of SpreadsheetML Shared Workbook Revision Log part)
    > <rfmt> (§3.11.1.17) (Revision Format)
    > <dxf> (§3.8.14) (Formatting)
    > <font> (§3.8.21) (Font)
    > <name> (§3.8.29) (Font Name)
    
    <revisions> (§3.11.1.16) (Revisions) (Root element of SpreadsheetML Shared Workbook Revision Log part)
    > <rm> (§3.11.1.19) (Revision Cell Move)
    > <rfmt> (§3.11.1.17) (Revision Format)
    > <dxf> (§3.8.14) (Formatting)
    > <font> (§3.8.21) (Font)
    > <name> (§3.8.29) (Font Name)
    
    <revisions> (§3.11.1.16) (Revisions) (Root element of SpreadsheetML Shared Workbook Revision Log part)
    > <rrc> (§3.11.1.21) (Revision Row Column Insert Delete)
    > <rfmt> (§3.11.1.17) (Revision Format)
    > <dxf> (§3.8.14) (Formatting)
    > <font> (§3.8.21) (Font)
    > <name> (§3.8.29) (Font Name)
    
    <revisions> (§3.11.1.16) (Revisions) (Root element of SpreadsheetML Shared Workbook Revision Log part)
    > <rcc> (§3.11.1.9) (Revision Cell Change)
    > <ndxf> (§3.11.1.4) (New Formatting Information)
    > <font> (§3.8.21) (Font)
    > <name> (§3.8.29) (Font Name)
    
    <revisions> (§3.11.1.16) (Revisions) (Root element of SpreadsheetML Shared Workbook Revision Log part)
    > <rm> (§3.11.1.19) (Revision Cell Move)
    > <rcc> (§3.11.1.9) (Revision Cell Change)
    > <ndxf> (§3.11.1.4) (New Formatting Information)
    > <font> (§3.8.21) (Font)
    > <name> (§3.8.29) (Font Name)
    
    <revisions> (§3.11.1.16) (Revisions) (Root element of SpreadsheetML Shared Workbook Revision Log part)
    > <rrc> (§3.11.1.21) (Revision Row Column Insert Delete)
    > <rcc> (§3.11.1.9) (Revision Cell Change)
    > <ndxf> (§3.11.1.4) (New Formatting Information)
    > <font> (§3.8.21) (Font)
    > <name> (§3.8.29) (Font Name)
    
    <revisions> (§3.11.1.16) (Revisions) (Root element of SpreadsheetML Shared Workbook Revision Log part)
    > <rcc> (§3.11.1.9) (Revision Cell Change)
    > <odxf> (§3.11.1.6) (Old Formatting Information)
    > <font> (§3.8.21) (Font)
    > <name> (§3.8.29) (Font Name)
    
    <revisions> (§3.11.1.16) (Revisions) (Root element of SpreadsheetML Shared Workbook Revision Log part)
    > <rm> (§3.11.1.19) (Revision Cell Move)
    > <rcc> (§3.11.1.9) (Revision Cell Change)
    > <odxf> (§3.11.1.6) (Old Formatting Information)
    > <font> (§3.8.21) (Font)
    > <name> (§3.8.29) (Font Name)
    
    <revisions> (§3.11.1.16) (Revisions) (Root element of SpreadsheetML Shared Workbook Revision Log part)
    > <rrc> (§3.11.1.21) (Revision Row Column Insert Delete)
    > <rcc> (§3.11.1.9) (Revision Cell Change)
    > <odxf> (§3.11.1.6) (Old Formatting Information)
    > <font> (§3.8.21) (Font)
    > <name> (§3.8.29) (Font Name)
    
    <worksheet> (§3.3.1.96) (Worksheet) (Root element of SpreadsheetML Worksheet part)
    > <sheetData> (§3.3.1.77) (Sheet Data)
    > <row> (§3.3.1.71) (Row)
    > <c> (§3.3.1.3) (Cell)
    > <is> (§3.3.1.50) (Rich Text Inline)
    <c r="A1">
      <is>
        <t>String</t>
      </is>
    </c>
    > <r> (§3.4.4) (Rich Text Run)
    > <rPr> (§3.4.7) (Run Properties)
    > <rFont> (Font)
    
    <revisions> (§3.11.1.16) (Revisions) (Root element of SpreadsheetML Shared Workbook Revision Log part)
    [...]
    > <rcc> (§3.11.1.9) (Revision Cell Change)
    > <nc> (§3.11.1.3) (New Cell Data)
    > <is> (§3.3.1.50) (Rich Text Inline)
    <c r="A1">
      <is>
        <t>String</t>
      </is>
    </c>
    > <r> (§3.4.4) (Rich Text Run)
    > <rPr> (§3.4.7) (Run Properties)
    > <rFont> (Font)
    
    <revisions> (§3.11.1.16) (Revisions) (Root element of SpreadsheetML Shared Workbook Revision Log part)
    [...]
    <rcc> (§3.11.1.9) (Revision Cell Change)
    > <oc> (§3.11.1.5) (Old Cell Data)
    > <is> (§3.3.1.50) (Rich Text Inline)
    <c r="A1">
      <is>
        <t>String</t>
      </is>
    </c>
    > <r> (§3.4.4) (Rich Text Run)
    > <rPr> (§3.4.7) (Run Properties)
    > <rFont> (Font)
    
    <sst> (§3.4.9) (Shared String Table) (Root element of SpreadsheetML Shared String Table part)
    > <si> (§3.4.8) (String Item)
    > <r> (§3.4.4) (Rich Text Run)
    > <rPr> (§3.4.7) (Run Properties)
    > <rFont> (Font)
    
    <comments> (§3.7.5) (Comments) (Root element of SpreadsheetML Comments part)
    > <commentList> (§3.7.4) (List of Comments)
    > <comment> (§3.7.3) (Comment)
    > <text> (§3.7.6) (Comment Text)
    > <r> (§3.4.4) (Rich Text Run)
    > <rPr> (§3.4.7) (Run Properties)
    > <rFont> (Font) @<val>
    

  2. Log in to comment