View Ticket
Not logged in
Ticket Hash: ef15b9bf7a54666ab01dac82d662bb17e6fa8ec3
Title: Cannot get cell value with multiple language character
Status: Open Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Resolution: Open
Last Modified: 2024-08-16 09:59:07
Version Found In: 2.0.0
User Comments:
anonymous added on 2024-08-14 07:46:29:

I cannot get cell whole text value from .xlsx cell. for example: in cell a mixed multiple language text is "abc文字" then open with freexl 2.0.0 will be just "abc" and the other language text will lost.


anonymous added on 2024-08-16 09:59:07:

UPDATE: it only happend when open a .xlsx file which created by LibreOffice.but not Excel.so if I look into the sharedStrings.xml if created by ms-excel:

<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="2" uniqueCount="2">
<si>
<t>abc中文</t>
<phoneticPr fontId="1" type="noConversion"/>
</si>
<si>
<t>123中文</t>
<phoneticPr fontId="1" type="noConversion"/>
</si>
</sst>
but LibreOffie would be:
<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="2" uniqueCount="2">
<si>
<t>中文</t>
<phoneticPr fontId="1" type="noConversion"/>
<t>abc</t>
<phoneticPr fontId="1" type="noConversion"/>
</si>
<si>
<t>123</t>
<phoneticPr fontId="1" type="noConversion"/>
<t>中文</t>
<phoneticPr fontId="1" type="noConversion"/>
</si>
</sst>
so maybe need a XML parser fix for the tag depth?