XLSX-Workbook-Class
XLSX-Workbook-Class copied to clipboard
OpenXlsxWorkbookEx: empty string when the cell contains "<"
Hello!
Thank you for your great program!
When OpenXlsxWorkbookEx fills the cursor xl_tmpstrings it already makes the translation from xml to normal text, thus substituting, for instance, "<" by "<". When it wants to fill xl_sheetcells, it calls again GetStringXML but since the text already contains "<", the code
this.oXDOM.loadXML("<value>" + tcString + "</value>")
this.oXDOM.Text
returns an empty string.