How can I use 2 MultipleBorders option in GemBox

Question

I can use an inside border line style and an outside line style, but I don't know how I can use both.

As in this picture:

I am using C# and GemBox.Spreadsheet

//inside border
for (int line = 0; line < Projectsource.Count(); line++) //바깥border과 안쪽 얇은 border 같이 쓰면 안됨
{
    for (int j = 0; j < 14; j++)//안쪽 cell border 얇게
    {
        worksheet.Cells[line, j].Style.Borders.SetBorders(
            MultipleBorders.Outside, SpreadsheetColor.FromArgb(255, 0, 0), LineStyle.Thin);
    }
}

//outside border
//style.Borders.SetBorders(
//    MultipleBorders.Outside, SpreadsheetColor.FromArgb(140, 120, 50), LineStyle.Thick);//바깥쪽 border 두껍게 성공

worksheet.Cells.GetSubrange("A2:N762").Style = style;

Could you please add more details to your questions. Its not obvious on what exactly you are trying to solve. TY. — realPK, Feb 27 '20 at 01:40
This might be helpful https://stackoverflow.com/help/how-to-ask — Chathuranga Ranasinghe, Feb 27 '20 at 03:20

score 1 · Accepted Answer · answered Mar 27 '20 at 17:08

Note that MultipleBorders is a flag enum which means that you can use bitwise operators with it.

So, here is how you can set both inside and outside borders with the newer versions of GemBox.Spreadsheet:

worksheet.Cells.GetSubrange("A2:N762").Style.Borders.SetBorders(
    MultipleBorders.Inside | MultipleBorders.Outside,
    SpreadsheetColor.FromArgb(255, 0, 0),
    LineStyle.Thin);

Or you could use this instead:

worksheet.Cells.GetSubrange("A2:N762").Style.Borders.SetBorders(
    MultipleBorders.All,
    SpreadsheetColor.FromArgb(255, 0, 0),
    LineStyle.Thin);

However, as you already noticed that older version (GemBox.Spreadsheet 3.9) doesn't have MultipleBorders.Inside. Also, even though it does have MultipleBorders.All, the behavior is different.

Nevertheless, here is how to set the desired borders with those older versions of GemBox.Spreadsheet:

foreach (var cell in worksheet.Cells.GetSubrange("A2:N762"))
    cell.Style.Borders.SetBorders(
        MultipleBorders.Outside,
        SpreadsheetColor.FromArgb(255, 0, 0),
        LineStyle.Thin);

score 0 · Answer 2 · answered Feb 27 '20 at 00:07

0

my gembox version: enter image description here

so nothing MultipleBorders.inside method in my gembox version only have MultipleBorders.outside method

answered Feb 27 '20 at 00:07

허니브레드

17
7

How can I use 2 MultipleBorders option in GemBox

2 Answers2