using SS_ACTION_CLEAR_TEXT in 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 using spread 2.5 in VB.NET win apps. Previously we used spread 3.0 now we are migrating the same from spread 3.0 to 2.5.So  the folllowing line shows an error


    For i = 0 To Val(DB_CNT.Value)


                     spdList.row = i


                   'spdList.col = -1


                    spdList.ActiveSheet.ActiveColumnIndex = -2


                 spdList.Action = SS_ACTION_CLEAR_TEXT


    Next


    Please help me to solve SS_ACTION_CLEAR_TEXT.


    Thanks & regards,


    Balaji.T

  • Replied 8 September 2017, 1:02 pm EST

    Balaji,


    The ClearText acton from Spread 3 has been replaced by the ClearRange method in the SheetView object.

  • Replied 8 September 2017, 1:02 pm EST

    You can use the ClearData method...


    Dim dataModel As New
    FarPoint.Win.Spread.Model.DefaultSheetDataModel(5,
    5)
    dataModel = FpSpread1.ActiveSheet.Models.Data
    dataModel.ClearData(x,x,x,x)
    $$Example$$

    %%filtereditemlist%%

    " -->$$Requirements$$

    %%comment%%

    " blankformat="%%variable:name=defaultmemberrequirements%%" -->$$See_Also$$%%designlist:tagidentifier=##SEEALSO,itemtype=See Also%%

    %%filtereditemlist%%

    " -->
  • Replied 8 September 2017, 1:02 pm EST

    Hi,


    Please let me know what is mean by (5,5) under


    Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5)


    so that I can use the same in my code.


     


    Thanks & regards,


    Balaji.T 

  • Replied 8 September 2017, 1:02 pm EST

    Balaji -

    It is the number of rows and columns in the model.  You do not need to use that in the constructor.  You can just use...

    Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel()
  • Replied 8 September 2017, 1:02 pm EST

    Hi,


    Thanks a lot for your reply and solution given to us.


    Thanks & regards,


    Balaji.T

Need extra support?

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

Learn More

Forum Channels