Bug #96420 Data conversion for Excel xml export
Submitted: 3 Aug 2019 10:55 Modified: 3 Oct 2019 11:58
Reporter: Finn Nielsen Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version:8.0.17 OS:Windows (10)
Assigned to: CPU Architecture:Any
Tags: Excel, export, XML

[3 Aug 2019 10:55] Finn Nielsen
Description:
A small issue when exporting as "Excel spreadsheet (*.xml)".

Some data needs to be converted for xml.
For instance angle brackets like "<Some text>".

Excel will save the data as (2003 xml):
  <Cell><Data ss:Type="String">&lt;Some text&gt;</Data></Cell>

WB will do:
  <Cell><Data ss:Type="String"><Some text></Data></Cell>
and Excel fails to open the file.

This is done by WB / Windows 10 (danish) and MS Excel 365 (danish).

How to repeat:
Export table containing angle bracket in text data to "Excel spreadsheet (*.xml)".
[3 Oct 2019 11:58] MySQL Verification Team
Hello Finn Nielsen,

Thank you for the feature request!
IMHO this is duplicate of Bug #92491, please see Bug #92491.
Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Regards,
Ashwini Patil
[26 Nov 2019 5:42] MySQL Verification Team
Bug #97761 Marked as duplicate of this one.