Formula issue with round range in sum

[dannychan]

Hi,

I try to assign the formula in XLS(free library) using round first then only sum using =SUM(ROUND(A1:A10, 15)), but it came out as =SUM(ROUND(@A1:A10) in the file (notice there's a @ after round), Excel doesn't recognized the @ in the formula and treat it as invalid type.

sheet.Range["A11"].Formula = "=SUM(ROUND(A1:A10, 15))";

Please advise how to resolved this issue ?

Thanks.

regards,
danny

[Andy.Zhou]

Hello,

Thanks for your inquiry.
I simulated an Excel document and tested your formula using the latest free version. But did not encounter the issue you mentioned. To help us investigate further, could you please provide your OS information (e.g. Win10 64bit), region settings (e.g. China, Chinese), Excel version (e.g Excel 2016) for our reference? Thanks in advance.

[dannychan]

Hi,

Here's the info I gather my my local machine...FYI I have try latest version and older free version also having same issue.

Microsoft Excel for Microsoft 365 MSO (16.0.13127.21656) 32bit
Windows 10 Enterprise (64bit)

Region: Malaysia
Regional format: English (United States)

FreeSpire.XLS v10.10.0


regards,
danny

[Andy.Zhou]

Hi Danny,

Thanks for your sharing.
I tested your case in a similar environment to yours, but did not encounter the issue you mentioned. Here I uploaded my test project, please run it on your side to see if the issue occurs.
If the issue only exists in your project, to help us locate the cause, please provide us with your runnable project. Thanks in advance.

[Andy.Zhou]

Hi Danny,

Hope you are doing well!
Has the issue been solved now? Any feedback will be greatly appreciated.