Esempio n. 1
0
 public static void SetRowsBorder(CellRange cellRange, SheetArea sheetArea, Worksheet workSheet, SetBorderOptions option, BorderLine borderLine)
 {
     if (option.HasFlag(SetBorderOptions.All))
     {
         if (cellRange.Row > 0)
         {
             bool[] flags = new bool[4];
             flags[3] = true;
             BorderLine[] lines = new BorderLine[4];
             SetAxisBorder(workSheet, sheetArea, cellRange.Row - 1, 1, flags, lines, true);
         }
         if ((cellRange.Row + cellRange.RowCount) < GetRowCount(workSheet, sheetArea))
         {
             bool[] flagArray2 = new bool[4];
             flagArray2[1] = true;
             BorderLine[] lineArray2 = new BorderLine[4];
             SetAxisBorder(workSheet, sheetArea, cellRange.Row + cellRange.RowCount, 1, flagArray2, lineArray2, true);
         }
         SetAxisBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount, new bool[] { true, true, true, true }, new BorderLine[] { borderLine, borderLine, borderLine, borderLine }, true);
     }
     else
     {
         if (option.HasFlag(SetBorderOptions.Left))
         {
             bool[] flagArray3 = new bool[4];
             flagArray3[0] = true;
             BorderLine[] lineArray4 = new BorderLine[4];
             lineArray4[0] = borderLine;
             SetCellBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount, 0, 1, flagArray3, lineArray4, false, false);
         }
         if (option.HasFlag(SetBorderOptions.Right))
         {
             bool[] flagArray4 = new bool[4];
             flagArray4[2] = true;
             BorderLine[] lineArray5 = new BorderLine[4];
             lineArray5[2] = borderLine;
             SetCellBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount, workSheet.ColumnCount - 1, 1, flagArray4, lineArray5, false, false);
         }
         if (option.HasFlag(SetBorderOptions.Top))
         {
             if (cellRange.Row > 0)
             {
                 bool[] flagArray5 = new bool[4];
                 flagArray5[3] = true;
                 BorderLine[] lineArray6 = new BorderLine[4];
                 SetAxisBorder(workSheet, sheetArea, cellRange.Row - 1, 1, flagArray5, lineArray6, true);
             }
             bool[] flagArray6 = new bool[4];
             flagArray6[1] = true;
             BorderLine[] lineArray7 = new BorderLine[4];
             lineArray7[1] = borderLine;
             SetAxisBorder(workSheet, sheetArea, cellRange.Row, 1, flagArray6, lineArray7, true);
         }
         if (option.HasFlag(SetBorderOptions.Bottom))
         {
             if ((cellRange.Row + cellRange.RowCount) < GetRowCount(workSheet, sheetArea))
             {
                 bool[] flagArray7 = new bool[4];
                 flagArray7[1] = true;
                 BorderLine[] lineArray8 = new BorderLine[4];
                 SetAxisBorder(workSheet, sheetArea, cellRange.Row + cellRange.RowCount, 1, flagArray7, lineArray8, true);
             }
             bool[] flagArray8 = new bool[4];
             flagArray8[3] = true;
             BorderLine[] lineArray9 = new BorderLine[4];
             lineArray9[3] = borderLine;
             SetAxisBorder(workSheet, sheetArea, (cellRange.Row + cellRange.RowCount) - 1, 1, flagArray8, lineArray9, true);
         }
         if (option.HasFlag(SetBorderOptions.InnerHorizontal))
         {
             if (cellRange.RowCount > 1)
             {
                 bool[] flagArray9 = new bool[4];
                 flagArray9[1] = true;
                 BorderLine[] lineArray10 = new BorderLine[4];
                 SetAxisBorder(workSheet, sheetArea, cellRange.Row + 1, cellRange.RowCount - 1, flagArray9, lineArray10, true);
             }
             bool[] flagArray10 = new bool[4];
             flagArray10[3] = true;
             BorderLine[] lineArray11 = new BorderLine[4];
             lineArray11[3] = borderLine;
             SetAxisBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount - 1, flagArray10, lineArray11, true);
         }
         if (option.HasFlag(SetBorderOptions.InnerVertical))
         {
             if (workSheet.ColumnCount > 1)
             {
                 bool[] flagArray11 = new bool[4];
                 flagArray11[0] = true;
                 BorderLine[] lineArray12 = new BorderLine[4];
                 SetCellBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount, 1, workSheet.ColumnCount - 1, flagArray11, lineArray12, false, false);
             }
             bool[] flagArray12 = new bool[4];
             flagArray12[2] = true;
             BorderLine[] lineArray13 = new BorderLine[4];
             lineArray13[2] = borderLine;
             SetCellBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount, 0, workSheet.ColumnCount - 1, flagArray12, lineArray13, false, false);
         }
     }
 }
Esempio n. 2
0
 public static void SetSheetBorder(SheetArea sheetArea, Worksheet workSheet, SetBorderOptions option, BorderLine borderLine, SheetArea sheatarea, StyleInfo borderstyle)
 {
     if (option.HasFlag(SetBorderOptions.All))
     {
         borderstyle.BorderLeft   = borderLine.Clone() as BorderLine;
         borderstyle.BorderTop    = borderLine.Clone() as BorderLine;
         borderstyle.BorderRight  = borderLine.Clone() as BorderLine;
         borderstyle.BorderBottom = borderLine.Clone() as BorderLine;
     }
     else
     {
         if (option.HasFlag(SetBorderOptions.Left))
         {
             bool[] flags = new bool[4];
             flags[0] = true;
             BorderLine[] lines = new BorderLine[4];
             lines[0] = borderLine;
             SetAxisBorder(workSheet, sheetArea, 0, 1, flags, lines, false);
         }
         if (option.HasFlag(SetBorderOptions.Top))
         {
             bool[] flagArray2 = new bool[4];
             flagArray2[1] = true;
             BorderLine[] lineArray2 = new BorderLine[4];
             lineArray2[1] = borderLine;
             SetAxisBorder(workSheet, sheetArea, 0, 1, flagArray2, lineArray2, true);
         }
         if (option.HasFlag(SetBorderOptions.Right))
         {
             bool[] flagArray3 = new bool[4];
             flagArray3[2] = true;
             BorderLine[] lineArray3 = new BorderLine[4];
             lineArray3[2] = borderLine;
             SetAxisBorder(workSheet, sheetArea, workSheet.ColumnCount - 1, 1, flagArray3, lineArray3, false);
         }
         if (option.HasFlag(SetBorderOptions.Bottom))
         {
             bool[] flagArray4 = new bool[4];
             flagArray4[3] = true;
             BorderLine[] lineArray4 = new BorderLine[4];
             lineArray4[3] = borderLine;
             SetAxisBorder(workSheet, sheetArea, workSheet.RowCount - 1, 1, flagArray4, lineArray4, true);
         }
         if (option.HasFlag(SetBorderOptions.InnerHorizontal))
         {
             if (workSheet.RowCount > 1)
             {
                 bool[] flagArray5 = new bool[4];
                 flagArray5[1] = true;
                 BorderLine[] lineArray5 = new BorderLine[4];
                 SetAxisBorder(workSheet, sheetArea, 1, workSheet.RowCount - 1, flagArray5, lineArray5, true);
             }
             bool[] flagArray6 = new bool[4];
             flagArray6[3] = true;
             BorderLine[] lineArray6 = new BorderLine[4];
             lineArray6[3] = borderLine;
             SetAxisBorder(workSheet, sheetArea, 0, workSheet.RowCount - 1, flagArray6, lineArray6, true);
         }
         if (option.HasFlag(SetBorderOptions.InnerVertical))
         {
             if (workSheet.ColumnCount > 1)
             {
                 bool[] flagArray7 = new bool[4];
                 flagArray7[0] = true;
                 BorderLine[] lineArray7 = new BorderLine[4];
                 SetAxisBorder(workSheet, sheetArea, 1, workSheet.ColumnCount - 1, flagArray7, lineArray7, false);
             }
             bool[] flagArray8 = new bool[4];
             flagArray8[2] = true;
             BorderLine[] lineArray8 = new BorderLine[4];
             lineArray8[2] = borderLine;
             SetAxisBorder(workSheet, sheetArea, 0, workSheet.ColumnCount - 1, flagArray8, lineArray8, false);
         }
     }
 }
Esempio n. 3
0
 public static void SetCellsBorder(CellRange cellRange, SheetArea sheetArea, Worksheet workSheet, SetBorderOptions option, BorderLine borderLine)
 {
     if (option.HasFlag(SetBorderOptions.All))
     {
         if (cellRange.Column > 0)
         {
             bool[] flags = new bool[4];
             flags[2] = true;
             BorderLine[] lines = new BorderLine[4];
             SetCellBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount, cellRange.Column - 1, 1, flags, lines, false, false);
         }
         if (cellRange.Row > 0)
         {
             bool[] flagArray2 = new bool[4];
             flagArray2[3] = true;
             BorderLine[] lineArray2 = new BorderLine[4];
             SetCellBorder(workSheet, sheetArea, cellRange.Row - 1, 1, cellRange.Column, cellRange.ColumnCount, flagArray2, lineArray2, false, false);
         }
         if ((cellRange.Column + cellRange.ColumnCount) < GetColumnCount(workSheet, sheetArea))
         {
             bool[] flagArray3 = new bool[4];
             flagArray3[0] = true;
             BorderLine[] lineArray3 = new BorderLine[4];
             SetCellBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount, cellRange.Column + cellRange.ColumnCount, 1, flagArray3, lineArray3, false, false);
         }
         if ((cellRange.Row + cellRange.RowCount) < GetRowCount(workSheet, sheetArea))
         {
             bool[] flagArray4 = new bool[4];
             flagArray4[1] = true;
             BorderLine[] lineArray4 = new BorderLine[4];
             SetCellBorder(workSheet, sheetArea, cellRange.Row + cellRange.RowCount, 1, cellRange.Column, cellRange.ColumnCount, flagArray4, lineArray4, false, false);
         }
         SetCellBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount, cellRange.Column, cellRange.ColumnCount, new bool[] { true, true, true, true }, new BorderLine[] { borderLine, borderLine, borderLine, borderLine }, false, false);
     }
     else
     {
         if (option.HasFlag(SetBorderOptions.Left))
         {
             if (cellRange.Column > 0)
             {
                 bool[] flagArray5 = new bool[4];
                 flagArray5[2] = true;
                 BorderLine[] lineArray6 = new BorderLine[4];
                 SetCellBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount, cellRange.Column - 1, 1, flagArray5, lineArray6, false, false);
             }
             bool[] flagArray6 = new bool[4];
             flagArray6[0] = true;
             BorderLine[] lineArray7 = new BorderLine[4];
             lineArray7[0] = borderLine;
             SetCellBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount, cellRange.Column, 1, flagArray6, lineArray7, false, false);
         }
         if (option.HasFlag(SetBorderOptions.Top))
         {
             if (cellRange.Row > 0)
             {
                 bool[] flagArray7 = new bool[4];
                 flagArray7[3] = true;
                 BorderLine[] lineArray8 = new BorderLine[4];
                 SetCellBorder(workSheet, sheetArea, cellRange.Row - 1, 1, cellRange.Column, cellRange.ColumnCount, flagArray7, lineArray8, false, false);
             }
             bool[] flagArray8 = new bool[4];
             flagArray8[1] = true;
             BorderLine[] lineArray9 = new BorderLine[4];
             lineArray9[1] = borderLine;
             SetCellBorder(workSheet, sheetArea, cellRange.Row, 1, cellRange.Column, cellRange.ColumnCount, flagArray8, lineArray9, false, false);
         }
         if (option.HasFlag(SetBorderOptions.Right))
         {
             if ((cellRange.Column + cellRange.ColumnCount) < GetColumnCount(workSheet, sheetArea))
             {
                 bool[] flagArray9 = new bool[4];
                 flagArray9[0] = true;
                 BorderLine[] lineArray10 = new BorderLine[4];
                 SetCellBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount, cellRange.Column + cellRange.ColumnCount, 1, flagArray9, lineArray10, false, false);
             }
             bool[] flagArray10 = new bool[4];
             flagArray10[2] = true;
             BorderLine[] lineArray11 = new BorderLine[4];
             lineArray11[2] = borderLine;
             SetCellBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount, (cellRange.Column + cellRange.ColumnCount) - 1, 1, flagArray10, lineArray11, false, false);
         }
         if (option.HasFlag(SetBorderOptions.Bottom))
         {
             if ((cellRange.Row + cellRange.RowCount) < GetRowCount(workSheet, sheetArea))
             {
                 bool[] flagArray11 = new bool[4];
                 flagArray11[1] = true;
                 BorderLine[] lineArray12 = new BorderLine[4];
                 SetCellBorder(workSheet, sheetArea, cellRange.Row + cellRange.RowCount, 1, cellRange.Column, cellRange.ColumnCount, flagArray11, lineArray12, false, false);
             }
             bool[] flagArray12 = new bool[4];
             flagArray12[3] = true;
             BorderLine[] lineArray13 = new BorderLine[4];
             lineArray13[3] = borderLine;
             SetCellBorder(workSheet, sheetArea, (cellRange.Row + cellRange.RowCount) - 1, 1, cellRange.Column, cellRange.ColumnCount, flagArray12, lineArray13, false, false);
         }
         if (option.HasFlag(SetBorderOptions.Inside))
         {
             bool[] flagArray13 = new bool[4];
             flagArray13[0] = true;
             flagArray13[1] = true;
             BorderLine[] lineArray14 = new BorderLine[4];
             SetCellBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount, cellRange.Column, cellRange.ColumnCount, flagArray13, lineArray14, true, true);
             bool[] flagArray14 = new bool[4];
             flagArray14[2] = true;
             flagArray14[3] = true;
             BorderLine[] lineArray15 = new BorderLine[4];
             lineArray15[2] = borderLine;
             lineArray15[3] = borderLine;
             SetCellBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount, cellRange.Column, cellRange.ColumnCount, flagArray14, lineArray15, true, false);
         }
         else
         {
             if (option.HasFlag(SetBorderOptions.InnerHorizontal))
             {
                 if (cellRange.RowCount > 1)
                 {
                     bool[] flagArray15 = new bool[4];
                     flagArray15[1] = true;
                     BorderLine[] lineArray16 = new BorderLine[4];
                     SetCellBorder(workSheet, sheetArea, cellRange.Row + 1, cellRange.RowCount - 1, cellRange.Column, cellRange.ColumnCount, flagArray15, lineArray16, false, false);
                 }
                 bool[] flagArray16 = new bool[4];
                 flagArray16[3] = true;
                 BorderLine[] lineArray17 = new BorderLine[4];
                 lineArray17[3] = borderLine;
                 SetCellBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount - 1, cellRange.Column, cellRange.ColumnCount, flagArray16, lineArray17, false, false);
             }
             if (option.HasFlag(SetBorderOptions.InnerVertical))
             {
                 if (cellRange.ColumnCount > 1)
                 {
                     bool[] flagArray17 = new bool[4];
                     flagArray17[0] = true;
                     BorderLine[] lineArray18 = new BorderLine[4];
                     SetCellBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount, cellRange.Column + 1, cellRange.ColumnCount - 1, flagArray17, lineArray18, false, false);
                 }
                 bool[] flagArray18 = new bool[4];
                 flagArray18[2] = true;
                 BorderLine[] lineArray19 = new BorderLine[4];
                 lineArray19[2] = borderLine;
                 SetCellBorder(workSheet, sheetArea, cellRange.Row, cellRange.RowCount, cellRange.Column, cellRange.ColumnCount - 1, flagArray18, lineArray19, false, false);
             }
         }
     }
 }