Spread for ASP.NET 9.0 Product Documentation
ShowEllipsis Property (ButtonCellType)
Example 


Gets or sets whether to render ellipsis (...) to indicate text overflow in the cell.
Syntax
'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;
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
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

ButtonCellType Class
ButtonCellType Members

 

 


Copyright © GrapeCity, inc. All rights reserved.