BorderCollapse Property (SpreadView)

Gets or sets whether adjacent cell borders are collapsed into a single line in the view.

Syntax

Visual Basic
C#

'Declaration
 
Public Property BorderCollapse As BorderCollapse

'Usage
 
Dim instance As SpreadView
Dim value As BorderCollapse
 
instance.BorderCollapse = value
 
value = instance.BorderCollapse

public BorderCollapse BorderCollapse {get; set;}

Property Value

BorderCollapse setting specifying how to collapse borders

Example

This example sets the BorderCollapse property.

FarPoint.Win.Spread.SpreadView sv;
sv = fpSpread1.GetRootWorkbook();
sv.Sheets[0].Cells[0, 0, 20, 20].Border = new FarPoint.Win.BevelBorder(FarPoint.Win.BevelBorderType.Raised, Color.Teal, Color.LightBlue,
2);
sv.BorderCollapse = FarPoint.Win.Spread.BorderCollapse.Collapse;

VB.NET

Dim sv As FarPoint.Win.Spread.SpreadView
sv = FpSpread1.GetRootWorkbook()
sv.Sheets(0).Cells(0, 0, 20, 20).Border = New FarPoint.Win.BevelBorder(FarPoint.Win.BevelBorderType.Raised, Color.Teal, Color.LightBlue,
2)
sv.BorderCollapse = FarPoint.Win.Spread.BorderCollapse.Collapse

Requirements

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

Reference

SpreadView Class
SpreadView Members
BorderCollapse Enum

User-Task Documentation

Customizing Cell Borders