TRIM function calculation issues

Aspose.Cells Product Family
1

Hello,

We’ve encountered some issues with Excel formula calculation, when performing Workbook.CalculateFormula(…), we’ve noticed some differences between Aspose calculation and Excel calculation.

The TRIM function from the TRIM.xlsx file seems to be calculated incorrectly by Aspose - “this is a string” value (expected value from Excel) is not resolved correctly and the string contains white spaces.

Aspose.Cells version used is 7.3.0.5 .

Please investigate these issues and provide us some feedback.

Thanks in advance,
Mihai Andrei,
Sr. Software Engineer,
IBM Romania

2

Hi,


Thanks for the sample file.

You are right. After an initial test, I can find the issue (regarding TRIM formula) as you have mentioned. I have logged a ticket with an id: CELLSNET-40981. We will look into your issue to figure it out soon.


Thank you.

3

Hi,


Please try the new fix: Aspose.Cells for .NET v7.3.0.6

We have fixed your issue regarding TRIM function now.

Thank you.

4

Mihai,

Ti-am trimis un mesaj privat… L-ai primit?

Mersi

5

Hi,

Let us know if you need any of our help, we will be glad to assist you further.

6

The issues you have found earlier (filed as CELLSNET-40981) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.