【v16】调用cmd：“paste”粘贴与快捷键粘贴表现形式不一致

trace

本帖最后由 spreadjs666 于 2024-3-25 17:59 编辑

【v16】调用cmd：“paste”粘贴与快捷键粘贴表现形式不一致
使用cmd: paste进行粘贴，表现如下，分成了三个单元格展示
image.png496842650.png

而使用快捷键粘贴，直接被识别成了一个单元格
image.png782531127.png

源数据参考附件

this.spread.commandManager().execute({cmd: "paste", sheetName: "Sheet1", pasteHtml: <span class="message-body-wrapper"><span class="object-delimiter"></span><span class="objectBox objectBox-string">`<html xmlns:v="urn:schemas-microsoft-com:vml"\nxmlns:o="urn:schemas-microsoft-com:office:office"\nxmlns:x="urn:schemas-microsoft-com:office:excel"\nxmlns="<a class="url" title="http://www.w3.org/TR/REC-html40" draggable="false" href="http://www.w3.org/TR/REC-html40" target="_blank" rel="noopener noreferrer" tabindex="-1">http://www.w3.org/TR/REC-html40</a>">\n\n<head>\n<meta http-equiv=Content-Type content="text/html; charset=utf-8">\n<meta name=ProgId content=Excel.Sheet>\n<meta name=Generator content="Microsoft Excel 15">\n<link id=Main-File rel=Main-File\nhref="file:////Users/a58/Library/Group%20Containers/UBF8T346G9.Office/TemporaryItems/msohtmlclip/clip.htm">\n<link rel=File-List\nhref="file:////Users/a58/Library/Group%20Containers/UBF8T346G9.Office/TemporaryItems/msohtmlclip/clip_filelist.xml">\n<style>\n\n</style>\n</head>\n\n<body link="#0563C1" vlink="#954F72">\n\n<table border=0 cellpadding=0 cellspacing=0 width=87 style='border-collapse:\n collapse;width:65pt'>\n <col width=87 style='width:65pt'>\n <tr height=136 style='height:102.0pt'>\n\n <td height=136 class=xl65 width=87 style='height:102.0pt;width:65pt'>1、fdsfasf<br>\n 2、范德萨发撒发<br>\n 3、放大范德萨发大水发</td>\n\n </tr>\n</table>\n\n</body>\n\n</html>\n`</span></span>, pasteText: '"1、fdsfasf\n2、范德萨发撒发\n3、放大范德萨发大水发"'});

复制代码