ApplyRows

[thefreecat]

Hello,

I am using the demo from XlsRWII/5 "SampleFormatCells".

I try to define a default format :

XLS.CmdFormat.BeginEdit(Nil);
XLS.CmdFormat.Fill.BackgroundColor.RGB := $7F7F10;
XLS.CmdFormat.Font.Name := 'Courier new';
XLS.CmdFormat.AddAsDefault('F1');

...and then apply that format to rows 1 to 5 :

XLS.CmdFormat.BeginEdit(XLS[0]);
XLS.DefaultFormat := XLS.CmdFormat.Defaults.Find('F1');
XLS.CmdFormat.ApplyRows(1,5);

But nothing happens. What is the proper way of applying a default format to several rows ?

Thanks,

JC

[larsa]

Hello

Default formats are only used when you add cells, they will not work with rows.

[thefreecat]

Thanks for your quick answer Lars