Problem with VLookup and numbers

Aspose.Cells Product Family
1

We are having issues with a VLOOKUP in conjunction with TRUNC. Version 6 matches to Excel but version 8.4.1 gives an error.


Please see the attached spreadsheet at row 22.

Thanks
2

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after executing the following sample code with the latest version: Aspose.Cells
for .NET v8.4.1.1. We found, the Vlookup formula was not calculated correctly.

Could you please provide us the complete version number of Aspose 6.x so that we test this issue with the older version and log it as a regression issue.

I have attached the output pdf generated by the code for a reference.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\ASPOSE+Tester+04202015.xls”;


Workbook workbook = new Workbook(filePath);


workbook.CalculateFormula();


for (int i = 0; i < workbook.Worksheets.Count; i++)

{

if (workbook.Worksheets[i].Name != “Tester”)

{

workbook.Worksheets[i].IsVisible = false;

}

}


PdfSaveOptions opts = new PdfSaveOptions();

opts.OnePagePerSheet = true;


workbook.Save(“output.pdf”, opts);


3

The DLL reports itself as 6.0.0.0 in the Explorer properties window

4

Hi,

Thanks for using Aspose.Cells.

We were able to observe this regression issue. It worked fine in older version 6.0.0.0 but does not work with latest version.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-43602 - Vlookup formula was not calculated correctly

5

Hi,

Thanks for your using Aspose.Cells.

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

6

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

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