Spread COM Property Equivalents in .NET

About

FpSpread.About

ActiveCellHighlightStyle

No equivalent property, but you can customize the focus indicator

ActiveCol

SheetView.ActiveColumn

SheetView.ActiveColumnIndex

ActiveRow

SheetView.ActiveRow

SheetView.ActiveRowIndex

ActiveSheet

FpSpread.ActiveSheet

FpSpread.ActiveSheetIndex

AllowCellOverflow

FpSpread.AllowCellOverflow

AllowColMove

FpSpread.AllowColumnMove

AllowDragDrop

FpSpread.AllowDragDrop

AllowEditOverflow

FpSpread.AllowEditOverflow

AllowMultiBlocks

SheetView.SelectionPolicy

Enumeration: Model.SelectionPolicy

AllowRowMove

FpSpread.AllowRowMove

AllowUserFormulas

FpSpread.AllowUserFormulas

AllowUserZoom

FpSpread.AllowUserZoom

Appearance

FpSpread.BorderStyle

ArrowsExitEditMode

Cannot set at the component level, but can set for cells using the AcceptsArrowKeys property in FarPoint.Win.Spread.CellType.EditBaseCellType and FarPoint.Win.Spread.CellType.ComboBoxCellType classes Enumeration: FarPoint.Win.AcceptsArrowKeys

AutoCalc

SheetView.AutoCalculation

AutoClipboard

FpSpread.AutoClipboard

AutoSize

No equivalent; the FpSpread component does not change size based on modifying the columns or rows

BackColor

Cell.BackColor

Column.BackColor

Row.BackColor

SheetView.DefaultStyle.BackColor

FpSpread.BackColor (inherited from System.Windows.Forms.Control)

BackColorStyle

No equivalent; no such behavior with the grid lines and background color

BlockMode

SheetView.SelectionPolicy and OperationMode enumeration are close but not identical to this

BorderStyle (standard Visual Basic property)

FpSpread.BorderStyle

ButtonDrawMode

FpSpread.ButtonDrawMode

CausesValidation (standard Visual Basic property)

FpSpread.CausesValidation (inherited from System.Windows.Forms.Control)

CellNote

Cell.Note SheetView.GetNote SheetView.SetNote

CellNoteIndicator

FpSpread.CellNoteIndicatorVisible

CellTag

Cell.Tag

Column.Tag

FpSpread.Tag (inherited from System.Windows.Forms.Control)

Row.Tag

SheetView.GetTag

SheetView.SetTag

SheetView.Tag

These properties are only available at run time

CellType

Cell.CellType

Column.CellType

Row.CellType

SheetView.DefaultStyle.CellType

ChangeMade

No equivalent; the FpSpread does not keep track of any changes made in the same way

Clip

Methods:

ColumnHeader.GetClip and SetClip

RowHeader.GetClip and SetClip

SheetView.GetClip and SetClip

ClipboardOptions

FpSpread.ClipboardOptions

Enumeration: ClipboardOptions

Spread.NET offers fewer settings than Spread COM

ClipValue

Methods:

ColumnHeader.GetClipValue and SetClipValue

RowHeader.GetClipValue and SetClipValue

SheetView.GetClipValue and SetClipValue

Col

No equivalent property; now supplied as a parameter for methods or implied by the object being used

Col2

No equivalent property; now supplied as a parameter for methods or implied by the object being used

ColHeaderRows

ColumnHeader.RowCount

SheetView.ColumnHeaderRowCount

ColHeadersAutoText

ColumnHeader.AutoText

SheetView.ColumnHeaderAutoText

ColHeadersAutoTextIndex

ColumnHeader.AutoTextIndex

SheetView.ColumnHeaderAutoTextIndex

ColHeadersShow

ColumnHeader.Visible

SheetView.ColumnHeaderVisible

ColHeadersUserSortIndex

ColumnHeader.AutoSortIndex

SheetView.ColumnHeaderAutoSortIndex

ColHidden

Column.Visible

SheetView.GetColumnVisible

SheetView.SetColumnVisible

SheetView.ColumnHeaderVisible

ColID

Use Column.Tag to provide the column identifier

ColMerge

SheetView.GetColumMerge

SheetView.SetColumMerge

Enumeration:

Model.MergePolicy

Header data is not automatically merged

