2x Bugs With Worksheet.CalculateFormula

Aspose.Cells Product Family
1

Hi,

I think I have found another couple of bugs when using calculate formula.

Please see the attached workbook.

The two problems are:

1. It seems to calculate the formula in Cells C16 and C17 incorrectly when running CalculateFormula.

2. When running the If Statements in column B it appears to be case sensitive whereas excel is NOT case sensitive. Can this be fixed so they match?

Please find the example code below and thanks in advance,
Oli

Dim a, b, c As String

Dim license As Aspose.Cells.License = New Aspose.Cells.License()

license.SetLicense("Aspose.Total.lic")

Dim wbkTest As New Workbook()

wbkTest.Open("c:\testing\BugTest.xls")

Dim shtTest As Worksheet = wbkTest.Worksheets(0)

a = shtTest.Cells("c16").Value

b = shtTest.Cells("c17").Value

c = shtTest.Cells("c19").Value

MsgBox("A: " & a & " B: " & b & " C: " & c)

wbkTest.CalculateFormula()

a = shtTest.Cells("c16").Value

b = shtTest.Cells("c17").Value

c = shtTest.Cells("c19").Value

MsgBox("A: " & a & " B: " & b & " C: " & c)

2

Hi,

Thanks for providing us the template file with sample code.

We found the issue after an initial test, we will figure it out and get back to you soon.

Thank you.

3

Hi,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells. We have fixed your mentioned issues regarding formula calculation.

Thank You & Best Regards,

4

Perfect, thanks,
Oli

5

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

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

Note: Just for your knowledge. In the new release v4.8.0, we have merged Aspose.Grid suite to Aspose.Cells for .NET msi installer as Aspose.Grid would be no longer offered as a separate product now. You need to install the installer (uninstall older one first if you have) and use only Aspose.Cells.dll library in your project for your need. You may also take advantage using Aspose.Cells Grid suite though.