New Excel functions

[swmal]

WRAPROWS function - Done

https://support.microsoft.com/en-us/office/wraprows-function-796825f3-975a-4cee-9c84-1bbddf60ade0

WRAPCOLS function - Done

https://support.microsoft.com/en-us/office/wrapcols-function-d038b05a-57b7-4ee0-be94-ded0792511e2

REGEXEXTRACT function

https://support.microsoft.com/en-us/office/regexextract-function-4b96c140-9205-4b6e-9fbe-6aa9e783ff57

REGEXREPLACE function

https://support.microsoft.com/en-us/office/regexreplace-function-9c030bb2-5e47-4efc-bad5-4582d7100897

REGEXTEST function

https://support.microsoft.com/en-us/office/regextest-function-7d38200b-5e5c-4196-b4e6-9bff73afbd31

TRIMRANGE function - Done

TRIMRANGE(F:F) - trims a range, removing leading/trailing/all empty rows/cols.

Trim Refs operator

A1.:B10 (leading trim) → corresponds to TRIMRANGE(A1:B10,1,1)
A1:.B10 (trailing trim) → TRIMRANGE(A1:B10,2,2)
A1.:.B10 (full trim) → TRIMRANGE(A1:B10,3,3)

See https://techcommunity.microsoft.com/blog/excelblog/announcing-trimrange-and-accompanying-trim-references/4230202

FORECAST.ETS function

https://support.microsoft.com/en-us/office/forecast-ets-function-15389b8b-677e-4fbd-bd95-21d464333f41

FORECAST.ETS.CONFINT

https://support.microsoft.com/en-us/office/forecast-ets-confint-function-6d4a7557-11fa-4678-9e6a-dbcc31a7c7df

FORECAST.ETS.SEASONALITY

https://support.microsoft.com/en-us/office/forecast-ets-seasonality-function-32a27a3b-d22f-42ce-8c5d-ef3649269f3c

FORECAST.ETS.STAT

https://support.microsoft.com/en-us/office/forecast-ets-stat-function-60f2ae14-d0cf-465e-9736-625ccaaa60b4

Text/Web/Utility

ASC

https://support.microsoft.com/en-us/office/asc-function-0b6abf1c-c663-4004-a964-ebc00b723266

CODE - Done

https://support.microsoft.com/en-us/office/code-function-c32b692b-2ed0-4a04-bdd9-75640144b928

ENCODEURL - Done

https://support.microsoft.com/en-us/office/encodeurl-function-07c7fb90-7c60-4bff-8687-fac50fe33d0e

USDOLLAR - Done

https://support.microsoft.com/en-us/office/usdollar-function-cf756103-59e4-40a8-a78e-994c4e4243ad

Information/Inspection

CELL

https://support.microsoft.com/en-us/office/cell-function-51bd39a5-f338-4dbe-a33f-955d67c2b2cf

FORMULATEXT

https://support.microsoft.com/en-us/office/formulatext-function-0a786771-54fd-4ae2-96ee-09cda35439c8

ISFORMULA - Done

https://support.microsoft.com/en-us/office/isformula-function-e4d1355f-7121-4ef2-801e-3839bfd6b1e5

SHEETS

https://support.microsoft.com/en-us/office/sheets-function-770515eb-e1e8-45ce-8066-b557e5e4b80b

Functions that will not be implemented.

PY
This function runs Python code which is currently out of scope for EPPlus.

COPILOT
This function uses Microsoft Copilot to create the cell value. We will not implement this function as part of EPPlus as it requires a Copilot license and needs external service calls.

WEBSERVICE
This function rely on external services, so we will not implement it.

STOCKHISTORY
This function rely on external services, so we will not implement it.
https://support.microsoft.com/en-us/office/stockhistory-function-1ac8b5b3-5f62-4d94-8ab8-7504ec7239a8