ColPageBreak

Column.PageBreak

SheetView.GetColumnPageBreak

SheetView.SetColumnPageBreak

ColsFrozen

SheetView.FrozenColumnCount

ColUserSortIndicator

Column.SortIndicator

SheetView.GetColumnSortIndicator

SheetView.SetColumnSortIndicator

Enumeration:

Model.SortIndicator

ColWidth

Column.Width

SheetView.GetColumnWidth

SheetView.SetColumnWidth

CursorIcon

CursorStyle

CursorType

FpSpread.GetCursor

FpSpread.SetCursor

Enumeration: CursorType

DataBindings (standard Visual Basic property)

FpSpread.DataBindings (inherited from System.Windows.Forms.Control)

DataColCnt

SheetView.GetLastNonEmptyColumn

SheetView.NonEmptyColumnCount

DataField

Column.DataField

DataFillEvent

No equivalent; not handled the same in .NET

DataMember

FpSpread.DataMember

SheetView.DataMember

DataRowCnt

SheetView.GetLastNonEmptyRow

SheetView.NonEmptyRowCount

DataSource

FpSpread.DataSource

SheetView.DataSource

DAutoCellTypes

SheetView.DataAutoCellTypes

DAutoFill

No equivalent; not handled the same in .NET

DAutoHeadings

SheetView.DataAutoHeadings

DAutoSave

No equivalent; not handled the same in .NET

DAutoSizeCols

SheetView.DataAutoSizeColumns

This uses a setting similar to Spread COM Best Guess setting; to emulate the Spread COM MaxTextColWidth setting, call the SheetView.GetPreferredColumnWidth method

DInformActiveRowChange

No equivalent; not handled the same in .NET

EditEnterAction

Use action maps and input maps; for more information on maps, refer to Managing Keyboard Interaction

EditMode

FpSpread.EditMode

EditModePermanent

FpSpread.EditModePermanent

EditModeReplace

FpSpread.EditModeReplace

Enabled (standard Visual Basic property)

FpSpread.Enabled (inherited from System.Windows.Forms.Control)

EventEnabled

No equivalent; not handled the same in .NET

Font

FontBold

FontItalic

FontName

FontSize

FontStrikethru

FontUnderline

Cell.Font

Column.Font

FpSpread.Font

Row.Font

SheetView.DefaultStyle.Font

The Spread COM control combined the FontBold, FontItalic, FontName, FontSize, FontStrikethru, and FontUnderline properties into the Font property; the Font property is supported in Spread.NET, but the individual font properties in Spread COM are no longer supported separately

ForeColor

Cell.ForeColor

Column.ForeColor

Row.ForeColor

SheetView.DefaultStyle.ForeColor

Formula

Cell.Formula

Column.Formula

Row.Formula

SheetView.GetFormula

SheetView.SetFormula

FormulaSync

No equivalent; not handled the same in .NET; see

SheetView.RecalculateAll.

GrayAreaBackColor

SheetView.GrayAreaBackColor

GridColor

GridShowHoriz

GridShowVert

GridLine class constructors SheetView.HorizontalGridLine SheetView.VerticalGridLine

GridSolid

No equivalent; for more information about grid lines, refer to Displaying Grid Lines on a Sheet

hDCPrinter

PrintInfo.Printer

Height (standard Visual Basic property)

FpSpread.Height (inherited from System.Windows.Forms.Control)

hWnd

ColumnHeaderRenderer.Handle FpSpread.Handle GeneralEditor.Handle (inherited from System.Windows.Forms.Control)

Index (standard Visual Basic property)

Control.ControlCollection.GetChildIndex Control.ControlCollection.SetChildIndex

IsBlockSelected

SheetView.IsBlockSelected

Left (standard Visual Basic property)

FpSpread.Left (inherited from System.Windows.Forms.Control)

LeftCol

FpSpread.GetViewportLeftColumn FpSpread.SetViewportLeftColumn

Lock

Cell.Locked

Column.Locked

Row.Locked

SheetView.DefaultStyle.Locked

LockBackColor

SheetView.LockBackColor

LockForeColor

SheetView.LockForeColor

MaxCols

SheetView.ColumnCount

MaxRows

SheetView.RowCount

MaxTextCellHeight

MaxTextCellWidth

