public void AddTable(GOST table)
{
if (Tables.Count == 0)
{
Tables.Add(table);
Format = table.Format;
Orientation = table.Orientation;
Columns = new List <int[]>(table.Columns);
Rows = new List <int[]>(table.Rows);
SetPageDimensions();
}
else
{
if (table.Position > 1)
{
XMLTools.CompleteFields(table, Height, Width);
XMLTools.CreateNormalTable(table, Height, Width);
}
Tables.Add(table);
if (table.Columns != null && table.Rows != null)
{
(Columns, Rows) = XMLTools.MergeTables(Columns, Rows, table.Columns, table.Rows);
}
}
}
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 DrawFrame()
{
if (Tables == null || Tables.First() == null || Tables.First().Frame == null)
{
return;
}
(int y1, int x1) = (Tables.First().Frame[0], Tables.First().Frame[1]);
(int y2, int x2) = (Tables.First().Frame[2], Tables.First().Frame[3]);
(y1, x1) = XMLTools.GetCellIndexesBySize(Rows, Columns, y1, x1);
(y2, x2) = XMLTools.GetCellIndexesBySize(Rows, Columns, y2, x2);
WS.Range(y1, x1, y2, x2).Style.Border.OutsideBorder = XLBorderStyleValues.Thin;
}
private void MergeCells()
{
foreach (GOST table in Tables)
{
if (table.Fields == null)
{
continue;
}
foreach (List <int[]> line in table.Fields)
{
foreach (int[] field in line)
{
(int y1, int x1) = XMLTools.GetCellIndexesBySize(Rows, Columns, field[0], field[1]);
(int y2, int x2) = XMLTools.GetCellIndexesBySize(Rows, Columns, field[2], field[3]);
WS.Range(y1, x1, y2, x2).Merge();
}
}
}
}
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 ReshapeWorkSheet()
{
SortedSet <int> cols = XMLTools.GetSortedSet(Columns);
SortedSet <int> rows = XMLTools.GetSortedSet(Rows);
// Set widths
for (int i = 0, size = cols.ElementAt(0); i < cols.Count; i++)
{
if (i > 0)
{
size = cols.ElementAt(i) - cols.ElementAt(i - 1);
}
WS.Column(i + 1).Width = XMLTools.mmToWidth(size);
}
// Set heights
for (int i = 0, size = rows.ElementAt(0); i < rows.Count; i++)
{
if (i > 0)
{
size = rows.ElementAt(i) - rows.ElementAt(i - 1);
}
WS.Row(i + 1).Height = XMLTools.mmToHeight(size);
}
}
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];
}
}
}
}
}
