public TFlxFormat GetColor2(TFlxFormat obj) { TFlxFillPattern pattern = new TFlxFillPattern(); pattern.FgColor = Colors.LightGray; pattern.Pattern = TFlxPatternStyle.Solid; TFlxBorders border = new TFlxBorders(); border.SetAllBorders(TFlxBorderStyle.Thin, Colors.Black); obj.FillPattern = pattern; obj.Borders = border; return obj; }
private int ColorOnly(XlsFile xls, int row, int col) { TFlxFormat tf4 = xls.GetCellVisibleFormatDef(row, col); TFlxFillPattern tfpattern3 = new TFlxFillPattern(); tfpattern3.BgColor = Colors.LightGray; tf4.FillPattern = tfpattern3; return xls.AddFormat(tf4); }
private int ColorAndRightBorder(XlsFile xls, int row, int col) { TFlxFormat tf4 = xls.GetCellVisibleFormatDef(row, col); TFlxFont tfont = new TFlxFont(); tfont.Style = TFlxFontStyles.Bold; tf4.Font = tfont; TFlxBorders tfBorderF1 = new TFlxBorders(); TFlxOneBorder oborder1 = new TFlxOneBorder(); oborder1.Style = TFlxBorderStyle.Thin; tfBorderF1.Right = oborder1; tf4.Borders = tfBorderF1; TFlxFillPattern tfpattern3 = new TFlxFillPattern(); tfpattern3.BgColor = Colors.LightGray; tf4.FillPattern = tfpattern3; return xls.AddFormat(tf4); }
private int ColorBold(XlsFile xls, int row, int col) { TFlxFormat tf4 = xls.GetCellVisibleFormatDef(row, col); TFlxFont tfont = new TFlxFont(); tfont.Style = TFlxFontStyles.Bold; tf4.Font = tfont; TFlxFillPattern tfpattern3 = new TFlxFillPattern(); tfpattern3.BgColor = Colors.LightGray; tf4.FillPattern = tfpattern3; return xls.AddFormat(tf4); }
private int ColorAndLeftBorder(XlsFile xls, int row, int col) { TFlxFormat tf4 = xls.GetCellVisibleFormatDef(row, col); tf4.HAlignment = THFlxAlignment.left; TFlxBorders tfBorderF1 = new TFlxBorders(); TFlxOneBorder oborder1 = new TFlxOneBorder(); oborder1.Style = TFlxBorderStyle.Thin; tfBorderF1.Left = oborder1; tf4.Borders = tfBorderF1; TFlxFillPattern tfpattern3 = new TFlxFillPattern(); tfpattern3.BgColor = Colors.LightGray; tf4.FillPattern = tfpattern3; return xls.AddFormat(tf4); }