Page 1 of 1

problem reading XLSX with special character in cell value

Posted: Mon Aug 29, 2016 12:44 pm
by Camille.Leflon
Hello,

I have a xlsx file with a cell value ending with CR character.
When I read this value with XLSReadWrite (even last version), I get "_x000D_" at the end of cell value.

Could you do a fix ?
I'll send you the file by email, the cell is B26.

Thanks,
Camille

Re: problem reading XLSX with special character in cell value

Posted: Thu Sep 01, 2016 7:54 am
by larsa
Hello

Sorry, there is no easy solution to this. Decoding the encoded character value is not an option as this causes other problems. If you want to remove the encoding, you can easily create a decoding function. The nnnn in _xnnnn_ is the unicode value of the character.