Hello,
do you have an excample for a gradient Collor. I tried like this:
procedure TSammle.SetFormatColorGradiant(aXls : TXlsFile; aRow, aCol : integer);
var
FlxFormat : TFlxFormat;
XF : Integer;
ExcelGradient : IExcelGradient;
begin
FlxFormat := aXls.GetFormat(aXls.GetCellFormat(aRow, aCol));
FlxFormat.FillPattern.Pattern := TFlxPatternStyle.Gradient;
ExcelGradient := VCL.FlexCel.Core.TExcelLinearGradient_Create;
FlxFormat.FillPattern.Gradient := ExcelGradient;
FlxFormat.FillPattern.FgColor := Colors.Red;
FlxFormat.FillPattern.BgColor := Colors.Olive;
XF := aXls.AddFormat(FlxFormat);
aXls.SetCellFormat(aRow, aCol, XF);
end;
but this doesn't work.
best regards,
Lothar