WinForms

Upgrade Guide User Guide Demos Support Forums Download
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Interface ICalcData - WindowsForms API Reference | Syncfusion

    Show / Hide Table of Contents

    Interface ICalcData

    ICalcData defines the minimal interface that a data object must support in order to use this formula engine.

    Namespace: Syncfusion.Windows.Forms.CellGrid
    Assembly: Syncfusion.Spreadsheet.Windows.dll
    Syntax
    public interface ICalcData

    Properties

    ColumnCount

    Gets/Sets Column count of the Grid.

    Declaration
    int ColumnCount { get; set; }
    Property Value
    Type Description
    System.Int32

    RowCount

    Gets/Sets the Row count of the Grid.

    Declaration
    int RowCount { get; set; }
    Property Value
    Type Description
    System.Int32

    Methods

    GetDependentCellValue(Int32, Int32)

    Gets the dependent cell value of the specified cell.

    Declaration
    string GetDependentCellValue(int rowIndex, int colIndex)
    Parameters
    Type Name Description
    System.Int32 rowIndex

    Row index of the cell

    System.Int32 colIndex

    Column index of the cell

    Returns
    Type Description
    System.String

    retuns the value of the specified cell

    GetValueRowCol(Int32, Int32)

    A method that gets the data value from the specified row and column.

    Declaration
    object GetValueRowCol(int row, int col)
    Parameters
    Type Name Description
    System.Int32 row

    1-based index specifying the row index of the requested value.

    System.Int32 col

    1-based index specifying the column index of the requested data.

    Returns
    Type Description
    System.Object

    The data value at the given row and column index.

    RecalculateCell(Int32, Int32, Boolean)

    Declaration
    void RecalculateCell(int row, int col, bool invaladateCell)
    Parameters
    Type Name Description
    System.Int32 row
    System.Int32 col
    System.Boolean invaladateCell

    SetValueRowCol(Object, Int32, Int32)

    A method that sets the data value to the specified row and column.

    Declaration
    void SetValueRowCol(object value, int row, int col)
    Parameters
    Type Name Description
    System.Object value

    The value.

    System.Int32 row

    One-based index specifying the row index of the value.

    System.Int32 col

    One-based index specifying the column index of the value.

    WireParentObject()

    A method that wires the ParentObject after the CalcEngine object is created or when a RegisterGridAsSheet call is made.

    Declaration
    void WireParentObject()
    Remarks

    This method is a callback to the ParentObject so it can have a chance to subscribe to any change events it may need to implement ValueChanged properly.

    Events

    ValueChanged

    Event for value changed

    Declaration
    event ValueChangedEventHandler ValueChanged
    Event Type
    Type Description
    ValueChangedEventHandler
    Back to top Generated by DocFX
    Copyright © 2001 - 2022 Syncfusion Inc. All Rights Reserved