problem reading XLSX with special character in cell value

[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

[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.