SheetView.GetPreferredCellSize

MaxTextColWidth

Column.GetPreferredWidth

SheetView.GetPreferredColumnWidth

MaxTextRowHeight

Row.GetPreferredHeight

SheetView.GetPreferredRowHeight

MouseIcon (standard Visual Basic property)

No supported .NET equivalent

MousePointer (standard Visual Basic property)

No supported .NET equivalent

MoveActiveOnFocus

FpSpread.MoveActiveOnFocus

Name (standard Visual Basic property)

FpSpread.Name (inherited from System.Windows.Forms.Control)

NoBeep

No supported .NET equivalent

NoBorder

No supported .NET equivalent

OLEDropMode

Inherited from .NET Control class

OperationMode

SheetView.OperationMode

Enumeration: OperationMode

Parent (standard Visual Basic property)

FpSpread.Parent (inherited from System.Windows.Forms.Control)

PrintAbortMsg

PrintInfo.AbortMessage

PrintBestFitPagesTall

PrintInfo.SmartPrintPagesTall Refer to Optimizing the Printing

PrintBestFitPagesWide

PrintInfo.SmartPrintPagesWide Refer to Optimizing the Printing

PrintBorder

PrintInfo.ShowBorder

PrintCenterOnPageH

PrintInfo.Centering (Horizontal) Refer to Optimizing the Printing

PrintCenterOnPageV

PrintInfo.Centering (Vertical) Refer to Optimizing the Printing

PrintColHeaders

PrintInfo.ShowColumnHeader

PrintColor

PrintInfo.ShowColor

PrintFirstPageNumber

PrintInfo.FirstPageNumber

PrintFooter

PrintInfo.Footer

PrintGrid

PrintInfo.ShowGrid

PrintHeader

PrintInfo.Header

PrintJobName

PrintInfo.JobName

PrintMarginBottom

PrintInfo.Margin

PrintMargin.Bottom

PrintMarginLeft

PrintInfo.Margin

PrintMargin.Left

PrintMarginRight

PrintInfo.Margin

PrintMargin.Right

PrintMarginTop

PrintInfo.Margin

PrintMargin.Top

PrintNextPageBreakCol

FpSpread.GetColumnPageBreaks

PrintNextPageBreakRow

FpSpread.GetRowPageBreaks

PrintOrientation

PrintInfo.Orientation

PrintPageCount

FpSpread.GetPrintPageCount

PrintPageEnd

PrintInfo.PageEnd

PrintPageOrder

PrintInfo.PageOrder

PrintPageStart

PrintInfo.PageStart

PrintRowHeaders

PrintInfo.ShowRowHeader

PrintScalingMethod

PrintInfo.SmartPrintRules and entire SmartPrintRule class

PrintShadows

PrintInfo.ShowShadows

PrintSmartPrint

PrintInfo.UseSmartPrint

PrintType

PrintInfo.PrintType

PrintUseDataMax

PrintInfo.UseMax

PrintZoomFactor

PrintInfo.ZoomFactor

ProcessTab

Use action maps and input maps; for more information on maps, refer to Managing Keyboard Interaction See the sample ProcessTab installed in the Samples folder that illustrates how to re-create Spread COM settings (where Samples are installed)

Protect

SheetView.Protect

ReDraw

FpSpread.ResumeLayout

FpSpread.SuspendLayout

RestrictCols

SheetView.RestrictColumns

RestrictRows

SheetView.RestrictRows

RetainSelBlock

FpSpread.RetainSelectionBlock

Row

No equivalent property; this is now supplied as a parameter for methods or implied by the object being used

Row2

No equivalent property; this is now supplied as a parameter for methods or implied by the object being used

RowHeaderCols

RowHeader.ColumnCount

SheetView.RowHeaderColumnCount

RowHeadersAutoText

RowHeader.AutoText

SheetView.RowHeaderAutoText

RowHeadersAutoTextIndex

RowHeader.AutoTextIndex

SheetView.RowHeaderAutoTextIndex

RowHeadersShow

RowHeader.Visible

SheetView.RowHeaderVisible

RowHeight

Row.Height

SheetView.GetRowHeight

SheetView.SetRowHeight

RowHidden

Row.Visible

SheetView.GetRowVisible

SheetView.SetRowVisible

SheetView.RowHeaderVisible

