XLSX-Workbook-Class icon indicating copy to clipboard operation
XLSX-Workbook-Class copied to clipboard

OpenXlsxWorkbookEx: empty string when the cell contains "<"

Open foxproc opened this issue 4 months ago • 6 comments

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.

foxproc avatar Oct 07 '24 14:10 foxproc