)
We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to apply borders for the merge cells programmatically at runtime in WinForms Spreadsheet (SfSpreadsheet)?

Platform: WinForms |
Control: Spreadsheet |
Published Date: July 28, 2016 |
Last Revised Date: January 27, 2020

Set the cell borders for merged cell

SfSpreadsheet provides support to set the cell borders for merged cells programmatically at runtime.

Cell Merging

For merging the cells, you need to add the CoveredCellInfo into CoveredCells collection of SpreadsheetGrid in WorkbookLoaded event and merge the range using Merge method in XlsIO.

C#

spreadsheet.WorkbookLoaded += Spreadsheet_WorkbookLoaded;
private void Spreadsheet_WorkbookLoaded(object sender, WorkbookLoadedEventArgs args)
{
    var worksheet = spreadsheet.Workbook.Worksheets[0];
    var coveredcell = new CoveredCellInfo(8, 8, 11, 11);
    spreadsheet.ActiveGrid.CoveredCells.Add(coveredcell);
    var range = worksheet.Range[8, 8, 11, 11];
    range.Merge();
    spreadsheet.ActiveGrid.InvalidateCell(GridRangeInfo.Cells(8,8,11,11),false);
}

Border settings

Border can be applied by setting LineStyle and Color property of IBorders to the merged range.

C#

var worksheet = spreadsheet.Workbook.Worksheets[0];
var cell = worksheet.Range[8, 8, 11, 11];
//Apply border for the cell
cell.Borders.LineStyle = ExcelLineStyle.Thick;
cell.Borders.Color = ExcelKnownColors.Red;
spreadsheet.ActiveGrid.InvalidateCell(cell.Row, cell.Column);

Samples:

WPF

WinForms

UWP

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon