Cut a cells content (ctrl-x) not working.

Posted by: kunal-mi-17 on 8 September 2017, 12:33 pm EST

  • Posted 8 September 2017, 12:33 pm EST

    <FONT face=Arial size=2>Hi,</FONT>


    <FONT face=Arial size=2>I am using farpoint spread for win Forms 2.5v, In my application the ctrl-x is somehow is not working. As far as my understanding goes this is a default property of spread.</FONT>


    <FONT face=Arial size=2>I have also put this code in the form - load event</FONT>

    <FONT color=#0000ff>

    <FONT face=Arial size=2>Dim</FONT></FONT><FONT face=Arial size=2> im <FONT color=#0000ff>As</FONT> FarPoint.Win.Spread.InputMap</FONT>


    <FONT face=Arial size=2>im = <FONT color=#0000ff>Me</FONT>.sprBalSheet.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenFocused)</FONT>


    <FONT face=Arial size=2>im.Put(<FONT color=#0000ff>New</FONT> FarPoint.Win.Spread.Keystroke(Keys.X,<FONT color=#ff0000> Keys.Control Or Keys.Shift</FONT>), FarPoint.Win.Spread.SpreadActions.ClipboardCutDataOnly)</FONT>


    <FONT face=Arial size=2>but this is not working.I got the idea to use " <FONT color=#ff0000>Keys.Control Or Keys.Shift</FONT>" from the link provided below</FONT>

    <FONT size=2><U><FONT face=Arial color=#0000ff size=2>

    http://www.clubfarpoint.com/Forums/forums/thread/15352.aspx</U></FONT><FONT face="Tms Rmn"><FONT size=3> </FONT></FONT>


    <FONT face="Tms Rmn"><FONT face=Arial>previously i was using only "<FONT color=#ff0000><FONT color=#000000>Keys.Control" even then also ctrl- x was not working for my spread.</FONT></FONT></FONT></FONT>


    <FONT face="Tms Rmn"><FONT face=Arial>When i create a test application, ctrl - x is working fine there. but not for my application</FONT></FONT>


    <FONT face="Tms Rmn"><FONT face=Arial>please suggest </FONT></FONT>


    <FONT face="Tms Rmn"><FONT face=Arial> ~ Kunal </FONT>

    </FONT></FONT>
  • Replied 8 September 2017, 12:33 pm EST

    Hello,

    Does the Spread you're using have locked cells? Ctrl + x doesn't work on locked cells. On a locked cell, you can copy, but you can't cut or paste.

    If no, is it possible that you could attach your project or send it to me by email? You can email us at fpsupport@fpoint.com

    Thanks


  • Replied 8 September 2017, 12:33 pm EST

    Hello,

    Have you tried setting the AutoClipboard property to true?


    fpSpread1.AutoClipboard = <font class="keyword">True</font>

  • Replied 8 September 2017, 12:33 pm EST

    <FONT face=Arial size=2>Hi,</FONT>


    <FONT face=Arial size=2>Yes that property is also set to true during design time and it is not getting changed at runtime as well.</FONT>

  • Replied 8 September 2017, 12:33 pm EST

    <FONT face=Arial size=2>Hi,</FONT>


    <FONT face=Arial size=2>In my spread there are however a couple of locked cells but the operation (ctrl-x ) that i am performing is on a cell that is not locked.</FONT>


    <FONT face=Arial size=2>As far as sending the application code is concerned, i am afraind i would not be able to do so as per my companies policies.</FONT>


    <FONT face=Arial size=2>could you help me out without me sending you the code, is there any other way out that we sort out this issue?</FONT>


    <FONT face=Arial size=2>~Kunal</FONT>

  • Replied 8 September 2017, 12:33 pm EST

    <FONT face=Arial size=2>Hi,</FONT>


    <FONT face=Arial size=2>One more thing that i observed just now was that if i put the above written code in my form load event , ctrl-x doesn't work but if i press ctrl-shift -x, it works. </FONT>


    <FONT face=Arial size=2>~Kunal</FONT>

  • Replied 8 September 2017, 12:33 pm EST

    <FONT face=Arial size=2>Hi,</FONT>


    <FONT face=Arial size=2>but ideally ctrl-x should work in the similar fashion as ctrl-shift -x. please suggest</FONT>


    <FONT face=Arial size=2>~Kunal</FONT>

  • Replied 8 September 2017, 12:33 pm EST

    Hello,

    The behavior you are describing would suggest the inputmapping is handled incorrectly. I would suggest taking a closer look at your code to ensure that you aren't overwriting your input map declarations and that everything is done correctly.

    If nessecary, we can sign a non disclosure agreement if you want to send us your code.
Need extra support?

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

Learn More

Forum Channels