ShowEllipsis Property (ButtonCellType)

Gets or sets whether to render ellipsis (...) to indicate text overflow in the cell.

Syntax

Visual Basic
C#

'Declaration
 
Public Property ShowEllipsis As Boolean

'Usage
 
Dim instance As ButtonCellType
Dim value As Boolean
 
instance.ShowEllipsis = value
 
value = instance.ShowEllipsis

public bool ShowEllipsis {get; set;}

Remarks

The AllowWrap property should be false for this property to take effect.

Example

This example sets the ShowEllipsis property.

FarPoint.Web.Spread.ComboBoxCellType cb = new FarPoint.Web.Spread.ComboBoxCellType();
FarPoint.Web.Spread.ListItem[] items = new FarPoint.Web.Spread.ListItem[3];
FarPoint.Web.Spread.ListItem item = new FarPoint.Web.Spread.ListItem();
item.Text = "This is a test of show ellipsis";
item.Value = "1";
items[0] = item;
item = new FarPoint.Web.Spread.ListItem();
item.Text = "B";
item.Value = "2";
items[1] = item;
cb.ListItems = items;
cb.AllowWrap = true;
cb.ShowEllipsis = false;
FpSpread1.ActiveSheetView.Cells[0,0].CellType = cb;
FpSpread1.ActiveSheetView.Cells[0,0].Value = "1";
    
FarPoint.Web.Spread.ButtonCellType btest = new FarPoint.Web.Spread.ButtonCellType();
btest.ButtonType = FarPoint.Web.Spread.ButtonType.LinkButton;
btest.AllowWrap = false;
btest.ShowEllipsis = true;
btest.Text = "this is a test of allow wrap";
FpSpread1.Sheets[0].Cells[0, 1].CellType = btest;
    
string linkURL = "http://www.FarPointSpread.com";
string linkTarget = "_blank";
FarPoint.Web.Spread.HyperLinkCellType linkcell = new FarPoint.Web.Spread.HyperLinkCellType();
linkcell.NavigateUrl = linkURL;
linkcell.Target = linkTarget;
linkcell.AllowWrap = false;
linkcell.ShowEllipsis = true;
FpSpread1.Sheets[0].Cells[1, 1].CellType = linkcell;

Visual Basic

Dim cb As New FarPoint.Web.Spread.ComboBoxCellType
Dim items(2) As FarPoint.Web.Spread.ListItem
Dim item As New FarPoint.Web.Spread.ListItem
item.Text = "This is a test of show ellipsis"
item.Value = "1"
items(0) = item
item = New FarPoint.Web.Spread.ListItem
item.Text = "B"
item.Value = "2"
items(1) = item
cb.ListItems = items
cb.AllowWrap = True
cb.ShowEllipsis = False
FpSpread1.ActiveSheetView.Cells(0, 0).CellType = cb
FpSpread1.ActiveSheetView.Cells(0, 0).Value = "1"

Dim btest As New FarPoint.Web.Spread.ButtonCellType
btest.ButtonType = FarPoint.Web.Spread.ButtonType.LinkButton
btest.AllowWrap = False
btest.ShowEllipsis = True
btest.Text = "this is a test of allow wrap"
FpSpread1.Sheets(0).Cells(0, 1).CellType = btest

Dim linkURL As String = "http://www.FarPointSpread.com"
Dim linkTarget As String = "_blank"
Dim linkcell As New FarPoint.Web.Spread.HyperLinkCellType()
linkcell.NavigateUrl = linkURL
linkcell.Target = linkTarget
linkcell.AllowWrap = False
linkcell.ShowEllipsis = True
FpSpread1.Sheets(0).Cells(1, 1).CellType = linkcell

Reference

ButtonCellType Class
ButtonCellType Members