DefaultColumnWidth Property

Gets or sets the default column width in pixels for all columns in the sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Property DefaultColumnWidth As Integer

'Usage
 
Dim instance As SheetView
Dim value As Integer
 
instance.DefaultColumnWidth = value
 
value = instance.DefaultColumnWidth

public int DefaultColumnWidth {get; set;}

Property Value

Integer number of pixels of the default column width

Remarks

Set this property to specify the width in pixels for all columns in the sheet. If you want to specify the width for a particular column in the sheet, use the SetColumnWidth method or the Width method for a Column object.

To set the height for all rows in the sheet, set the DefaultRowHeight property.

Example

This example changes the default settings for the width of columns and height of rows of a sheet.

FarPoint.Web.Spread.SheetView sv=FpSpread1.ActiveSheetView;
sv.DefaultColumnWidth=120;
sv.DefaultRowHeight=30;

Visual Basic

Dim sv As FarPoint.Web.Spread.SheetView
sv=FpSpread1.ActiveSheetView
sv.DefaultColumnWidth=120
sv.DefaultRowHeight=30

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

SheetView Class
SheetView Members
SetColumnWidth Method
DefaultRowHeight Property
GetColumnWidth Method
Width Property

User-Task Documentation

Setting the Column Width