Spread COM Method Equivalents in .NET

AboutBox

FpSpread.About property

AddCellSpan

SheetView.AddSpanCell

AddSelection

SheetView.AddSelection

CFGetCellParam

CFGetCellParamExt

CFGetDoubleParam

CFGetDoubleParamExt

CFGetLongParam

CFGetParamInfo

CFGetRangeParam

CFGetRangeParamExt

CFGetStringParam

CFSetResult

No equivalent

In the Spread COM control, custom functions were evaluated inside the CustomFunction event; in Spread.NET, custom functions are evaluated inside an Evaluate method in classes in the CalcEngine assembly

ClearRange

SheetView.ClearRange

ClearSelection

SheetView.ClearSelection

ClipboardCopy

SheetView.ClipboardCopy

SpreadActions.ClipboardCopy field

ClipboardCut

SheetView.ClipboardCut

SpreadActions.ClipboardCut field

ClipboardPaste

SheetView.ClipboardPaste

SpreadActions.ClipboardPaste field

ColLetterToNumber

No equivalent

ColNumberToLetter

SheetView.GetColumnAutoText

This method returns the letter for a column if the automatic text is letters and the starting letter has not been changed

ColWidthToTwips

No equivalent Column widths are set and returned in pixels

CopyColRange

CopyRange

CopyRowRange

SheetView.CopyRange

DataRefresh

No equivalent

DataSave

No equivalent

DeleteCols

Column.Remove

Columns.Remove

SheetView.RemoveColumns

DeleteRows

Row.Remove

Rows.Remove

SheetView.RemoveRows

DeleteSheets

SheetViewCollection.Remove

EnumCustomFunction

SheetView.GetCustomFunctionEnumerator

ExportExcelBook (saves all sheets in the workbook)

FpSpread.SaveExcel (saves all sheets in the component)

ExportExcelBookEx

FpSpread.SaveExcel methods that have the ExcelSaveFlag parameter

Enumeration: ExcelSaveFlags

ExportRangeToHTML

SaveHtmlRange

ExportRangeToTextFile

SheetView.SaveTextFileRange

ExportRangeToTextFileU

No equivalent

ExportRangeToXML ExportRangeToXMLBuffer

SaveXml The FpSpread.Save method saves the component’s contents to a proprietary XML file; this is not the same as the XML export provided in Spread COM

ExportToExcel (saves an individual sheet)

FpSpread.SaveExcel (saves all sheets in the component)

ExportToExcelEx (saves an individual sheet)

FpSpread.SaveExcel methods that have the ExcelSaveFlag parameter (saves all sheets in the component) Enumeration: ExcelSaveFlags

ExportToHTML

No equivalent

ExportToTextFile

SheetView.SaveTextFile

ExportToTextFileU

No equivalent

ExportToXML

ExportToXMLBuffer

No equivalent

GetActionKey

InputMap.AllKeys

InputMap.Get

InputMap.Keys

GetArray

SheetView.GetArray

GetBottomRightCell

FpSpread.GetViewportBottomRow

FpSpread.GetViewportRightColumn

GetCalTextOverride

No equivalent Calendar text settings are for individual components unlike Spread COM, which sets global calendar text for all controls in a project or for individual controls

GetCellBorder

Cell.Border

Column.Border

Row.Border

GetCellDirtyFlag

No equivalent

GetCellFromScreenCoord

FpSpread.GetCellFromPixel Position is specified in pixels rather than twips as in Spread COM

GetCellPos

FpSpread.GetCellRectangle

GetCellSpan

SheetView.GetSpanCell

GetClientArea

FpSpread.ClientRectangle (inherited from System.Windows.Forms.Control) The Spread COM GetClientArea method returned the area of the control excluding the scroll bars; the ClientRectangle method returns the area of the component including the scroll bars

GetColFromID

SheetView.GetColumnFromTag

GetColItemData

Column.Tag

GetCustomName

SheetView.GetCustomName

GetDataFillData

No equivalent

GetExcelSheetList

FpSpread.GetExcelSheetNames

GetFirstValidCell

No equivalent

GetFloat

Cell.Value

SheetView.GetValue

GetInteger

Cell.Value

SheetView.GetValue

GetItemData

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

GetIteration

SheetView.Iteration

SheetView.MaximumChange

SheetView.MaximumIterations

GetLastValidCell

No equivalent

GetMultiSelItem

SheetView.GetSelections

SheetView.SelectionCount

SheetView.GetSelection

GetOddEvenRowColor

AlternatingRow.BackColor

AlternatingRow.ForeColor

GetRefStyle

SheetView.ReferenceStyle

Enumeration: Model.ReferenceStyle

