private void 对齐ToolStripMenuItem_Click(object sender, EventArgs e) { Cell cell = DesignHelper.GetSelectedCell(sheet); if (cell != null) { List <CellStruct> list = DesignHelper.GetListCellStruct(cell, dt); cell.VerticalAlignment = CellVerticalAlignment.Bottom; foreach (CellStruct cellStruct in list) { cellStruct.DrawInfo.Format.Alignment = DesignHelper.ConvertVAlignmentToStringAlignment(CellVerticalAlignment.Bottom); } tool_Save.Enabled = true; } }
//取消合并单元格 private void tool_CancelMerge_Click(object sender, EventArgs e) { CellRange range = sheet.GetSelection(0); if (range != null) { CellStruct orginalCellStrct = dt.Rows[range.Row][range.Column] as CellStruct; int x = orginalCellStrct.DrawInfo.Point.X; int y = orginalCellStrct.DrawInfo.Point.Y; for (int i = range.Row; i < range.Row + range.RowCount; i++) { int height = Convert.ToInt32(sheet.Rows[i].Height); for (int j = range.Column; j < range.Column + range.ColumnCount; j++) { sheet.RemoveSpanCell(i, j); //CellStruct cellStruct = dt.Rows[i][j] as CellStruct; CellStruct cellStruct = new CellStruct("", null, null); cellStruct.Context = sheet.Cells[i, j].Text; DrawInfo drawInfo = new DrawInfo(); if (sheet.Cells[i, j].Border != null) { drawInfo.BoundaryLine.UpperBoundaryLine = sheet.Cells[i, j].Border.Inset.Top == 1; drawInfo.BoundaryLine.LowerBoundaryLine = sheet.Cells[i, j].Border.Inset.Bottom == 1; drawInfo.BoundaryLine.LeftBoundaryLine = sheet.Cells[i, j].Border.Inset.Left == 1; drawInfo.BoundaryLine.RightBooundaryLine = sheet.Cells[i, j].Border.Inset.Right == 1; } int width = Convert.ToInt32(sheet.Columns[j].Width); drawInfo.Size = new Size(width, height); drawInfo.Point = new Point(x, y); x += width; drawInfo.Format.LineAlignment = DesignHelper.ConvertHAlignmentToStringAlignment(sheet.Cells[i, j].HorizontalAlignment); drawInfo.Format.Alignment = DesignHelper.ConvertVAlignmentToStringAlignment(sheet.Cells[i, j].VerticalAlignment); drawInfo.Font = sheet.Cells[i, j].Font; cellStruct.DrawInfo = drawInfo; cellStruct.ExcelInfo = new ExcelInfo(1, 1); dt.Rows[i][j] = cellStruct; } y += height; } } }