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); }