Spread Windows Forms 10.0 Product Documentation
GetMergeCells Method
Example 


Returns all merged cell ranges for the view.
Syntax
'Declaration
 
Public Function GetMergeCells() As ArrayList
'Usage
 
Dim instance As SpreadView
Dim value As ArrayList
 
value = instance.GetMergeCells()
public ArrayList GetMergeCells()

Return Value

An array list of CellRange objects
Example
This example uses the GetMergeCells method.
fpSpread1.Sheets[0].SetRowMerge(-1, FarPoint.Win.Spread.Model.MergePolicy.Always);
fpSpread1.Sheets[0].SetColumnMerge(-1, FarPoint.Win.Spread.Model.MergePolicy.Always);
fpSpread1.Sheets[0].Cells[0, 0].Text = "Test";
fpSpread1.Sheets[0].Cells[1, 0].Text = "Test";
fpSpread1.Sheets[0].Cells[0, 1].Text = "Test";
fpSpread1.Sheets[0].Cells[1, 1].Text = "Test";

FarPoint.Win.Spread.SpreadView sv;
sv = fpSpread1.GetRootWorkbook();
listBox1.Items.Add(sv.GetMergeCells().Count);
FpSpread1.Sheets(0).SetRowMerge(-1, FarPoint.Win.Spread.Model.MergePolicy.Always)
FpSpread1.Sheets(0).SetColumnMerge(-1, FarPoint.Win.Spread.Model.MergePolicy.Always)
FpSpread1.Sheets(0).Cells(0, 0).Text = "Test"
FpSpread1.Sheets(0).Cells(1, 0).Text = "Test"
FpSpread1.Sheets(0).Cells(0, 1).Text = "Test"
FpSpread1.Sheets(0).Cells(1, 1).Text = "Test"

Dim sv As FarPoint.Win.Spread.SpreadView
sv = FpSpread1.GetRootWorkbook()
ListBox1.Items.Add(sv.GetMergeCells().Count)
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

SpreadView Class
SpreadView Members

 

 


Copyright © GrapeCity, inc. All rights reserved.