Spread COM Method Equivalents in .NET

The following table lists the Spread COM methods and their Spread.NET member equivalents. It also lists the Spread.NET enumerations that go with these methods. Unless otherwise noted, the equivalent member in .NET is a method.

Spread COM Method	Spread.NET Member
AboutBox	FpSpread.About property
AddCellSpan	SheetView.AddSpanCell
AddCustomFunction	SheetView.AddCustomFunction
AddCustomFunctionExt	SheetView.AddCustomFunction
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
GetCustomFunction	SheetView.GetCustomFunction
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