Spread ASP.NET 6.0 Product Documentation
ShowEllipsis Property
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > ButtonCellType Class : ShowEllipsis Property


Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
Public Property ShowEllipsis As Boolean
Visual Basic (Usage)Copy Code
Dim instance As ButtonCellType
Dim value As Boolean
 
instance.ShowEllipsis = value
 
value = instance.ShowEllipsis
C# 
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.
C#Copy Code
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 BasicCopy Code
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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.