VLOOKUP functions are evaluated to 0

Aspose.Cells Product Family
1

Hello,

We’ve identified a couple of problems with the VLOOKUP function, it seems after performing CalculateFormula the functions are evaluated to 0, as opposed to Excel which computes different values.

I’ve attached a small console application describing the issue, you can check the Sheet1!A2 cell’s value after performing calculate formula.

We are using Aspose.Cells version 8.1.1.0.

Thank you,
Mihai Andrei
Senior Software Engineer
IBM Romania

2

Hi Mihai,


Thank you for bringing this issue to our knowledge.

We are able to reproduce the said issue with latest version of Aspose.Cells for .NET 8.1.1.3, and have logged it in our bug tracking system under the the ticket CELLSNET-42851 for further investigation & correction purposes. Please spare us little time to properly analyze the problem cause, and to provide a fix. In the meanwhile, we will keep you posted with updates in this regard.

Please accept our apologies for your inconvenience.
3

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.1.2.2 and let us know your feedback.

4

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
5

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan