- edited description
OpenXML Filter: XLSX: extract inline strings for translation
Worksheets may keep not only references to shared strings and formulas but contain inline strings. Please take a look at the corresponding part below:
<row r="2" spans="1:1" x14ac:dyDescent="0.25">
<c r="A2" t="inlineStr">
<is>
<r>
<t xml:space="preserve">Rich text inline with </t>
</r>
<r>
<rPr>
<sz val="11"/>
<color theme="1"/>
<rFont val="Times New Roman"/>
<family val="1"/>
<charset val="204"/>
</rPr>
<t>Times New Roman</t>
</r>
</is>
</c>
</row>
There is no support for such strings extraction at the moment. For more details please refer to the attached document.
Comments (9)
-
reporter -
reporter The meaning of
bPreferenceTranslateExcelSheetNames
filter parameter has to be taken into account. -
Very strange, I have never seen this structure!
-
If I straight up extract the xlsx file, the inline string part is not extracted. If I open and save it on Excel 2019 first, the inline part is extracted. So I think older version of Excel spins up this issue. The OpenXML filter works best if a user has their Office fully updated. May I know which Excel version you are using to produce this issue, Denis?
-
reporter A related pull request #562 was opened.
-
reporter -
assigned issue to
-
assigned issue to
-
reporter - changed milestone to 1.42.0
-
reporter - changed status to resolved
Pull request #562 was merged.
-
Issue
#1069was marked as a duplicate of this issue. - Log in to comment