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];
}
}
}
}
}