- changed title to OpenXML Filter: XLSX: mark columns as metadata
- edited description
OpenXML Filter: XLSX: mark columns as metadata
Issue #1062
resolved
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:
Comments (6)
-
reporter -
reporter - edited description
-
reporter A solution was added to pull request #552.
-
reporter Other UIs for consideration.
With unmerged cells:
With merged cells:
A related document was added to the code base.
-
reporter 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>
-
reporter - changed status to resolved
Pull request #552 was merged.
- Log in to comment