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.

Fri Apr 13, 2018 3:37 am

We tried to use the following ROUND() method in MS Excel, and the result in Spire.XLS library differs from MS Excel.
=ROUND(2.135,2)

In Excel, the result is 2.14; but in Spire.XLS, the result is 2.13.

We used the following codes for calculation:

Code: Select all
   
Workbook workBook = new Workbook();
Worksheet workSheet = workBook.Worksheets[0];
object objResult = workBook.CaculateFormulaValue("=ROUND(2.135,2)");


Are there any ways for us to calculate the same result as MS Excel ? Thanks

sxlsgs
 
Posts: 7
Joined: Fri Apr 13, 2018 2:06 am

Fri Apr 13, 2018 6:54 am

Hello,

Thank you for contacting us.
I have noticed the issue and posted it to our Dev team for investigating and fixing, If there is any progress, we will share with you immediately. Sorry for the inconvenience.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Wed Apr 25, 2018 7:19 am

Hi,

Thanks for your patient waiting.
We just release the Spire.XLS Pack(Hotfix) Version:8.4.13 which includes the fix for your reported issue. Welcome to download.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Fri Apr 27, 2018 3:49 am

Hello,

Greetings from E-iceblue.
Has you issue been fixed?
Thanks in advance for your valuable feedback.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Return to Spire.XLS