Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
etienne nicolas
225
Format Range of data
posted

Hi, 

simple question:

How to a create a border around a range of cells ? 

For instance, if I want to have a border around a range from A1 to C10, how to achieve this ? 

Thanks

Parents
No Data
Reply
  • 225
    Offline posted

    I've tried this :

    WorksheetMergedCellsRegion merge = sheet.MergedCellsRegions.Add(4, 4, 15, 15);
    merge.CellFormat.BottomBorderStyle = CellBorderLineStyle.Double;
    merge.CellFormat.TopBorderStyle = CellBorderLineStyle.Double;
    merge.CellFormat.LeftBorderStyle = CellBorderLineStyle.Double;
    merge.CellFormat.RightBorderStyle = CellBorderLineStyle.Double;

    sheet.MergedCellsRegions.Remove(merge);

    Seems to provide the correct result..

    Is there another way to do this ? 

Children