Bug in XLSREadWriteII5, fixed in 6?
Posted: Wed Sep 25, 2019 1:59 pm
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:
Can you tell me if this was fixed in XLSReadWriteII6? If so, we will upgrade 5 licenses.
Thanks
John Dorlon
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;Thanks
John Dorlon