public static void StandartInlineCell(GemboxTableHandler.Table.Range x, object[] dataRow = null, object GlobalConditionsObject = null)
{
x.Style.Borders.SetBorders(MultipleBorders.Outside, SpreadsheetColor.FromName(ColorName.Black), LineStyle.Thin);
x.Style.Font.Weight = ExcelFont.NormalWeight;
x.Style.VerticalAlignment = VerticalAlignmentStyle.Top;
x.Style.Font.Name = "Calibri";
x.Style.Font.Size = 212;
x.Style.Font.Color = SpreadsheetColor.FromName(ColorName.Black);
}
public static void SCHeaderCell(GemboxTableHandler.Table.Range x, object[] dataRow = null, object GlobalConditionsObject = null)
{
x.Style.Borders.SetBorders(MultipleBorders.Outside, SpreadsheetColor.FromName(ColorName.Black), LineStyle.Thin);
x.Style.FillPattern.SetPattern(FillPatternStyle.Solid, SpreadsheetColor.FromArgb(81, 118, 232), SpreadsheetColor.FromArgb(81, 118, 232));
x.Style.VerticalAlignment = VerticalAlignmentStyle.Top;
x.Style.Font.Weight = ExcelFont.MaxWeight;
x.Style.Font.Name = "Arial";
x.Style.Font.Size = 201;
x.Style.Font.Color = SpreadsheetColor.FromName(ColorName.Black);
}
public static void StandartHeaderGroupCell(GemboxTableHandler.Table.Range x, object[] dataRow = null, object GlobalConditionsObject = null)
{
x.Style.Borders.SetBorders(MultipleBorders.All, SpreadsheetColor.FromName(ColorName.Black), LineStyle.Thin);
x.Style.FillPattern.SetPattern(FillPatternStyle.Solid, SpreadsheetColor.FromArgb(218, 227, 250), SpreadsheetColor.FromName(ColorName.LightBlue));
x.Style.VerticalAlignment = VerticalAlignmentStyle.Top;
x.Style.Font.Weight = ExcelFont.MaxWeight;
x.Style.Font.Name = "Calibri";
x.Style.Font.Size = 220;
x.Style.Font.Color = SpreadsheetColor.FromName(ColorName.Black);
}
public static void ReportDataOfElectricityMeterConsumption_tariffz(GemboxTableHandler.Table.Range x, object[] dataRow = null, object GlobalConditionsObject = null)
{
if (dataRow != null)
{
int mean_index = 10;
if (dataRow.Length > mean_index && (string)dataRow[mean_index] == "Сумма")
{
x.Offset(mean_index).Style.FillPattern.SetPattern(FillPatternStyle.Solid, SpreadsheetColor.FromName(ColorName.Orange), SpreadsheetColor.FromName(ColorName.Orange));
}
}
}
public static void EmptyWeaponStyle(GemboxTableHandler.Table.Range x, object[] dataRow = null, object GlobalConditionsObject = null)
{
if (dataRow != null)
{
//Link to description COLUMN INDEX ["Description" is 8th]; TODO: fast way to link by column name
int mean_index = 8;
if (dataRow.Length > mean_index && dataRow[mean_index] == null)
{
x.Offset(mean_index).Resize(4).Style.FillPattern.SetPattern(FillPatternStyle.Solid, SpreadsheetColor.FromArgb(255, 188, 192), SpreadsheetColor.FromArgb(255, 188, 192));
}
//paint next 4 columns
}
}
public static void StandartInlineCell(GemboxTableHandler.Table.Range x, object[] dataRow = null, object GlobalConditionsObject = null)
{
var borders = x.Style.Borders;
x.Style.Borders.SetBorders(MultipleBorders.All, SpreadsheetColor.FromArgb(105, 105, 105), LineStyle.Thin);
//borders[XlBordersIndex.xlInsideHorizontal].Color = XlRgbColor.rgbDarkSlateGrey;
//borders[XlBordersIndex.xlInsideHorizontal].Weight = XlBorderWeight.xlThin;
//borders[XlBordersIndex.xlInsideHorizontal].LineStyle = XlLineStyle.xlContinuous;
x.Style.VerticalAlignment = VerticalAlignmentStyle.Top;
x.Style.Font.Weight = ExcelFont.NormalWeight;
x.Style.Font.Name = "Calibri";
x.Style.Font.Size = 201;
x.Style.Font.Color = SpreadsheetColor.FromName(ColorName.Black);
//x.Style.Borders.SetBorders(MultipleBorders.Outside, SpreadsheetColor.FromName(ColorName.Black), LineStyle.Thin);
//IF 1 then Value must be between ExcelFont.MinWeight and ExcelFont.MaxWeight.
}
public static void HeaderGroup3Cell(GemboxTableHandler.Table.Range x, object[] dataRow = null, object GlobalConditionsObject = null)
{
x.Style.FillPattern.SetPattern(FillPatternStyle.Solid, SpreadsheetColor.FromArgb(0, 112, 192), SpreadsheetColor.FromArgb(0, 112, 192));
}
public static void StandartInlineRecordNumberCell(GemboxTableHandler.Table.Range x, object[] dataRow = null, object GlobalConditionsObject = null)
{
x.Style.HorizontalAlignment = HorizontalAlignmentStyle.Center;
x.Style.Font.Color = SpreadsheetColor.FromArgb(105, 105, 105);
}
public static void CostGroupCell(GemboxTableHandler.Table.Range x, object[] dataRow = null, object GlobalConditionsObject = null)
{
x.Style.FillPattern.SetPattern(FillPatternStyle.Solid, SpreadsheetColor.FromArgb(255, 148, 57), SpreadsheetColor.FromArgb(255, 148, 57));
}
public static void StrengthGroupCell(GemboxTableHandler.Table.Range x, object[] dataRow = null, object GlobalConditionsObject = null)
{
x.Style.FillPattern.SetPattern(FillPatternStyle.Solid, SpreadsheetColor.FromArgb(107, 127, 188), SpreadsheetColor.FromArgb(107, 127, 188));
}
public static void SurvivabilityGroupCell(GemboxTableHandler.Table.Range x, object[] dataRow = null, object GlobalConditionsObject = null)
{
x.Style.FillPattern.SetPattern(FillPatternStyle.Solid, SpreadsheetColor.FromArgb(3, 163, 5), SpreadsheetColor.FromArgb(3, 163, 5));
}
