OpenXML Filter: XLSX: provide support for a limitied form of multilingaul translation

The feature can be implemented with the help of source and target columns. If A,B columns are configured as sources and C,D ones as targets, then A column is copied over C, B - over D, and C,D columns are extracted for translation.

Let’s consider the following example.

If A is a source column and B is a target one, then the following XLIFF should be available:

<group id="P76C545-sg1" resname="Sheet1">
<group id="P132303AB-sg1" resname="1">
<trans-unit id="P147242AB-tu1" resname="Sheet1!B1" xml:space="preserve">
<source xml:lang="en"><g id="1" ctype="x-bold;fonts:Calibri;" equiv-text="&lt;run1>">Formatted</g> text</source>
<target xml:lang="fr"></target>
</trans-unit>
<trans-unit id="P147242AB-tu2" resname="Sheet1!C1" xml:space="preserve">
<source xml:lang="en">c1</source>
<target xml:lang="fr"></target>
</trans-unit>
</group>
<group id="P132303AB-sg2" resname="2">
<trans-unit id="P147242AB-tu3" resname="Sheet1!C2" xml:space="preserve">
<source xml:lang="en">c2</source>
<target xml:lang="fr"></target>
</trans-unit>
</group>
<group id="P132303AB-sg3" resname="3">
<trans-unit id="P147242AB-tu4" resname="Sheet1!B3" xml:space="preserve">
<source xml:lang="en">Text</source>
<target xml:lang="fr"></target>
</trans-unit>
<trans-unit id="P147242AB-tu5" resname="Sheet1!C3" xml:space="preserve">
<source xml:lang="en">c3</source>
<target xml:lang="fr"></target>
</trans-unit>
</group>
</group>

A sample document can be found attached.

Comments (2)