how can I get Action event of vb6 in

Posted by: sunilsaini-s on 8 September 2017, 2:03 pm EST

  • Posted 8 September 2017, 2:03 pm EST

    <DIV class=ForumPostContentText id=_ctl0__ctl1_bcr__ctl0___PostRepeater__ctl1_PostViewWrapper>


    We are migrating VB6 spread to VB.Net spread4.0 (Win Forms).Can Anybody please help me migrating following vb6 code to code.

    please provide solution for spread SprResults related issues...

        sprResults.ReDraw = False
        sprResults.MaxRows = 10
        sprResults.Col = 1
        sprResults.Col2 = sprResults.MaxCols
        sprResults.Row = 0
        sprResults.Row2 = sprResults.MaxRows
        sprResults.Action = 3
        lblTotalRecords.Caption = TOTAL_RECORD & 0

        sprResults.Col = ln_Columns
        sprResults.ColHidden = True


  • Replied 8 September 2017, 2:03 pm EST


    To set the maximum rows and cols of a sheet you can use FpSpread.ActiveSheet.RowCount and FpSpread.ActiveSheet.ColumnCount properties respectively.

    To clear the content of cell range you can use the FpSpread.ActiveSheet.ClearRange(int row1, int col1, int row2, int col2, bool dataonly) method.

    To hide the current column you can using the below mentioned two properties:

    FpSpread.ActiveSheet.ActiveColumnIndex = ln_Columns

    FpSpread.ActiveSheet.ActiveColumn.Visible = False



  • Replied 8 September 2017, 2:03 pm EST

    Thank you Jacob


Need extra support?

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

Learn More

Forum Channels