FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : RemoveSpanCell Method |
You can remove a span range by calling this method, specifying the anchor cell of the span range to remove the range.
When you remove a span range, the data that was previously in each of the cells in the span is re-displayed in the cell. The data was never removed from the cell, but simply hidden by the span range. Also, the cell types of the cells combined in the span are not changed.
Create a span of cells by calling the AddSpanCell method. Return whether a cell is in a span range, and the size of the range if it is in one, by calling the GetSpanCell method.
private void PageLoad(object sender, System.EventArgs e) { FarPoint.Web.Spread.SheetView sv; sv = FpSpread1.ActiveSheetView; sv.AddSpanCell(1, 1, 2, 3); } private void Button1Click(object sender, System.EventArgs e) { FarPoint.Web.Spread.SheetView sv; sv = FpSpread1.ActiveSheetView; sv.Cells[1, 0].Value = 100; sv.RemoveSpanCell(1, 1); }
Private Sub PageLoad(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim sv As FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView sv.AddSpanCell(1, 1, 2, 3) End Sub Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim sv As FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView sv.Cells(1, 0).Value = 100 sv.RemoveSpanCell(1, 1) End Sub
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
SheetView Class
SheetView Members
AddSpanCell Method
GetSpanCell Method