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


    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

    <FONT color=#0000ff>For i = 0 To Val(DB_CNT.Value)</FONT>

    <FONT color=#0000ff>                 spdList.row = i</FONT>

    <FONT color=#0000ff>               'spdList.col = -1</FONT>

    <FONT color=#0000ff>                spdList.ActiveSheet.ActiveColumnIndex = -2

    <FONT color=#0000ff>             </FONT><FONT color=#ff0000>spdList.Action = SS_ACTION_CLEAR_TEXT</FONT>

    <FONT color=#0000ff>Next </FONT>

    <FONT color=#000000>Please help me to solve SS_ACTION_CLEAR_TEXT.</FONT>

    <FONT color=#000000>Thanks & regards,</FONT>

    <FONT color=#000000>Balaji.T</FONT>

  • Replied 8 September 2017, 1:02 pm EST


    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...

    <div class="LanguageSpecific" id="Example_VB"><b><font size="2"><font class="keyword">Dim</font> dataModel <font class="keyword">As</font> <font class="keyword">New</font>
    dataModel = FpSpread1.ActiveSheet.Models.Data


    " -->$$Requirements$$</h4>


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


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


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

    <FONT face="Courier New" size=2>Dim dataModel <FONT class=keyword>As</FONT> <FONT class=keyword>New</FONT> FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5)</FONT>

    so that I can use the same in my code.


    Thanks & regards,


  • 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...

    <font face="Courier New" size="2">Dim dataModel <font class="keyword">As</font> <font class="keyword">New</font> FarPoint.Win.Spread.Model.DefaultSheetDataModel()</font>
  • Replied 8 September 2017, 1:02 pm EST


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

    Thanks & regards,


Need extra support?

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

Learn More

Forum Channels