public CellFormatSpecification CreateCellFormat(string name, int fontSize) { CellFormatSpecification cellFormatSpecification = new CellFormatSpecification(name); InitializeFont(this.startRange.Font, cellFormatSpecification); cellFormatSpecification.Font.Size = fontSize; return(cellFormatSpecification); }
public CellFormatSpecification CreateCellFormat(string name, int fontSize, XlHAlign horizontalAlignment) { CellFormatSpecification cellFormatSpecification = new CellFormatSpecification(name); InitializeFont(this.startRange.Font, cellFormatSpecification); cellFormatSpecification.Font.Size = fontSize; cellFormatSpecification.HorizontalAlignment = horizontalAlignment; return(cellFormatSpecification); }
public CellFormatSpecification CreateCellFormat(string name, int fontSize, Excel.MakeBold makeBold, XlOrientation orientation) { CellFormatSpecification cellFormatSpecification = new CellFormatSpecification(name); InitializeFont(this.startRange.Font, cellFormatSpecification); cellFormatSpecification.Font.Size = fontSize; cellFormatSpecification.Font.Bold = makeBold; cellFormatSpecification.Orientation = orientation; return(cellFormatSpecification); }
public CellFormatSpecification CreateCellFormat(string name, CellFormatSpecification sourceFormat) { CellFormatSpecification newCellFormatSpecification = new CellFormatSpecification(name); InitializeFont(sourceFormat, newCellFormatSpecification); newCellFormatSpecification.HorizontalAlignment = sourceFormat.HorizontalAlignment; newCellFormatSpecification.NumberFormat = sourceFormat.NumberFormat; newCellFormatSpecification.Orientation = sourceFormat.Orientation; newCellFormatSpecification.VerticalAlignment = sourceFormat.VerticalAlignment; newCellFormatSpecification.WrapText = sourceFormat.WrapText; return(newCellFormatSpecification); }
public static void InitializeFont(CellFormatSpecification source, CellFormatSpecification target) { target.Font.Background = source.Font.Background; target.Font.Bold = source.Font.Bold; target.Font.Color = source.Font.Color; target.Font.ColorIndex = source.Font.ColorIndex; target.Font.FontStyle = source.Font.FontStyle; target.Font.Italic = source.Font.Italic; target.Font.Name = source.Font.Name; target.Font.OutlineFont = source.Font.OutlineFont; target.Font.Shadow = source.Font.Shadow; target.Font.Size = source.Font.Size; target.Font.Strikethrough = source.Font.Strikethrough; target.Font.Subscript = source.Font.Subscript; target.Font.Superscript = source.Font.Superscript; target.Font.Underline = source.Font.Underline; // null by default //target.Font.ThemeColor = source.Font.ThemeColor; target.Font.TintAndShade = source.Font.TintAndShade; target.Font.ThemeFont = source.Font.ThemeFont; }
public static void InitializeFont(Microsoft.Office.Interop.Excel.Font rangeFont, CellFormatSpecification formatSpecification) { formatSpecification.Font.Background = rangeFont.Background; formatSpecification.Font.Bold = rangeFont.Bold; formatSpecification.Font.Color = rangeFont.Color; formatSpecification.Font.ColorIndex = rangeFont.ColorIndex; formatSpecification.Font.FontStyle = rangeFont.FontStyle; formatSpecification.Font.Italic = rangeFont.Italic; formatSpecification.Font.Name = rangeFont.Name; formatSpecification.Font.OutlineFont = rangeFont.OutlineFont; formatSpecification.Font.Shadow = rangeFont.Shadow; formatSpecification.Font.Size = rangeFont.Size; formatSpecification.Font.Strikethrough = rangeFont.Strikethrough; formatSpecification.Font.Subscript = rangeFont.Subscript; formatSpecification.Font.Superscript = rangeFont.Superscript; formatSpecification.Font.Underline = rangeFont.Underline; // null by default //formatSpecification.Font.ThemeColor = rangeFont.ThemeColor; formatSpecification.Font.TintAndShade = rangeFont.TintAndShade; formatSpecification.Font.ThemeFont = rangeFont.ThemeFont; }