HotXLS Delphi Excel Read Write Library / Component Developers Guide loslab Inc.

Solid method

Set 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 convert fill of comment to default solid fill.

Var Comment: TXLSComment;
begin
  With Workbook.Sheets[1] do begin
    Comment := Range['C3', 'C3'].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©2007-2019 loslab.com