Alternate method for Clip() using spread 2.5

Posted by: sureshhcl on 8 September 2017, 1:02 pm EST

  • Posted 8 September 2017, 1:02 pm EST

    Hi,


    I am working in VB.NET windows application  using spread 2.5.Our prevcius code was used in spread 3.0 now we are migrating this application for spread 2.5 while migrating the application we are facing some issues for .Clip() in spread 2.5


    With SprResult.ActiveSheet
                dim sFirstRec  as string



                .Col = 1
                .Col2 = .MaxCols
                .Row = 1
                .Row2 = 1
                sFirstRec = .Clip


    End with


    I know we can use .SetClip() method instead of using .Clip() but the last parameter for SetClip needs the value.In the above code I am not having the value to be passed for the parameter for SetClip() method finally I want to assign this value to a string variable "sFirstRec ".


    Please help me to get a solution for this problem.


    Thanks & regards,


    Balaji.T

  • Replied 8 September 2017, 1:02 pm EST

    Have you tried using GetClip instead?
Need extra support?

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

Learn More

Forum Channels