PRODUCTS
Purchase
Support
Tutorials
Corporation
Forum
/
Libraries
/
Spire.XLS
Change font size
Print view
User Control Panel
View your posts
FAQ
Login
公式SUM无法更新
Post a reply
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
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
Elena.Zhang
Posts:
279
Joined:
Thu Jul 23, 2020 1:18 am
Display topics from previous:
All posts
1 day
7 days
2 weeks
1 month
3 months
6 months
1 year
Sort by
Author
Post time
Subject
Ascending
Descending
Post a reply
Page
1
of
1
Return to Spire.XLS
Jump to:
Select a forum
------------------
Libraries
Spire.PDF
Spire.XLS
Spire.Doc
Spire.Presentation
Spire.BarCode
Spire.Email
Spire.DocViewer
Spire.PDFViewer
Spire.Spreadsheet
Spire.OfficeViewer
Spire.DataExport
Spire.OCR
New Feature Requests
Complaints & Suggestions
中文技术支持