XMatch and #Headers in cell formula

Aspose.Cells Product Family
1

Hi use Aspose.Cells .Net teh cell formula

=INDEX(MortalityInputs,XMATCH(“MortMult”,MortalityInputs[Sex]),XMATCH(Sex,MortalityInputs[#Headers]))

appears to give a #Name error which I believe is because of both XMatch and #Headers in the formula.

Are these not allowed as they are valid Excel syntax?
Are you planning to add them?

Thanks Martin

2

@Martin_Sher
At present, we do not support the XMATCH function. We are already planning to support the XMATCH function. Once there are any updates, you will be notified immediately.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-52256

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

Thanks. And what about #Headers

4

@Martin_Sher
Headers are not related to functions, after Aspose.Cells supports the XMATCH function, your issue will be resolved. Would you like to provide your sample file? After supporting XMATCH, we can use your sample files for testing. If any issues are found, we can solve them together.

5

@Martin_Sher

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.

6

The issues you have found earlier (filed as CELLSNET-52256) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi