private void FillTable()
        {
            foreach (GOST table in Tables)
            {
                for (int dataLine = 0;
                     dataLine < table.LinesCount && dataLine < table.Data.Count;
                     table.Line++, dataLine++)
                {
                    for (int field = 0;
                         field < table.Fields[table.Line].Count && field < table.Data[dataLine].Count;
                         field++)
                    {
                        (int y1, int x1)      = (table.Fields[table.Line][field][0], table.Fields[table.Line][field][1]);
                        (y1, x1)              = XMLTools.GetCellIndexesBySize(Rows, Columns, y1, x1);
                        WS.Cell(y1, x1).Value = table.Data[dataLine][field];

                        // Underline category name
                        if (table.Type == GOST.Types.Table &&
                            table.ElemCol[dataLine].LineType == ElementContainer.ContType.Category &&
                            table.Data[dataLine][field].Length > 0)
                        {
                            WS.Cell(y1, x1).Style.Font.SetUnderline();
                        }

                        if (table.Type == GOST.Types.Table)
                        {
                            (int y2, int x2) = (table.Fields[table.Line][field][2], table.Fields[table.Line][field][3]);
                            (y2, x2)         = XMLTools.GetCellIndexesBySize(Rows, Columns, y2, x2);
                            WS.Range(y1, x1, y2, x2).Style.Border.OutsideBorder = XLBorderStyleValues.Thin;
                        }
                    }
                }
            }
        }
 private void FillHeader()
 {
     foreach (GOST table in Tables)
     {
         if (table.Map == null || table.Fields == null)
         {
             continue;
         }
         foreach (KeyValuePair <string, int[]> entry in table.Map)
         {
             if (entry.Key.First() != '_' && entry.Value.Length == 2)
             {
                 (int y1, int x1)      = (table.Fields[entry.Value[0]][entry.Value[1]][0], table.Fields[entry.Value[0]][entry.Value[1]][1]);
                 (int y2, int x2)      = (table.Fields[entry.Value[0]][entry.Value[1]][2], table.Fields[entry.Value[0]][entry.Value[1]][3]);
                 (y1, x1)              = XMLTools.GetCellIndexesBySize(Rows, Columns, y1, x1);
                 WS.Cell(y1, x1).Value = entry.Key.Replace("_", string.Empty);
             }
         }
     }
 }
        private void Kostyl()
        {
            // Set horizontal alignment for columns enumeration row
            if (Work.Book.Table == GOST.Standarts.GOST_21_110_2013_Table_1 &&
                Tables[0].Standart == Work.Book.Table &&
                Rvt.Control.EnumerateColumnsCheckBox == true)
            {
                (int y, int x) = (Tables[0].Fields[1][1][0], Tables[0].Fields[1][1][1]);
                (y, x)         = XMLTools.GetCellIndexesBySize(Rows, Columns, y, x);
                WS.Cell(y, x).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
            }
            else if ((Work.Book.Table == GOST.Standarts.GOST_P_21_101_2020_Table_7 ||
                      Work.Book.Table == GOST.Standarts.GOST_P_21_101_2020_Table_8) &&
                     Tables[0].Standart == Work.Book.Table &&
                     Rvt.Control.EnumerateColumnsCheckBox == true)
            {
                (int y, int x) = (Tables[0].Fields[1][1][0], Tables[0].Fields[1][1][1]);
                (y, x)         = XMLTools.GetCellIndexesBySize(Rows, Columns, y, x);
                WS.Cell(y, x).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;

                (y, x) = (Tables[0].Fields[1][2][0], Tables[0].Fields[1][2][1]);
                (y, x) = XMLTools.GetCellIndexesBySize(Rows, Columns, y, x);
                WS.Cell(y, x).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
            }
            else if (Work.Book.Table == GOST.Standarts.GOST_P_2_106_2019_Table_1 &&
                     Tables[0].Standart == Work.Book.Table &&
                     Rvt.Control.EnumerateColumnsCheckBox == true)
            {
                (int y, int x) = (Tables[0].Fields[1][3][0], Tables[0].Fields[1][3][1]);
                (y, x)         = XMLTools.GetCellIndexesBySize(Rows, Columns, y, x);
                WS.Cell(y, x).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;

                (y, x) = (Tables[0].Fields[1][4][0], Tables[0].Fields[1][4][1]);
                (y, x) = XMLTools.GetCellIndexesBySize(Rows, Columns, y, x);
                WS.Cell(y, x).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
            }
            else if (Work.Book.Table == GOST.Standarts.GOST_P_2_106_2019_Table_5 &&
                     Tables[0].Standart == Work.Book.Table &&
                     Rvt.Control.EnumerateColumnsCheckBox == true)
            {
                (int y, int x) = (Tables[0].Fields[1][1][0], Tables[0].Fields[1][1][1]);
                (y, x)         = XMLTools.GetCellIndexesBySize(Rows, Columns, y, x);
                WS.Cell(y, x).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
            }

            // Change text direction
            if (Work.Book.Table == GOST.Standarts.GOST_P_2_106_2019_Table_1 &&
                Tables[0].Standart == Work.Book.Table)
            {
                int x, y;
                for (int i = 0; i < 3; ++i)
                {
                    (y, x) = (Tables[0].Fields[0][i][0], Tables[0].Fields[0][i][1]);
                    (y, x) = XMLTools.GetCellIndexesBySize(Rows, Columns, y, x);
                    WS.Cell(y, x).Style.Alignment.SetTextRotation(90);
                }
                (y, x) = (Tables[0].Fields[0][5][0], Tables[0].Fields[0][5][1]);
                (y, x) = XMLTools.GetCellIndexesBySize(Rows, Columns, y, x);
                WS.Cell(y, x).Style.Alignment.SetTextRotation(90);
            }
            else if (Work.Book.Table == GOST.Standarts.GOST_P_2_106_2019_Table_5 &&
                     Tables[0].Standart == Work.Book.Table)
            {
                (int y, int x) = (Tables[0].Fields[0][0][0], Tables[0].Fields[0][0][1]);
                (y, x)         = XMLTools.GetCellIndexesBySize(Rows, Columns, y, x);
                WS.Cell(y, x).Style.Alignment.SetTextRotation(90);
            }
        }
        private void ApplyStyles()
        {
            foreach (GOST table in Tables)
            {
                if (table.Fields == null)
                {
                    continue;
                }
                for (int i = 0; i < table.Fields.Count; ++i)
                {
                    for (int j = 0; j < table.Fields[i].Count; ++j)
                    {
                        // Get cell coordinates
                        (int y1, int x1) = (table.Fields[i][j][0], table.Fields[i][j][1]);
                        (int y2, int x2) = (table.Fields[i][j][2], table.Fields[i][j][3]);
                        (y1, x1)         = XMLTools.GetCellIndexesBySize(Rows, Columns, y1, x1);
                        (y2, x2)         = XMLTools.GetCellIndexesBySize(Rows, Columns, y2, x2);

                        // Set font
                        if (table.Font != null)
                        {
                            WS.Cell(y1, x1).Style.Font.FontName = table.Font;
                        }

                        // Set font size
                        if (table.FontSizes != null && table.FontSizes[i][j] != 0)
                        {
                            WS.Cell(y1, x1).Style.Font.FontSize = table.FontSizes[i][j];
                        }
                        else if (table.FontSize != 0)
                        {
                            WS.Cell(y1, x1).Style.Font.FontSize = table.FontSize;
                        }

                        // Set vertical alignments
                        if (table.VerticalAlignments != null && 0 <= table.VerticalAlignments[i][j] && table.VerticalAlignments[i][j] <= 4)
                        {
                            WS.Cell(y1, x1).Style.Alignment.Vertical = (XLAlignmentVerticalValues)table.VerticalAlignments[i][j];
                        }
                        else
                        {
                            WS.Cell(y1, x1).Style.Alignment.Vertical = (XLAlignmentVerticalValues)table.VerticalAlignment;
                        }

                        // Set horizontal alignments
                        if (table.HorizontalAlignments != null && 0 <= table.HorizontalAlignments[i][j] && table.HorizontalAlignments[i][j] <= 7)
                        {
                            WS.Cell(y1, x1).Style.Alignment.Horizontal = (XLAlignmentHorizontalValues)table.HorizontalAlignments[i][j];
                        }
                        else
                        {
                            WS.Cell(y1, x1).Style.Alignment.Horizontal = (XLAlignmentHorizontalValues)table.HorizontalAlignment;
                        }

                        // Apply word wrap
                        WS.Cell(y1, x1).Style.Alignment.WrapText = true;

                        // Set vertical text direction
                        if (table.VerticalText == true)
                        {
                            WS.Cell(y1, x1).Style.Alignment.SetTextRotation(90);
                        }

                        // Draw borders
                        if (table.Borders != null)
                        {
                            WS.Range(y1, x1, y2, x2).Style.Border.OutsideBorder = (XLBorderStyleValues)table.Borders[i][j];
                        }
                    }
                }
            }
        }