Problem with XMATCH function

Aspose.Cells Product Family
1

Hi,

We have an XLSX file with data. The value of one of the cells is calculated with the XMATCH function, when using the CalculateFormula() functionality of the Woorbook, the result of the cell that uses the XMATCH function is not correct.

Example code:

Aspose.Cells.Workbook eBook = new Aspose.Cells.Workbook(pathToExcel);
Aspose.Cells.Cell cellXMatch = eBook.Worksheets[1].Cells[“N8”];
string valueOk = cellXMatch.StringValue;
eBook.CalculateFormula();
string valueError = cellXMatch.StringValue;

1.- We read the value of the cell and assign it to the variable valueOk, the value is correct.
2.- We apply CalculateFormula().
3.- We read the value of the cell and assign it to the variable valueError, the value is not correct.

Best regards

2

@Manel,

Thanks for details.

XMATCH function may not be supported by Aspose.Cells formula calculation engine, see the document on supported formulas/functions list. However, we can look into it Please zip and attach your template Excel file containing the formula, we will check and may log appropriate ticket for it soon.

3

Hi Amjad,

Attached .zip file with the Excel that corresponds to the code example.

XMATCH.zip (44.6 KB)

Best regards

4

@Manel,

Thanks for the sample file.

I did test your scenario/case using your file and found XMATCH formula is not supported by Aspose.Cells formula calculation engine. To support your needs, we have logged a ticket with an id “CELLSNET-52256” for your issue. We will look into it soon.

Once we figure it out, we will let you know.

5

@Manel

We are pleased to inform you that we have supported the calculation of XMATCH function(CELLSNET-52256). The enhancement will be included in our upcoming release (Aspose.Cells v24.5) that we plan to release in the second week of May 2024. You will be notified when the next version is released.

1 Like