Copy mulitple rows from excel and paste to a merged cell in fpSpread

Copy mulitple rows from excel and paste to a merged cell in fpSpread

Posted by: ankita.mahendru on 30 May 2018, 6:04 am EST

• 

  ankita.mahendru

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 30 May 2018, 6:04 am EST

  Hi,

  When I am trying to Copy mulitple rows from excel sheet and then try to paste it to a merged cell in fpSpread, I can see some weird behaviour. The first row element copied, gets pasted properly but the rest of the rows are not properly pasted. The merged cell that I have is having rich text format cell.
  
  Say, I have copied 10 rows from MS Excel and 4 rows in the merged cell. Therefore, first row gets pasted on the first row. Rest three rows are empty and then from the 5th row the data is getting pasted till the 10th row.
  
  Please refer the attached screenshots as well.

  Thanks,
  
  Ankita

• 

  ankita.mahendru

  • Post Options:
  • Link
    Copy

  Posted 30 May 2018, 8:13 am EST - Updated 30 September 2022, 2:16 pm EST

  

  481×622 5.61 KB

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 5 June 2018, 3:31 am EST

  Hello,

  It seems to be a bug. Hence, we are escalating the same to the concerned team for the fix.

  We will update you as soon as we hear anything from our concerned team.
  
  Tracking id for your issue is #259168

  Thanks,
  
  Reeva

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 5 June 2018, 7:12 am EST

  Hello,

  Our developers have confirmed that this is a design behavior as of now and we don’t have any way to bypass it.

  Hence, if you want same behavior like Excel then we’ll need a new action for clipboard paste (and/or copy) for it and we have to put forward an enhancement request for the same.

  Thanks,
  
  Reeva