Saving files in older formats 4.0

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
ikosoft
Posts: 4
Joined: Fri Dec 28, 2007 9:39 am

Saving files in older formats 4.0

Post by ikosoft »

Hi,
I'm using XLSReadWriteII 3.01.02 and I'm trying to create a XLS file in older Excel 4.0 format. I save the file, but when opened it with Excel, in every cell where i had written string in Bulgarian, the last symbol of string is missing, and there is additional symbol in first place of string. When I change the type of excel file - instead xvExcel40 use xvExcel97 the things are all right.
Can you help me with this?
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Post by larsa »

Hello

Your string probably contains unicode characters. You have to convert the unicode characters to single byte characters first, according to the codepage used.


Lars Arvidsson
F-Laurent
Posts: 1
Joined: Tue Mar 11, 2008 3:45 pm

Problem to convert Unicode

Post by F-Laurent »

I have the same problem.
I have to try to convert my strings from unicode to single byte characters first.
For that, I have to use the delphi functions "WideCharToString" and "WideCharToStrVar" but the problem is always present.
Have you a small example to describe how resolve the problem?

Thank you for your help.
Best regards.
Post Reply