Problem during XLS-file created in v4 are being readed in v5
Posted: Fri Jan 03, 2014 2:33 pm
I have an XLS file contain Unicode characters generated in XLSReadWriteII 4.
We changed to XLSReadWriteII 5 and would like to read this file but we have problems with some cells.
By debugging reading process we found that in this cells two-byte Unicode characters were transformed to two two byte characters, one for the low and one for the high byte of original Unicode character (e.g. character x041F is transformed to x0004 and x001F).
XLSReadWriteII 4 can handle this cells, it read the content of these as a normal WideString with good two-bytes Unicode characters.
XLSReadWriteII 5 can read only the half of the string (because it reads the original count of characters but each character is duplicated) and it contains zero characters after every character which is less than xFF (because the higher byte is converted to a two-byte zero character).
Could you tell me, how can I read these files in XLSReadWrite II 5?
We changed to XLSReadWriteII 5 and would like to read this file but we have problems with some cells.
By debugging reading process we found that in this cells two-byte Unicode characters were transformed to two two byte characters, one for the low and one for the high byte of original Unicode character (e.g. character x041F is transformed to x0004 and x001F).
XLSReadWriteII 4 can handle this cells, it read the content of these as a normal WideString with good two-bytes Unicode characters.
XLSReadWriteII 5 can read only the half of the string (because it reads the original count of characters but each character is duplicated) and it contains zero characters after every character which is less than xFF (because the higher byte is converted to a two-byte zero character).
Could you tell me, how can I read these files in XLSReadWrite II 5?