2.02.33

Latest version news and what is changed.
Post Reply
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

2.02.33

Post by larsa »

+ The speed when adding internal names has improved. Both when adding names in the component, and when the file later is opened with excel. When adding many names, put the code that adds name between calls to BeginUpdate and EndUpdate.
Example:

Code: Select all

    InternalNames.BeginUpdate;
    for i:= 1 to 10000 do
    begin
      XLS.InternalNames.Name:= 'Test'+ IntToStr(i);
      XLS.InternalNames.Definition:= 'Sheet1!$A$' + IntToStr(i);
    end;
    XLS.InternalNames.EndUpdate;
Post Reply