Support for the FORECAST.* functions

Aspose.Cells Product Family
1

Hi,

The function FORECAST is supported, but it is deprecated in MS Excel (since 2016) and replaced by FORECAST.LINEAR.

Is support for any of the new FORECAST.* functions planned?

See following link, for the list of forecast functions that MS Excel supports since Excel 2016:

Thank you!
david.

2

@dcatteeu,

Thanks for the details.

FORECAST function is supported (see the supported functions/formulas, the list is not final though (there might be more functions which are supported now): Supported Excel Functions|Documentation) . We will check and evaluate the FORECAST with its flavors (as per your requirements). Could you provide your template file (containing the functions), we will log a ticket into our database for investigation.

3

Hi,

Thank you for the quick response.

I forgot to mention that I upgraded and tested with the latest version: 18.11.

Please find a minimal working example workbook in attachment that uses FORECAST, FORECAST.LINEAR, and FORECAST.ETS.

forecast.zip (6.6 KB)

Thank you,
david.

4

@dcatteeu,

Thanks for the template file and further details.

I have logged a ticket for your demanded feature with an id “CELLSNET-46481”. The ticket is logged as following:
CELLSNET-46481 - Support FORECAST.* functions.

We will look into it soon.

Once we have an update on it, we will let you know here.