Spread Windows Forms 8.0 Product Documentation
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

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options | Documentation Feedback