RowMerge

SheetView.GetRowMerge

SheetView.SetRowMerge

Enumeration: Model.MergePolicy

Header data is not automatically merged

RowPageBreak

Row.PageBreak

SheetView.GetRowPageBreak

SheetView.SetRowPageBreak

RowsFrozen

SheetView.FrozenRowCount

ScriptEnhanced

No supported equivalent in .NET

ScrollBarExtMode

FpSpread.HorizontalScrollBarPolicy

FpSpread.VerticalScrollBarPolicy

Enumeration: ScrollBarPolicy

ScrollBarHColor

No equivalent

ScrollBarHeight

FpSpread.HorizontalScrollBarHeight

ScrollBarMaxAlign

FpSpread.ScrollBarMaxAlign

ScrollBars

FpSpread.HorizontalScrollBarPolicy

FpSpread.VerticalScrollBarPolicy

Enumeration: ScrollBarPolicy

ScrollBarShowMax

FpSpread.ScrollBarShowMax

ScrollBarTrack

FpSpread.ScrollBarTrackPolicy

Enumeration: ScrollBarTrackPolicy

ScrollBarVColor

No equivalent

ScrollBarWidth

FpSpread.VerticalScrollBarWidth FpSpread.HorizontalScrollBarHeight

SelBackColor

Appearance.SelectionBackColor

SheetSkin.SelectionBackColor

SheetView.SelectionBackColor

SheetView.SelectionStyle

Enumeration: SelectionStyles

SelBlockCol

SheetView.GetSelection

SelBlockCol2

No equivalent

SelBlockRow

SheetView.GetSelection

SelBlockRow2

No equivalent

SelectBlockOptions

FpSpread.SelectionBlockOptions

Enumeration: SelectionBlockOptions

SelectionCount

SheetView.SelectionCount

SelForeColor

Appearance.SelectionForeColor

SheetSkin.SelectionForeColor

SheetView.SelectionForeColor

Enumeration: SelectionStyles

SelLength

GeneralEditor.SelectionLength

SelModeIndex

SheetView.GetSelection

SelModeSelected

SheetView.IsSelected

SelStart

GeneralEditor.SelectionStart

SelText

GeneralEditor.SelectedText

ShadowColor

ColumnHeader.Cells.BackColor

ColumnHeader.DefaultStyle.BackColor

RowHeader.Cells.BackColor

RowHeader.DefaultStyle.BackColor

These properties only affect the headers not static cells, unlike the Spread COM ShadowColor property

ShadowDark

GridLine class constructors

ShadowText

ColumnHeader.Cells.ForeColor

ColumnHeader.DefaultStyle.ForeColor

RowHeader.Cells.ForeColor

RowHeader.DefaultStyle.ForeColor

These properties only affect the headers not static cells, unlike the Spread COM ShadowText property

Sheet

FpSpread.Sheets

SheetCount

FpSpread.Sheets.Count

SheetName

SheetView.SheetName

SheetSendingEvent

No equivalent

SheetVisible

SheetView.Visible

ShowScrollTips

FpSpread.ScrollTipPolicy

Enumeration: ScrollTipPolicy

SortKey

SortInfo.Index

SortKeyOrder

SortInfo.Ascending

StartingColNumber

SheetView.StartingColumnNumber

StartingRowNumber

SheetView.StartingRowNumber

TabIndex (standard Visual Basic property)

FpSpread.TabIndex (inherited from System.Windows.Forms.Control)

TabStripFont

No equivalent

TabStripLeftSheet

FpSpread.LeftTab

TabStripPolicy

FpSpread.TabStripPolicy

TabStripRatio

FpSpread.TabStripRatio

TabStop (standard Visual Basic property)

FpSpread.TabStop (inherited from System.Windows.Forms.Control)

Tag (standard Visual Basic property)

Cell.Tag

Column.Tag

FpSpread.Tag (inherited from System.Windows.Forms.Control) Row.Tag SheetView.Tag

Text

ButtonCellType.Text

Cell.Text

HyperLinkCellType.Text

SheetView.SetText

TextTip

FpSpread.TextTipPolicy

Enumeration: TextTipPolicy

TextTipDelay

FpSpread.TextTipDelay

Top (standard Visual Basic property)

FpSpread.Top (inherited from System.Windows.Forms.Control)

