Copy / Paste Issue - Html tags not removed when pasting the content that contains html tag from handsontable to Excel sheet

#1

Hello @aleksandra_budnik

Html tags not removed when pasting the content that contains html tag from handsontable to Excel sheet.
Recently, I have upgraded the angular version and handsontable version from 6.x to 12.x. I am facing this issue in this latest version (12.x) but it was working in older version (6.x) handsontable.

Please refer the screenshot below:

Handsontable : Rendered dynamic content from server side.

image

Excel sheet : after paste in to excel sheet
image

My Expected Output should be :
image

Html tag should be removed automatically before paste the content to excel sheet.

Current Version :
Angular - 12.2.17
Handsontable - 12.1.2

Please respond as soon as possible.

#2

Hi @sudarmani2495

Do you define your dataset with <br>'s and use an html renderer?

59

If so, the versions 6.x and 12.x work the same.

  1. Handsontable v12 https://jsfiddle.net/2v75bwhr/3/
  2. Handsontable v6 https://jsfiddle.net/2v75bwhr/2/

so I assume that you have different settings. Can you share your configuration object?

#3

image
image.png790×211 8.54 KB

#4

image

After copy/paste [ctrl + c & ctrl + v ] to excel sheets the html tags should be removed.

#5

As you did not share the code I assume that you have those tags directly in your dataset, right? If so it should be your action to add a custom logic (perfectly in the beforeCopy() or afterCopy()) that removes the tags. But this behavior does not change. It worked the same in v6 as it works in v12. Do I miss anything? A code sample would help much.

#6

image
image.png905×279 11 KB

I have added custom logics to replace “br” tag instead of semicolon “;” before rendering the cell data to handsontable.

#7

image
image.png891×84 3.79 KB

#8

OK, so at the initialization of the Handsontable Component we get the data with <be> tag in the cell. So, the following tip with the

add a custom logic (perfectly in the beforeCopy() or afterCopy() ) that removes the tags

is still valid. Did you already had time to test it?

#9

any updates here, @sudarmani2495?

#10

Yes, I used afterCopy() custom logic to remove html tags after that I have updated the data in to clipboard. now working fine… but, I want to know why it is not working without custom logic and earlier it was working without custom logic.

I have verified these both but functionality not working what I expected.

[Version 12] (https://jsfiddle.net/2v75bwhr/3/)
[Version 6] (https://jsfiddle.net/2v75bwhr/2/)

Please respond as soon as possible.

#11

Both of those demos work the same for me, @sudarmani2495, and I do not see any changes in the changelog that indicate that this behavior was changed.

#12

Hi @sudarmani2495

As we do not have any updates for more than 2 weeks I need to close this thread. However, if you still experience the same effects please share more details last support@handsontable.com.

#13