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 TopBorderOnly(XlsFile xls, int row, int col)
{
TFlxFormat tf3 = xls.GetCellVisibleFormatDef(row, col);
TFlxBorders tfBorderF = new TFlxBorders();
TFlxOneBorder oborder = new TFlxOneBorder();
oborder.Style = TFlxBorderStyle.Thin;
tfBorderF.Top = oborder;
tf3.Borders = tfBorderF;
return xls.AddFormat(tf3);
}
private int NoColorAndRightBorder(XlsFile xls, int row, int col)
{
TFlxFormat tf3 = xls.GetCellVisibleFormatDef(row, col);
TFlxFont tfont = new TFlxFont();
tfont.Style = TFlxFontStyles.Bold;
tf3.Font = tfont;
TFlxBorders tfBorderF = new TFlxBorders();
TFlxOneBorder oborder = new TFlxOneBorder();
oborder.Style = TFlxBorderStyle.Thin;
tfBorderF.Right = oborder;
tf3.Borders = tfBorderF;
return xls.AddFormat(tf3);
}
private int NoColorAndLeftBorder(XlsFile xls, int row, int col)
{
TFlxFormat tf3 = xls.GetCellVisibleFormatDef(row, col);
tf3.HAlignment = THFlxAlignment.left;
TFlxBorders tfBorderF = new TFlxBorders();
TFlxOneBorder oborder = new TFlxOneBorder();
oborder.Style = TFlxBorderStyle.Thin;
tfBorderF.Left = oborder;
tf3.Borders = tfBorderF;
return xls.AddFormat(tf3);
}
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 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);
}
