Support for REGEXTEST() function

Aspose.Cells Product Family
1

Hi,

Newer versions of Excel have introduced the REGEXTEST() function:
https://support.microsoft.com/en-us/office/regextest-function-7d38200b-5e5c-4196-b4e6-9bff73afbd31

This is a very useful and versatile function, allowing simplification of many formulas.

When are you planning to support it in Aspose Cells?

Thanks in advance,
Taras

2

@TarasTielkes

Summary
Aspose Cells does not currently support the Excel worksheet function REGEXTEST(). When a workbook containing this formula is processed by the library, the function is evaluated as #NAME?.

Why it happens
REGEXTEST() is a newer Excel function that has not yet been added to the Aspose Cells calculation engine. The feature is being tracked internally, but no release schedule has been announced.

What to do next

  1. Apply a workaround – replace REGEXTEST(text, pattern) with a formula that Aspose Cells can evaluate, for example:
=ISNUMBER(SEARCH(pattern, text))

Adjust the pattern to a simple substring search, or combine ISNUMBER, FIND, and LEN to approximate regular‑expression behavior.

  1. Monitor product updates – keep an eye on Aspose Cells release notes or the relevant forum discussion for any announcement that REGEXTEST() has been added.

  2. Submit a feature request – use the Aspose Cells feedback channel to request support for REGEXTEST(). Providing details about your use case helps the product team prioritize the implementation.

  3. Escalate internally if needed – if the function is critical for an upcoming deadline, let your internal support or development lead know so they can raise the request through the appropriate Aspose Cells support process.

Following these steps will allow your workbooks to remain functional while awaiting native support for REGEXTEST() in future Aspose Cells releases.

:warning: I could not fully verify this explanation against the retrieved sources. Please double-check the behaviour in your environment and confirm the exact SDK/version.

3

@TarasTielkes,

Thanks for your request.

Aspose.Cells does not support the REGEXTEST function. However, we will thoroughly evaluate this formula/function for potential support within the Aspose.Cells formula calculation engine. For your requirements, 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): CELLSJAVA-46578

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.