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 |
|
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 |
|
|
ExportRangeToTextFile |
SheetView.SaveTextFileRange |
|
ExportRangeToTextFileU |
No equivalent |
|
ExportRangeToXML ExportRangeToXMLBuffer |
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 |