New rows are not getting created dynamically

Posted by: shajiya.a on 15 September 2020, 3:32 am EST

  • Posted 15 September 2020, 3:32 am EST

    New rows are not getting created dynamically (When i append multiple rows at the end of the editor, it is not creating the new rows)

    Detailed Scenario:

    Step 1:
    After Copying data from excel sheet tried to paste it in row no 6 of Flexsheet. However, no new rows were created dynamically. Only data in row 6 and 7 were replaced with top 2 rows of copied data from excel.

    FlexGrid Control: (refer 1st pic)
    Excel data below: (refer 2nd pic)

    Step 2:
    Screenshot after pasting data in Flexgrid. (refer 3rd pic)

    Note: For data binding m using collection view.
  • Replied 15 September 2020, 3:33 am EST

  • Replied 15 September 2020, 3:33 am EST

  • Replied 15 September 2020, 3:33 am EST

  • Replied 15 September 2020, 11:06 pm EST

    Hi Shajiya,

    We have asked the developers on whether this is a bug or expected behavior. The internal tracking id of the case is 462559. We will update you once we will hear from them.

    Regards,
    Ashwin
  • Marked as Answer

    Replied 27 October 2020, 12:50 am EST

    Hi Shajiya,

    The developers have said that this is expected behavior. As a workaround, you can handle the pasting event of the FlexSheet and add new rows according to the data being pasted.
    flexSheet.pasting.addHandler((s, e) => {
    let clipRows = e.data.split('\n');
    let sel = s.selection;
    let top = sel.topRow;
    let bot = top + clipRows.length - 1;

    while (bot > s.rows.length) {
    s.rows.push(new wijmo.grid.Row());
    }
    })

    ~regards
  • Replied 27 October 2020, 12:55 pm EST

    Thank you ashwin
Need extra support?

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

Learn More

Forum Channels