NativeExcel suite v1.x

Solid method

Sets the specified fill to a uniform color. Use this method to convert a gradient, textured, patterned, or background fill back to a solid fill.

Syntax

procedure Solid;

Example

This example converts fill on comment to default comment's fill.
Var Comment: TXLSComment;
begin
  ...
  With Workbook.Sheets[1] do begin
    Comment := Range['B2', 'B2'].Comment;
    if Assigned(Comment) then begin
       Comment.Shape.Fill.Visible := true;
       Comment.Shape.Fill.Solid;
       //default background color for comments
       Comment.Shape.Fill.ForeColor.SchemeColor := 80; 
    end;
  end;
  ...
end;
Copyright © NikaSoft 2004-2010