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;
}
}
}