GetRowItemData

Row.Tag

SheetView.GetTag

SheetView.SetTag

GetSelection

SheetView.GetSelection

GetText

Cell.Text

SheetView.GetText

GetTextTipAppearance

No equivalent

See the FpSpread.TextTipAppearance property

ImportExcelBook

FpSpread.OpenExcel

ImportExcelSheet

FpSpread.OpenExcel

SheetView.OpenExcel

InsertCols

Column.Add

Columns.Add

SheetView.AddColumns

InsertRows

Row.Add

Rows.Add

SheetView.AddRows

InsertSheets

SheetViewCollection.Insert

IsCellSelected

SheetView.IsSelected

IsExcelFile

FpSpread.IsExcelFile

IsFetchCellNote

TextTipFetchEventArgs.FetchCellNote

IsFormulaValid

No equivalent

IsVisible

No equivalent

LoadFromFile

FpSpread.Open

LoadPicture

FarPoint.Win.Picture

LoadPictureBuffer

No equivalent; use .NET methods

LoadResPicture

No equivalent; use .NET methods

LoadTabFile

SheetView.LoadTextFile

LoadTextFile

SheetView.LoadTextFile

MoveColRange

MoveRange

MoveRowRange

SheetView.MoveRange

MoveSheets

No equivalent

OLEDrag

Inherited from .NET Control class

OwnerPrintDraw

FpSpread.OwnerPrintDraw

OwnerPrintPageCount

FpSpread.GetPrintPageCount

PrintSheet

FpSpread.PrintSheet

QueryCustomName

SheetView.GetCustomNameEnumerator

ReCalc

SheetView.RecalculateAll

ReCalcCell

No equivalent; use the EvalulateExpression in the DefaultSheetDataModel Also see SheetView.Recalculate

Refresh

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

RemoveCellSpan

SheetView.RemoveSpanCell

RemoveCustomFunction

SheetView.RemoveCustomFunction

Reset

FpSpread.Reset

SheetView.Reset

ResetSheet

SheetView.Reset

RowHeightToTwips

No equivalent

in .NET; row heights are set and returned in pixels

SavePicture

No equivalent; use .NET methods

SavePictureBuffer

No equivalent; use .NET methods

SaveTabFile

SheetView.SaveTextFile SheetView.SaveTextFileRange

SaveTabFileU

No equivalent

SaveToFile

FpSpread.Save

ScriptCFGetCellParamExt

No equivalent

ScriptCFGetRangeParamExt

No equivalent

SearchCol

FpSpread.Search

SearchRow

FpSpread.Search

SetActionKey

InputMap.Put

InputMap.Remove

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

SetActiveCell

SheetView.SetActiveCell

SetArray

SheetView.SetArray

SetCalText

Sets the calendar text for all the Spread components in a project; no equivalent method in Spread.NET; can use the DateTimeCellType.SetCalendarText

SetCalTextOverride

DateTimeCellType.SetCalendarText

SetCellBorder

Cell.Border

Column.Border

Row.Border

SetCellDirtyFlag

No equivalent

SetColItemData

Column.Tag

SheetView.GetTag

SheetView.SetTag

SetCustomName

SheetView.AddCustomName

SetDataFillData

No equivalent

SetFloat

Cell.Value

SheetView.SetValue

SetFocus

FpSpread.Focus

System.Control.Focus

SetInteger

Cell.Value

SheetView.SetValue

SetItemData

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

SetIteration

SheetView.Iteration

SheetView.MaximumChange

SheetView.MaximumIterations

SetOddEvenRowColor

AlternatingRow.BackColor

AlternatingRow.ForeColor

SetRefStyle

SheetView.ReferenceStyle

Enumeration: Model.ReferenceStyle

SetRowItemData

Row.Tag

SheetView.GetTag

SheetView.SetTag

SetSelection

SheetView.AddSelection

SetText

Cell.Text

SheetView.SetText

SetTextTipAppearance

FpSpread.TextTipAppearance

ShowCell

FpSpread.ShowCell

Sort

SortInfo class

SheetView.SortColumns

SheetView.SortRange

SheetView.SortRows

SwapColRange

SwapRange

SwapRowRange

SheetView.SwapRange

TwipsToColWidth

No equivalent; in .NET column widths are set and returned in pixels

TwipsToRowHeight

No equivalent; in .NET row heights are set and returned in pixels

TypeComboBoxClear

ComboBoxCellType.Clear

TypeComboBoxRemoveItem

No equivalent; in .NET can cast ComboBoxCellType.Items to Ilist object and use RemoveAt method

VirtualRefresh

No equivalent

ZOrder

System.ControlCollection.SetChildIndex