Bug in XLSREadWriteII5, fixed in 6?

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

Hello

Yes, this is fixed in version 6.

[jdorlon]

Thank you Lars.

[jdorlon]

Are you sure? I just downloaded a trial of version 6 to test, but I still get the error.

[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

[jdorlon]

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