ClipboardCopy coping only 500 rows

Posted by: kiran-fp on 8 September 2017, 1:42 pm EST

  • Posted 8 September 2017, 1:42 pm EST

    Dear Friend,

         I am using FpSpread control in my project.I need to export spread data which is more than 65550 rows to xls file type of file.If i want to export in xlsx type file i can use fpSpread's SaveExcel method and export without any problem.So i tried to split the data into different sheets by using ClipboardCopy and ClipboardPaste.

    ClipboardCopy copying only 500 row .

    Is it Clipboard buffer problem? where to change?




  • Replied 8 September 2017, 1:42 pm EST


    If you are using VirtualMode in the Spread, then only the rows in the Spread buffer will be copied. If VirtualRows is set to 500, this would explain what you are seeing.

  • Replied 8 September 2017, 1:42 pm EST

    Dear Mr.Scott S.

     Thanks for your reply,I saw your previous post.I am not using Com version, so i don't have VirtualMode.

     Can you please suggest me any other method,so that i can able to copy 65000 rows and paste with cell format.



    Kiran S

  • Replied 8 September 2017, 1:42 pm EST


    Since it sounds like you are using Spread for Windows Forms, I have moved this thread to the appropriate area of the forums. The code you pointed to me is a way to load data into the Spread for Windows Forms control in a mock virtual mode. This code will not load data into the Spread until you scroll to that area of the Spread. You would have the same problem copying data to the clipboard if that particular data has not been loaded into the Spread yet. Could you post a small zipped project reproducing the issue you are seeing for us to debug?

  • Replied 8 September 2017, 1:42 pm EST


    In the code you sent, you are creating a new SheetView object to paste into.

    SheetView sh = new SheetView();

    This creates a SheetView with a RowCount and ColumnCount equal to 500. You need to change the ColumnCount and RowCount properties of the new SheetView before pasting.

  • Replied 8 September 2017, 1:42 pm EST

    Dear Scott

     Thank you.It is working now.


    Kirankumar  S

Need extra support?

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

Learn More

Forum Channels