How to get value in childview?

Posted by: l2ampag3 on 8 September 2017, 12:34 pm EST

  • Posted 8 September 2017, 12:34 pm EST

    I'm new for FarPoint Spread . Can you tell me how to get value and other properties in cell's childview?

  • Replied 8 September 2017, 12:34 pm EST

    One way is to use the ChildViewCreated event and from there you can use the e.Sheetview parameter to query all the values and properties of the child.

    Alternatively you can use the GetChildView method...

    Dim sv As FarPoint.Win.Spread.SheetView = FpSpread1.ActiveSheet.GetChildView(0, 0)
    MsgBox(sv.Cells(0, 0).Text)

    In the GetChildView method the first parameter is the parent row and the second is the relation index.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels