how can I get Action event of vb6 in vb.net

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>

    Hi,


    We are migrating VB6 spread to VB.Net spread4.0 (Win Forms).Can Anybody please help me migrating following vb6 code to VB.net 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


                
    Sunil

    </DIV>
  • Replied 8 September 2017, 2:03 pm EST

    Sunil,


    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


     Thanks,


    ~Jacob

  • Replied 8 September 2017, 2:03 pm EST

    Thank you Jacob


    Sunil

Need extra support?

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

Learn More

Forum Channels