public void Copy(RelativeTo rt) { if (rt == null) { return; } horizontal = rt.horizontal; vertical = rt.vertical; }
public int SetCell( int font = (int)FONT_STYLE.NORMAL, int fill = (int)FILL_STYLE.NONE, int border = (int)BORDER_STYLE.NO_BORDER, int format = 0, HORIZONTAL_ALIGN horizontal = HORIZONTAL_ALIGN.LEFT, VERTICAL_ALIGN vertical = VERTICAL_ALIGN.TOP, bool wrapText = true ) { CellFormat cell = new CellFormat() { FontId = (uint)font, FillId = (uint)fill, BorderId = (uint)border, FormatId = (uint)0U, NumberFormatId = (uint)format, ApplyFill = true }; Alignment align = new Alignment() { WrapText = wrapText, }; if (horizontal == HORIZONTAL_ALIGN.CENTER) { align.Horizontal = DocumentFormat.OpenXml.Spreadsheet.HorizontalAlignmentValues.Center; } if (horizontal == HORIZONTAL_ALIGN.RIGHT) { align.Horizontal = DocumentFormat.OpenXml.Spreadsheet.HorizontalAlignmentValues.Right; } if (vertical == VERTICAL_ALIGN.TOP) { align.Vertical = VerticalAlignmentValues.Top; } if (vertical == VERTICAL_ALIGN.CENTER) { align.Vertical = VerticalAlignmentValues.Center; } if (vertical == VERTICAL_ALIGN.BOTTOM) { align.Vertical = VerticalAlignmentValues.Bottom; } cell.Append(align); return(this.SetStyle <CellFormat>(cell)); }
public void Copy(RelativeTo rt) { if (rt == null) return; horizontal = rt.horizontal; vertical = rt.vertical; }