TopRow

FpSpread.GetViewportTopRow

FpSpread.SetViewportTopRow

TwoDigitYearMax

DateTimeCellType.TwoDigitYearMax

TypeButtonAlign

ButtonCellType.TextAlign

Enumeration: FarPoint.Win.ButtonTextAlign

TypeButtonBorderColor

No equivalent

TypeButtonColor

ButtonCellType.ButtonColor

TypeButtonDarkColor

ButtonCellType.DarkColor

TypeButtonLightColor

ButtonCellType.LightColor

TypeButtonPicture

ButtonCellType.Picture

TypeButtonPictureDown

ButtonCellType.PictureDown

TypeButtonShadowSize

ButtonCellType.ShadowSize

TypeButtonText

ButtonCellType.Text

TypeButtonTextColor

ButtonCellType.TextColor

TypeButtonType

ButtonCellType.TwoState

TypeCheckCenter

No equivalent

TypeCheckPicture

CheckBoxCellType.Picture

TypeCheckText

CheckBoxCellType.TextFalse

CheckBoxCellType.TextIndeterminate

CheckBoxCellType.TextTrue

TypeCheckTextAlign

CheckBoxCellType.TextAlign

Enumeration: FarPoint.Win.ButtonTextAlign

TypeCheckType

CheckBoxCellType.ThreeState

TypeComboBoxAutoSearch

ComboBoxCellType.AutoSearch

TypeComboBoxCount

ComboBoxCellType.Items.Length

TypeComboBoxCurSel

No equivalent

TypeComboBoxEditable

ComboBoxCellType.Editable

TypeComboBoxhWnd

ComboBoxCellType.ListControl

TypeComboBoxIndex

ComboBoxCellType.Items

TypeComboBoxList

ComboBoxCellType.Items

TypeComboBoxMaxDrop

ComboBoxCellType.MaxDrop

TypeComboBoxString

ComboBoxCellType.Items

TypeComboBoxWidth

ComboBoxCellType.ListWidth

TypeCurrencyDecimal

CurrencyCellType.DecimalSeparator

TypeCurrencyDecPlaces

CurrencyCellType.DecimalPlaces

TypeCurrencyLeadingZero

CurrencyCellType.LeadingZero

Enumeration: CellType.LeadingZero

TypeCurrencyMax

CurrencyCellType.MaximumValue

TypeCurrencyMin

CurrencyCellType.MinimumValue

TypeCurrencyNegStyle

CurrencyCellType.NegativeFormat

Enumeration: CellType.CurrencyNegativeFormat

TypeCurrencyPosStyle

CurrencyCellType.PositiveFormat

Enumeration: CellType.CurrencyPositiveFormat

TypeCurrencySeparator

CurrencyCellType.Separator

TypeCurrencyShowSep

CurrencyCellType.ShowSeparator

TypeCurrencyShowSymbol

CurrencyCellType.ShowCurrencySymbol

TypeCurrencySymbol

CurrencyCellType.CurrencySymbol

TypeDateCentury

DateTimeCellType.DateTimeFormat

Enumeration: CellType.DateTimeFormat

TypeDateFormat

DateTimeCellType.DateTimeFormat

Enumeration: CellType.DateTimeFormat

TypeDateMax

DateTimeCellType.MaximumDate

TypeDateMin

DateTimeCellType.MinimumDate

TypeDateSeparator

DateTimeCellType.DateSeparator

TypeEditCharCase

TextCellType.CharacterCasing

Enumeration: CharacterCasing (.NET)

TypeEditCharSet

TextCellType.CharacterSet

Enumeration: CellType.CharacterSet

TypeEditMultiLine

TextCellType.Multiline

TypeEditPassword

TextCellType.PasswordChar

TypeEllipses

TextCellType.StringTrim Enumeration: StringTrimming (.NET)

TypeHAlign

Cell.HorizontalAlignment

Column.HorizontalAlignment

Row.HorizontalAlignment

SheetView.DefaultStyle.HorizontalAlignment

Enumeration: CellHorizontalAlignment

TypeMaxEditLen

TextCellType.MaxLength

TypeNegRed

CurrencyCellType.NegativeRed

GeneralCellType.NegativeRed

NumberCellType.NegativeRed

PercentCellType.NegativeRed

