private void Format_top_block()
{
//format title block
xl.range = xl.Select_range(2, 2, 6, 2);
xl.range.Font.Bold = true;
xl.range.HorizontalAlignment = Excel.XlHAlign.xlHAlignRight;
xl.range = xl.Select_range(2, 3, 6, 3);
xl.range.HorizontalAlignment = Excel.XlHAlign.xlHAlignLeft;
//format subtotals block
xl.range = xl.Select_range(2, 5, 7, 5);
xl.range.HorizontalAlignment = Excel.XlHAlign.xlHAlignRight;
xl.range = xl.Select_range(2, 6, 3, 6);
xl.range.Style = xl.workbook.Styles["Currency"];
xl.range = xl.Select_range(4, 5, 4, 6);
xl.range.Font.Bold = true;
xl.range = xl.Select_range(5, 6, 7, 6);
xl.range.Style = xl.workbook.Styles["Currency"];
xl.range = xl.Select_range(7, 5, 7, 6);
xl.range.Font.Bold = true;
xl.range = xl.Select_range(2, 8, 6, 8);
xl.range.HorizontalAlignment = Excel.XlHAlign.xlHAlignRight;
xl.range = xl.Select_range(3, 9, 3, 9);
xl.range.Style = xl.workbook.Styles["Currency"];
xl.range = xl.Select_range(6, 9, 6, 9);
xl.range.Style = xl.workbook.Styles["Currency"];
}
private void Format_quote_body()
{
//set column widths
//xl.worksheet.Cells[1, 1].ColumnWidth = 10;
xl.worksheet.Cells[1, qs.quantityCol].ColumnWidth = 6;
xl.worksheet.Cells[1, qs.descriptionCol].ColumnWidth = 26;
xl.worksheet.Cells[1, qs.serviceCol].ColumnWidth = 35;
xl.worksheet.Cells[1, qs.materialCol].ColumnWidth = 20;
xl.worksheet.Cells[1, qs.sizeCol].ColumnWidth = 12;
xl.worksheet.Cells[1, qs.ratingCol].ColumnWidth = 12;
xl.worksheet.Cells[1, qs.lengthCol].ColumnWidth = 12;
xl.worksheet.Cells[1, qs.materialBufferCol].ColumnWidth = 12;
xl.worksheet.Cells[1, qs.aCol].ColumnWidth = 8;
xl.worksheet.Cells[1, qs.bCol].ColumnWidth = 8;
xl.worksheet.Cells[1, qs.cCol].ColumnWidth = 8;
xl.worksheet.Cells[1, qs.unitsCol].ColumnWidth = 8;
xl.worksheet.Cells[1, qs.partNumCol].ColumnWidth = 12;
xl.worksheet.Cells[1, qs.partPriceCol].ColumnWidth = 14;
xl.worksheet.Cells[1, qs.materialPriceCol].ColumnWidth = 14;
xl.worksheet.Cells[1, qs.laborBufferCol].ColumnWidth = 12;
xl.worksheet.Cells[1, qs.plasmaLaborCol].ColumnWidth = 8;
xl.worksheet.Cells[1, qs.hoursCol].ColumnWidth = 8;
////hide material calculation columns
//xl.range = xl.Select_range(1, qs.aCol, 1, qs.partPriceCol);
//xl.range.EntireColumn.Hidden = true;
//format column headers
xl.range = xl.Select_range(qs.headerRow, qs.firstCol, qs.headerRow, qs.lastCol);
xl.range.Font.Bold = true;
xl.range.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
//set top boundary
xl.range = xl.Select_range(qs.headerRow + 1, qs.firstCol, qs.headerRow + 1, qs.lastCol);
xl.range.EntireRow.RowHeight = 3;
xl.range.Interior.Color = Excel.XlRgbColor.rgbBlack;
//set bottom boundary
xl.range = xl.Select_range(qs.lastRow + 1, qs.firstCol, qs.lastRow + 1, qs.lastCol);
xl.range.EntireRow.RowHeight = 3;
xl.range.Interior.Color = Excel.XlRgbColor.rgbBlack;
//format item cells
xl.range = xl.Select_range(qs.firstRow, qs.firstCol, qs.lastRow, qs.lastCol);
xl.range.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
xl.range = xl.Select_range(qs.firstRow, qs.partPriceCol, qs.lastRow, qs.partPriceCol);
xl.range.Style = xl.workbook.Styles["Currency"];
xl.range = xl.Select_range(qs.firstRow, qs.materialPriceCol, qs.lastRow, qs.materialPriceCol);
xl.range.Style = xl.workbook.Styles["Currency"];
}
