Bug in XLSREadWriteII5, fixed in 6?

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
jdorlon
Posts: 15
Joined: Wed Jan 13, 2010 7:24 pm

Bug in XLSREadWriteII5, fixed in 6?

Post by jdorlon »

Hello,

If I send ascii characters 28 and 29 to a text field in XLSReadWriteII5, then when I open the document in Excel 365, I get an error message and excel asking me if I want to attempt to repair the file.

You can test it with this code:

Code: Select all

var
  XLS: TXLSReadWriteII5;
begin
  XLS := TXLSReadWriteII5.Create(nil);
  XLS.Version := xvExcel2007;
  XLS.Sheets[0].AsString[0,1] := CHR(28) + '!!!TRIAL/PROSPECT ACCT=>LEGAL DOCS, CREDIT CHECKS, NCF & SFDC APPROVALS!!!' + chr(29);
  XLS.SaveToFile('c:\XLSAsciiTest.xlsx');
  ShellExecute(Application.Handle, nil, 'c:\XLSAsciiTest.xlsx', '', '', SW_SHOW);
end;
Can you tell me if this was fixed in XLSReadWriteII6? If so, we will upgrade 5 licenses.

Thanks

John Dorlon
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Bug in XLSREadWriteII5, fixed in 6?

Post by larsa »

Hello

Yes, this is fixed in version 6.
Lars Arvidsson, Axolot Data
jdorlon
Posts: 15
Joined: Wed Jan 13, 2010 7:24 pm

Re: Bug in XLSREadWriteII5, fixed in 6?

Post by jdorlon »

Thank you Lars.
jdorlon
Posts: 15
Joined: Wed Jan 13, 2010 7:24 pm

Re: Bug in XLSREadWriteII5, fixed in 6?

Post by jdorlon »

Are you sure? I just downloaded a trial of version 6 to test, but I still get the error.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Bug in XLSREadWriteII5, fixed in 6?

Post by larsa »

Hello

Yes, I just tested again with the code above and there is no error. Please check the ComponentVersion property at runtime to make sure you have the correct version installed. It shall be 6.00.67
Lars Arvidsson, Axolot Data
jdorlon
Posts: 15
Joined: Wed Jan 13, 2010 7:24 pm

Re: Bug in XLSREadWriteII5, fixed in 6?

Post by jdorlon »

I just tried again. I have version 6.00.70a and there is no error. Thank you.
Post Reply