seleccionar una fila

Posted by: luis-cifuentes on 8 September 2017, 3:02 pm EST

  • Posted 8 September 2017, 3:02 pm EST

    '-------------------------------------------------------------------------------------------------------

    hola amigos consulta como puedo seleccionar una fila en fspread??

    deseo capturar un dato y copiarlo a un textbox.text vb.net 2008

    '---------------------------------------------------------------------------------------------------------------

    <span id="result_box" class=""><span class="hps">hello</span> <span class="hps">friends</span> <span class="hps">I can</span> <span class="hps">query like</span> <span class="hps">select a row</span> <span class="hps">in</span> <span class="hps">fspread</span><span>?</span><span>?</span>
    <span class="hps">desire to</span> <span class="hps">capture</span> <span class="hps">data</span> <span class="hps">and</span> <span class="hps">copy it to a</span> <span class="hps">TextBox.Text</span> <span class="hps">vb.net</span> <span class="hps">2008</span></span>

  • Replied 8 September 2017, 3:02 pm EST

    thank you

     <span id="result_box" class=""><span class="hps">that's what I</span> <span class="hps">wanted</span><span>,</span> <span class="hps">but</span> <span class="hps">select only</span> <span class="hps">the data</span> <span class="hps">in column 1</span><span>.</span>
    example</span>

    <span id="result_box" class="">
    <span class="hps">to</span> <span class="hps">select</span> <span class="hps">column 4</span> <span class="hps">texbox</span> <span class="hps">I</span> <span class="hps">copy</span> <span class="hps">to</span> <span class="hps">R4C1</span> <span class="hps">and nothing else</span></span>

  • Replied 8 September 2017, 3:02 pm EST

    Hello,

    It can be accomplished in the same way, all you need to do is modify the code in SelectionChanged event so that it does not checks for any condition, rather it simply puts the text of the selected cell or cell range in the textbox, please have a look at the attached modified sample. Hope it will help you. Please let me know if you have any queries further.

    Thanks,

    Manpreet Kaur


    2012/11/RowText (2).zip
  • Replied 8 September 2017, 3:02 pm EST

    <span><span><span><span>Thanks</span><span>,</span> <span>but</span> <span>as</span> <span>I delete</span> <span>the spaces</span> <span>after</span> <span>R4C1</span><span>.</span>

    <span>attached</span> <span>image</span></span></span></span>

     

    <span><span><span><span><img src="http://i.imgur.com/OdPun.jpg" title="images" alt="images" align="top" height="296" width="288"></span></span></span></span>

  • Replied 8 September 2017, 3:02 pm EST

    Hello,

    Please have a look at the attached sample that fulfills your requirement i.e as soon as you click on the row header to select a row, it copies the data in the row to the textbox. Hope it will help you. Please let me know if you have any queries further.

    Thanks,

    Manpreet Kaur


    2012/11/RowText.zip
  • Replied 8 September 2017, 3:02 pm EST

    Hello,

    I am not able to replicate the issue at my end, as no spaces are getting copied to the textbox, as soon as I click on the textbox the editing cursor blinks exactly after 1 in the text R4C1, attached is the screenshot that depicts the same. Could you please let me know if I am missing something that would help me to replicate the issue at my end.

    Thanks,

    Manpreet Kaur



  • Replied 8 September 2017, 3:02 pm EST

    <span id="result_box" class=""><span class="hps">hello</span> <span class="hps">Manpreet</span> <span class="hps">Kaur</span> <span class="hps">probe</span> <span class="hps">with</span> <span class="hps">these</span> <span class="hps">symbols</span> <span class="hps">that</span> <span class="hps">I get</span> <span class="hps">after</span> <span class="hps">RC41</span> <span class="hps">also</span> <span class="hps">serves</span> <span class="hps">me</span> <span class="hps">well</span> <span class="hps">I appreciate your</span> <span class="hps">help thanks</span> <span class="hps">...</span></span>

     

    <img src="/emoticons/emotion-21.gif" alt="Yes" /> <img src="/emoticons/emotion-21.gif" alt="Yes" /><img src="/emoticons/emotion-21.gif" alt="Yes" /><img src="/emoticons/emotion-21.gif" alt="Yes" />

Need extra support?

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

Learn More

Forum Channels