Hi,
Thank you for sharing the template file and code sample.
After an initial test we have found your mentioned issue, we will look into it and get back to you soon.
Thank You & Best Regards,
Hi,
Thank you for sharing the template file and code sample.
After an initial test we have found your mentioned issue, we will look into it and get back to you soon.
Thank You & Best Regards,
Hi, do you know of any work around I can use while you investigage as this is causing a bit of a problem for us at the moment.
Thanks for all your help,
Oli
Hi,
Thank you for considering Aspose.
Well, we are working on your issue and hopefully we will provide you with a fix in 2~3 days time.
Thank you for understanding.
Hi,
Please try the attached version, we have fixed your issue.
Thank you.
Hi,
So far it seems to work perfectly.
Thanks for your help,
Oli
Hi Guys,
That fixed the previous problem perfectly, I now have another one for also with CalculateFormula with an Array Formula.
The problem is how Cells evaluates >0 against blank cells within IF statements in array formulas.
I have attached the example workbook and find my sample code below.
Thanks again,
Oli
Dim license As Aspose.Cells.License = New Aspose.Cells.License()
license.SetLicense("Aspose.Total.lic")
Dim wbkTest As New Workbook()
wbkTest.Open("c:\testing\test10.xls")
MsgBox(wbkTest.Worksheets(0).Cells("B5").Value)
wbkTest.CalculateFormula()
MsgBox(wbkTest.Worksheets(0).Cells("B5").Value
Hi,
Thanks for providing us the template file with sample code.
Yes, we found the issue after an initial test, we will provide a fix soon.
Thank you.
Hi,
Please try the attached version.We have fixed this bug. If you still have any problem, please feel free to contact us.
Thank you.
Many thanks,
Oli
The issues you have found earlier (filed as 8588) have been fixed in this update.
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.
I am not totally sure if this is the correct thread to respond in, but I think this issue may have popped up again. Please see the attached document that is giving me a problem.
Hi Van de Loo,
Hello,
I have some additional information and a question.
Hi,
Hi,
Hi,
Please download and try our latest fix/version: Aspose.Cells for .NET 8.0.0.1
Hi,
The issues you have found earlier (filed as CELLSNET-42507) have been fixed in this update.