duplicating a column

Posted by: rizwankhan on 8 September 2017, 2:25 pm EST

  • Posted 8 September 2017, 2:25 pm EST

    Hi,


    What is the best way to copy one column (along with headers,formatting, data) to a new column in same sheet? I am using spread 5.


    Please provide an example.


    Thanks

  • Replied 8 September 2017, 2:25 pm EST

    <FONT size=2 face=Consolas><FONT size=2 face=Consolas>

    There is a Copy Method listed in the product documentation


    c#



    <TABLE class=syntaxtable cellSpacing=0 cellPadding=0>

    <TR>
    <TH></TH>
    <TH> </TH></TR>
    <TR>
    <TD colSpan=2>

    virtual void Copy( 
       int <I>fromRow</I>,
       int <I>fromColumn</I>,
       int <I>toRow</I>,
       int <I>toColumn</I>,
       int <I>rowCount</I>,
       int <I>columnCount</I>
    )
    </TD></TR></TABLE>


    </FONT></FONT>or


    vb

    Overridable Sub Copy( _
       ByVal <I>fromRow</I> As Integer, _
       ByVal <I>fromColumn</I> As Integer, _
       ByVal <I>toRow</I> As Integer, _
       ByVal <I>toColumn</I> As Integer, _
       ByVal <I>rowCount</I> As Integer, _
       ByVal <I>columnCount</I> As Integer _
    )
Need extra support?

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

Learn More

Forum Channels