public void SetBorderRangeCells(int startRow, int startCol, int stopRow, int stopCol,
Color borderColor, TFlxBorderStyle linestyle)
{
for (var i = startCol; i <= stopCol; i++)
{
for (var j = startRow; j <= stopRow; j++)
{
SetBorderCell(j, i, borderColor, linestyle);
}
}
}
public void SetCellRangeBorderBySide(int startRow, int startCol, int stopRow, int stopCol,
Color borderColor, TFlxBorderStyle linestyle, SideToBorder side)
{
switch (side)
{
case (SideToBorder.Top):
//обходим все колонки и рисуем границу в верхней части первой строки
for (var i = startCol; i <= stopCol; i++)
{
SetBorderCellsTop(startRow, i, borderColor, linestyle);
}
break;
case (SideToBorder.Right):
//обходим все строки и рисуем границу в правой части последней колонки
for (var i = startRow; i <= stopRow; i++)
{
SetBorderCellsRight(i, stopCol, borderColor, linestyle);
}
break;
case (SideToBorder.Bottom):
for (var i = startCol; i <= stopCol; i++)
{
SetBorderCellsBottom(stopRow, i, borderColor, linestyle);
}
break;
case (SideToBorder.Left):
for (var i = startRow; i <= stopRow; i++)
{
SetBorderCellsLeft(i, startCol, borderColor, linestyle);
}
break;
case (SideToBorder.All):
for (var i = startCol; i <= stopCol; i++)
{
SetBorderCellsTop(startRow, i, borderColor, linestyle);
SetBorderCellsBottom(stopRow, i, borderColor, linestyle);
}
for (var i = startRow; i <= stopRow; i++)
{
SetBorderCellsRight(i, stopCol, borderColor, linestyle);
SetBorderCellsLeft(i, startCol, borderColor, linestyle);
}
break;
default:
break;
}
}
public void SetBorderCellsLeft(int row, int col, Color borderColor,
TFlxBorderStyle linestyle)
{
if (col > 255)
{
col = 255;
}
var cellFormat = GetCellFormat(row, col);
var format = GetFormat(cellFormat);
format.Borders.Left.Color = borderColor;
format.Borders.Left.Style = linestyle;
cellFormat = AddFormat(format);
SetCellFormat(row, col, cellFormat);
}
public void SetBlockBorderBySide(ExtendedXlsFile xls, Color borderColor, TFlxBorderStyle linestyle, SideToBorder side)
{
xls.SetCellRangeBorderBySide(StartRow, StartCol, UsedRows, UsedCols, borderColor, linestyle, side);
}
public void SetBorderAllCellsInBlock(ExtendedXlsFile xls, Color borderColor, TFlxBorderStyle linestyle)
{
xls.SetBorderRangeCells(StartRow, StartCol, UsedRows, UsedCols, borderColor, linestyle);
}
