[{"id":"b66f8b1e-cc14-4e89-9679-abd5687d283d","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"569bb90a-ea68-46c6-96f1-ab151c120714","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"5eb52f08-2d1a-4362-9ffc-4871bdc10f3f","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"341dd607-b97d-4d70-bde2-53acda6b6c95","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"05349273-414f-4208-9ea2-c4fc8f4ea2cb","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"86089f76-b778-4d52-821e-6f27de3df613","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"b81e4fd6-1fc5-43a0-a258-b6e16a5cbec6","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"8aa8ce31-43e4-438e-951f-241608435260","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"37343f41-6ec2-4c7e-b21d-2cc18d5ce1e0","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"5915e52f-64f8-4146-b8bd-81bead6324a3","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"836ba889-af9e-460d-a4cc-c24d922795f2","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"4ae14b06-bb68-4394-a210-a46b8f028346","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"d8f42066-e9dc-4411-bdcf-43b1a203370c","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"7ef86f16-b1a0-49f7-9592-612b9be02b25","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"b29c7775-a9a4-451e-a1b5-01d19ed5ca5e","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"e56f3989-8f81-46af-90fa-a4813eeb976f","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"2526c963-f170-45a8-923e-91b0712a9810","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"24575cf0-501a-44f9-8426-c40f8f4b5552","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"1a6f8d7f-acd6-42be-8c4f-f464c6218381","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"82b176fd-5cab-498c-909e-8fa7d29c38d8","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"1708b3a9-4f37-44a8-8f0e-f9a2d2e5d940","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"c9ac246e-29fb-4bc4-8231-8439795bb590","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"94f2a5c3-2539-436a-af75-23fbbd1a3957","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"d99594f4-2d40-4df4-9419-ba2ca6aa3f7f","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"fd66e72d-0f10-4f57-9807-6db26290ab2e","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"8f344863-503d-4bc3-a594-3815e7d55f5c","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"9be82601-de9d-4c18-948a-23ab6f4dd431","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"6495f3c0-b463-47e0-b08a-ca949672211e","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"b4bede08-3f08-4839-ba4a-abc7ac195bde","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"4afcdfc0-3ff5-4f2b-a223-f8fc042a5bbe","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"422062c4-fa40-4771-a86f-008efe6d86e5","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"d87e8013-86a7-4840-8d25-6f62e14eb4ac","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"a6acedfd-4043-4c64-a5d1-aec3326df9e7","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"dbdc0b24-06c4-48b9-8d6c-7455119dc773","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"a3856849-954a-4cfc-96a6-382e530d3638","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"4a39306b-ffa5-433d-80a3-28e41f929b72","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]}]
产品首页 在线 Demo 产品文档 API 参考 技术社区
立即试用
(Showing Draft Content)

14.0.0

以下的特性和改进已经包含在这个版本的产品中

已解决问题

