Issue 119911

Summary: Open .xlsx file in OO3.4, the special character in it will be shown as its hex-code.
Product: Calc Reporter: Shan Zhu <shanzhu33>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: binbjguo, damjan
Version: 3.4.0Keywords: interop_OOXML
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.2.0-dev
Developer Difficulty: ---
Attachments:
Description Flags
a .xlsx file with right arrow special character in none

Description Shan Zhu 2012-06-08 05:58:59 UTC
Created attachment 78180 [details]
a .xlsx file with right arrow special character in

Build info: AOO3.4_1327774

Steps:
Open the sample file attached in OO3.4, which has the special character (right arrow) in cell E3.

Issue:
The character (right arrow) will be displayed as its hexadecima unicode value Say, "_X001A."
Comment 1 binguo 2012-06-12 09:03:23 UTC
This bug can repros on AOO3.4.O Rev. 1327774,
and I change the status from Unconfirmed to confirmed.
Comment 2 damjan 2023-01-10 03:58:58 UTC
Still an issue in the latest Git.

Further reading: https://www.robweir.com/blog/2008/03/ooxmls-out-of-control-characters.html