Paste issues after upgrade from 4.0.3505.2008 to 4.0.3511.2008

Posted by: smokedironmade on 8 September 2017, 2:00 pm EST

  • Posted 8 September 2017, 2:00 pm EST

    Before upgrade I was able to paste excel selection to spread and it added the new rows as required, now I try to do the same and it is not working, is this a bug?

    The spread is binded to a dataview and I have the first three columns using custom celltype (TextCellType) just for validations.

    Update: Attached simple project to demonstrate the issue. It have only 5 rows if you try to paste more than 5 it will do nothing.

  • Replied 8 September 2017, 2:00 pm EST

    I have been simplying the test project and so far i cannot get this working, is this the default behaviour and what i was doing before was a bug? Someone has tried doing the same?


  • Replied 8 September 2017, 2:00 pm EST


    I was able to reproduce this issue and have reported this as a bug (#26916) for the development team to fix for the next maintenance release.

  • Replied 8 September 2017, 2:00 pm EST

    Thanks. Any ideas when a fix will be available?
  • Replied 8 September 2017, 2:00 pm EST

    The next maintenance release is scheduled for 3rd-4th week of September 2009.



  • Replied 8 September 2017, 2:00 pm EST

    I just tried the new version 4.0.3512.2008 that i would understand should get rid of the issue, but i do not see any difference. I tried with an unbound grid and pasting data greater than the row count is not adding new rows, is this only supposed to work for bound grids?

     <BLOCKQUOTE><div><FONT color=#666699 size=3>Versions 4.0.2012.2005 and 4.0.3512.2008
    Release Date 08/13/2009
    Technical Problems Fixed </FONT>

    <FONT color=#333300 size=2><B> fpSpread component</B></FONT>

    • Copying and pasting blocks of data greater than the column or row count now works correctly. [26916]


  • Replied 8 September 2017, 2:00 pm EST


    Adding of rows and columns is not the designed behavior of the Spread when pasting data. The bug before was that if the block of data in the paste block was larger than the number of cells from the active cell, then nothing was pasted. We fixed that to now paste to the limit of rows and columns.

  • Replied 8 September 2017, 2:00 pm EST

    Scott are you considering dynamically adding more rows to the grid as a feature of the component? Since, it was a feature as we have a component working that does it, and we rely on that feature (so we hope the component keeps working the way it used to work when we started).


  • Replied 8 September 2017, 2:00 pm EST


    We are not. We honor the settings made by the developer for RowCount and ColumnCount. If we changed these based on a paste, it is possible to break people's code. I would suggest catching the paste and providing your own code for doing the paste. You can get the data off the clipboard and determine the size of the block to see if you need to add columns or rows before pasting the data.

Need extra support?

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

Learn More

Forum Channels