Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Thu Sep 24, 2020 10:13 am

这是初始情况: sheet.Range["A11"].Formula="=SUM(A1:A10)";
当我删除了第9,10行时: sheet.DeleteRow(9, 2);
sheet.Range["A9"].Formula依然还是"=SUM(A1:A10)",无法更新??
别的公式函数暂时没有发现这种情况。。

CiooiZ.1001
 
Posts: 3
Joined: Thu Sep 10, 2020 7:30 am

Fri Sep 25, 2020 7:44 am

您好,

感谢咨询!
根据您的描述我进行了初步测试,确实注意到公式未被正确地更新,删除之后正确的公式应为“=SUM(A1:A8)"。这个问题已经记录在了我们的bug系统中,编号为SPIREXLS-2809。如果有任何更新,我们会通知你。对于带来的不便感到十分抱歉。

Sincerely,
Elena
E-iceblue support team
User avatar

Elena.Zhang
 
Posts: 279
Joined: Thu Jul 23, 2020 1:18 am

Thu Oct 15, 2020 9:13 am

您好,

很高兴通知您,我们刚刚发布了Spire.XLS Pack(Hotfix) Version:10.10.6,它修复了您的问题。欢迎从以下链接下载。
网站链接: https://www.e-iceblue.cn/Downloads/Spire-XLS-NET.html
Nuget链接: https://www.nuget.org/packages/Spire.XLS/10.10.6

Sincerely,
Elena
E-iceblue support team
User avatar

Elena.Zhang
 
Posts: 279
Joined: Thu Jul 23, 2020 1:18 am

Return to Spire.XLS