New rows are not getting created dynamically

New rows are not getting created dynamically

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

• 

  shajiya.a

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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.

• 

  shajiya.a

  • Post Options:
  • Link
    Copy

  Posted 15 September 2020, 3:33 am EST - Updated 3 October 2022, 6:20 am EST

  

  1287×608 31.3 KB

• 

  shajiya.a

  • Post Options:
  • Link
    Copy

  Posted 15 September 2020, 3:33 am EST - Updated 3 October 2022, 6:20 am EST

  

  856×321 7.39 KB

• 

  shajiya.a

  • Post Options:
  • Link
    Copy

  Posted 15 September 2020, 3:33 am EST - Updated 3 October 2022, 6:20 am EST

  

  1287×596 31 KB

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  shajiya.a

  • Post Options:
  • Link
    Copy

  Posted 27 October 2020, 12:55 pm EST

  Thank you ashwin