自上次发布以来，以下问题已得到解决

  • 转换函数不支持m/s
  • gc.spread.sheets.angular.ts typescript文件随表格-angular npm包一起发布
  • SpreadJS 不支持Angular 9.
  • 快捷键Ctrl + Z可以变更活动表单
  • 公式=sss(")不会触发InvalidOperation
  • 当同时启用scrollbarMaxAlign和scrollByPixel时，垂直滚动条无法到达底部
  • 当拖动滚动条时，自动滚动行为受到影响
  • 在插入复制的列时，筛选的区域没有被正确更新
  • 在将公式引用从A1变更为RC之后，验证器中的公式不起作用
  • 导出Excel时出现错误
  • 当鼠标在Internet Explorer 11和边缘浏览器中滚动时，带有自动合并单元格的窗体不平滑
  • 图表的y轴刻度存在准确性问题
  • 样式文件的引入会影响自定义单元格样式
  • 添加行时，所选状态会发生变化
  • 加载，计算和更新表格，使用RAND和RANDBETWEEN是非常缓慢的
  • 印刷过程中图像失真
  • 视窗滚动比滚动条慢
  • 当单击sort选项时，页面会在使用“npm install”演示时卡住
  • 对于表中索引为0的添加行，数据可扩展性功能不起作用.
  • 超链接颜色在SpreadJS表单中显示为灰色
  • Android手机编辑框中的文本显示不完整
  • 滚动特性对冻结的行不起作用
  • excelio.save 方法在node环境中不能正常工作
  • Google Sheets使用SpreadJS复制和粘贴出现问题
  • 条件格式不适用于以“#”字符开头的值
  • 中文样式在保存Excel时丢失了
  • 在修改标题时，Designer_Source将导致标记移位
  • 筛选表后下拉数据是错误的
  • 在插入列之后，命名区域没有得到更新
  • 取消隐藏后，隐藏列的宽度仍然为零
  • SUMIFS函数的参数对话框中的参数是错误的
  • 当类别轴标签区域包含两行或多行时，饼图和甜甜圈图图例的显示与Excel不同
  • 设计器格式对话框字体风格不同于Excel
  • 文本不对齐的问题当单元格的文本溢出时，选中并单击该单元格将其合并到中心
  • 在自动换行的情况下，编辑过程中粘贴的内容与编辑过程中复制的内容不同
  • 导入的.xlsx文件、SJS和Excel与range group按钮显示状态不一致
  • 不能在在线编辑器中删除行标头选择的行
  • 条件格式引用会随着条件规则优先级的改变而改变
  • 当添加一个自定义函数RAND1，设置calcOnDemand，在单元格A1中输入1，在单元格A2中输入"=RAND1(A1)"，然后在A3之后插入行时，单元格A2应该一直保持不变
  • 单元格溢出时，自动合并功能无效
  • 由SpreadJS导出的Excel出现错误
  • 在从数据源加载表之后，表行和列的插入不能正确地更新单元格样式
  • 导入到SpreadJS后，超链接会发生变化
  • 导入到在线编辑器中的内容与Excel不一致
  • 使用suspendEvent后，无法将数据源绑定到表
  • 导出的Excel在表格中的轮廓和划线有样式错误
  • 即使在单击取消隐藏选项后，该列仍然不显示
  • 设置自动合并功能会导致卡住滚动条
  • 在组件设计器中，fromjson导致页面崩溃
  • 计算出的col/row大小在缩放时显示在工具提示中
  • 当缩放操作时表格显示错误
  • 字体(样式)没有正确导出到Excel中
  • 图表分类没有显示前导零
  • subtotal 公式不能正常使用
  • 组件版设计器不能使用上下文菜单删除该行
  • 组件设计器通过导出和导入错过了数据绑定的模式
  • 导出excel与组件设计器进行数据验证，结果与设置不一致
  • 当名称具有“&”时，命名样式不起作用
  • 当公式在拖动滚动块后引用单元格时，该公式无效
  • 删除表单时，公式不调整
  • 在设计器中设置移动滚动条后，无法向右拖动所选内容
  • 带下划线的文本不会在FireFox中从Excel复制到SpreadJS
  • 将计算值设置为真后，公式不计算
  • 导入的excel文件的一些部分丢失了
  • 文件的导入花费太长时间
  • POWER 函数返回的值与Excel不同
  • 组件版设计器中文culture并没有被完全翻译
  • “=OR(VLOOKUP(K31,Sheet10!A:C,1,FALSE)，FALSE)”公式结果与Excel不一致
  • 展开/折叠事件需要花费大量时间来更新表单
  • 当在Angular应用程序中设置Sparkline选项时，控制台会出现错误，说在输入“Object”时这些选项不存在
  • 条件格式在插入新行时中断
  • 当一个单元格有像“a 当它被复制(ctrl + c)并粘贴(ctrl + v)到单元格时，它被粘贴为“a b c”
  • 删除表行的时间很长
  • 允许对字符串资源进行本地化，但默认的表单名称仍然是英文的，不能进行本地化
  • 组件版设计器重复显示ribbon
  • 缩放后切片器显示不正确
  • 从GoogleSheets粘贴数据有格式问题