OpenXML Filter: XLSX: mark columns as metadata

[Denis Konovalyenko]

Depends on the resolution of issue #1061.

The marked metadata columns should be excluded from translation and header values (metadata rows) should be used for context types in context groups:

    <group>
      <context-group>
        <context context-type="Category 1">C1</context>
        <context context-type="Category 2">C2</context>
      </context-group>
      <trans-unit id="tu1" resname="Sheet1!A2">
        <source>Item 1</source>
      </trans-unit>
      <trans-unit id="tu2" resname="Sheet1!B2">
        <source>Item 1 description</source>
      </trans-unit>
    </group>

The following configuration options can be used:

worksheetConfigurations.number.i=1
worksheetConfigurations.0.namePattern=My workheet name
worksheetConfigurations.0.metadataRows=1
worksheetConfigurations.0.metadataColumns=B,C

UI examples:

‌

[Denis Konovalyenko]

A solution was added to pull request #552.

[Denis Konovalyenko]

Other UIs for consideration.

With unmerged cells:

With merged cells:

A related document was added to the code base.

[Denis Konovalyenko]

If no metadata row is specified, matching metadata column names are used to form content types.

Thus, for the mentioned spreadsheet:

with C,D,E,F columns as metadata the 6th row group will have:

<context-group name="row-metadata">
 <context context-type="x-C;D;E">C6:E6</context>
 <context context-type="x-F">F6:G6</context>
</context-group>

‌

[Denis Konovalyenko]

Pull request #552 was merged.