TypeNumberDecimal

NumberCellType.DecimalSeparator

TypeNumberDecPlaces

NumberCellType.DecimalPlaces

TypeNumberLeadingZero

NumberCellType.LeadingZero

Enumeration: CellType.LeadingZero

TypeNumberMax

NumberCellType.MaximumValue

TypeNumberMin

NumberCellType.MinimumValue

TypeNumberNegStyle

NumberCellType.NegativeFormat

Enumeration: CellType.NegativeFormat

TypeNumberSeparator

NumberCellType.Separator

TypeNumberShowSep

NumberCellType.ShowSeparator

TypeOwnerDrawStyle

Create a custom cell type.

TypePercentDecimal

PercentCellType.DecimalSeparator

TypePercentDecPlaces

PercentCellType.DecimalPlaces

TypePercentLeadingZero

PercentCellType.LeadingZero

Enumeration: CellType.LeadingZero

TypePercentMax

PercentCellType.MaximumValue

TypePercentMin

PercentCellType.MinimumValue

TypePercentNegStyle

PercentCellType.NegativeFormat

Enumeration: CellType.PercentNegativeFormat

TypePicDefaultText

MaskCellType.MaskChar

TypePicMask

MaskCellType.Mask

TypePictCenter

TypePictMaintainScale

TypePictPicture

TypePictStretch

ImageCellType.GetImage

Picture cells are similar to hyperlink cells in Spread.NET that have a picture but no link, or to other cell types with a picture specified for the BackgroundImage property; the FarPoint.Win.Picture class provides properties similar to these Spread COM properties

TypeScientificDecimal

TypeScientificDecPlaces

TypeScientificMax

TypeScientificMin

No equivalent

TypeSpin

CurrencyCellType.SpinButton

DateTimeCellType.SpinButton

NumberCellType.SpinButton

PercentCellType.SpinButton

TypeSpinInc

CurrencyCellType.SpinDecimalIncrement

CurrencyCellType.SpinIntegerIncrement

NumberCellType.SpinDecimalIncrement

NumberCellType.SpinIntegerIncrement

TypeSpinWrap

CurrencyCellType.SpinWrap

NumberCellType.SpinWrap

PercentCellType.SpinWrap

TypeTextOrient

EditBaseCellType.TextOrientation

Enumeration: FarPoint.Win.TextOrientation

TypeTextPrefix

TextCellType.HotkeyPrefix

TypeTextShadowTypeTextShadowIn

No equivalent Create a three-dimensional appearance by setting either lowered or raised grid lines or custom borders

TypeTextWordWrap

EditBaseCellType.WordWrap

TypeTime24Hour

DateTimeCellType.DateTimeFormat

Enumeration: CellType.DateTimeFormat

TypeTimeMax

DateTimeCellType.MaximumTime

TypeTimeMin

DateTimeCellType.MinimumTime

TypeTimeSeconds

DateTimeCellType.DateTimeFormat

Enumeration: CellType.DateTimeFormat

TypeTimeSeparator

DateTimeCellType.TimeSeparator

TypeVAlign

Cell.VerticalAlignment

Column.VerticalAlignment

Row.VerticalAlignment

SheetView.DefaultStyle.VerticalAlignment

Enumeration: CellVerticalAlignment

UnitType

No equivalent

UserColAction

Column.AllowAutoSort

SheetView.AutoSortColumns

UserResize

Columns.Default.Resizable

Rows.Default.Resizable

UserResizeCol

Column.Resizable

UserResizeRow

Row.Resizable

Value

Cell.Value

SheetView.GetValue

SheetView.SetValue

The property and methods are not exactly the same; the Spread COM Value property gets or sets string values; the new Value property and GetValue and SetValue methods get or set objects

VirtualCurRowCount

VirtualCurTop

VirtualMaxRows

VirtualMode

VirtualOverlap

VirtualRows

VirtualScrollBuffer

No equivalent

Visible (standard Visual Basic property)

FpSpread.Visible(inherited from System.Windows.Forms.Control)

VisibleCols

VisibleRows

No equivalent See Column.Visible and Row.Visible

VScrollSpecial

VScrollSpecialType

No equivalent

Width (standard Visual Basic property)

FpSpread.Width (inherited from System.Windows.Forms.Control)