Inserting mutiple rows and merging the cells

2 posts, 0 answers
  1. Nick
    Nick avatar
    3 posts
    Member since:
    Jan 2015

    Posted 29 Aug Link to this post

    I am attempting to insert rows between existing rows within a worksheet. Each newly inserted row should have the cells within merged and have a text value.

    I am basically calling the following in a loop on a very small spreadsheet (only 12 rows and 4 columns) and it is very slow. The spreadsheet originates from a call to grid.ExportToWorkbook().

     

     

    worksheet.Rows.Insert(rowIndex, 1);

    worksheet.Cells[rowIndex, 0].SetValueAsText("haha");

    worksheet.Cells[new CellIndex(rowIndex, 0), new CellIndex(rowIndex, 3)].Merge();

     

    Two issues:

    Issue 1: This is very slow. Each call to insert takes a long time to execute. The entire operation takes several seconds despite only inserting 12 rows. I have suspended layout, put everything in a single undo group. The control isn't even visible at this point.

     

    Issue 2: The cells do not seem to be merging correctly. Some of the values of non inserted rows are removed. If I comment out the call to merge, all values appear to be correct

     

    Thanks in advance.

     

  2. Tanya
    Admin
    Tanya avatar
    577 posts

    Posted 01 Sep Link to this post

    Hi Nick,

    I agree with you that the performance of the insertion of rows should be improved. We have already logged an internal task to improve the performance of the control. I added your request to this task and created a public item. You can vote for this implementation and subscribe to track its status using the item: Improve RadSpreadsheet performance. I am afraid I couldn't find an approach to suggest you for improving the current behavior. 

    In regards to the merged cells, I couldn't find an issue with this functionality. Can you please send us more details about the scenario? Can you reproduce the issue with any document? Could it be related to a specific one? If so, can you share a sample document which we can use for testing?

    I am looking forward to hearing from you.

    Regards,
    Tanya
    Progress Telerik
    Want to extend the target reach of your WPF applications, leveraging iOS, Android, and UWP? Try UI for Xamarin, a suite of polished and feature-rich components for the Xamarin framework, which allow you to write beautiful native mobile apps using a single shared C# codebase.
Back to Top