excel复制公式粘贴在spread上，公式数据会丢失

Lynn.Dou

excel设置显示公式点击带有公式的那一个单元格 ctrl+c 来到我们的spread上 ctrl+v 如图公式数据缺失了图右侧是正常的他也是ctrl+v复制过来的要是js的问题那么左右应该是一致的啊我们的线上excel也有这个问题

Lynn.Dou · Lynn.Dou

您好，
SpreadJS支持从Excel复制样式然后粘贴到Spread Sheets，默认设置 allowCopyPasteExcelStyle 为true。
通过设置 allowCopyPasteExcelStyle 为false，可以解决您所说的问题。

更多内容推荐阅读学习指南：
https://demo.grapecity.com.cn/sp ... -excel-style/purejs

Fiooona · Fiooona

把这个公式的文字版帮忙发一下把~ 不然不好复现这个问题

littleknife · littleknife

=acct("100","100001","600102|001|3001300","DF",0,0,"")+acct("300","100001","600102|001|3001300","DF",0,0,"")+acct("111","100001","600102|001|3001300","DF",0,0,"")+acct("113","100001","600102|001|3001300","DF",0,0,"")+acct("202","100001","600102|001|3001300","DF",0,0,"")+acct("210","100001","600102|001|3001300","DF",0,0,"")+acct("212","100001","600102|001|3001300","DF",0,0,"")+acct("230","100001","600102|001|3001300","DF",0,0,"")+acct("211","100001","600102|001|3001300","DF",0,0,"")+acct("299","100001","600102|001|3001300","DF",0,0,"")+acct("401","100001","600102|001|3001300","DF",0,0,"")+acct("406","100001","600102|001|3001300","DF",0,0,"") 把他粘贴到excel里再点击单元格复制并粘贴到我们的spread里面

		自动登录	找回密码
密码			立即注册

[已处理] excel复制公式粘贴在spread上，公式数据会丢失

最佳答案

3 个回复

SpreadJS 认证

SpreadJS 高级认证

讲师达人

悬赏达人

微信认证勋章