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


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


    <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

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


    <div class="LanguageSpecific" id="Example_VB"><b><font size="2"><code class="VB"><font class="keyword">Dim</font> dataModel <font class="keyword">As</font> <font class="keyword">New</font>
    FarPoint.Win.Spread.Model.DefaultSheetDataModel(5,
    5)
    </code><code class="VB">dataModel = </code><code class="VB">FpSpread1.ActiveSheet.Models.Data
    dataModel.ClearData(x,x,x,x)</code></font></b></div>$$Example$$</h4>

    %%filtereditemlist%%

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

    %%comment%%

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

    %%filtereditemlist%%

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

    Hi,


    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,


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

    <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

    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