FORECAST function not working when data is not from the same sheet

Do you want to: Report a bug
OS version: probably all platforms, tested on windows 10 desktop and web
App version:
Downloaded from: ONLYOFFICE website, web version on

When using forecast function with data on the same sheet, it works fine:

But when you use data from another sheet, it returns value error:

hey @Toaster :handshake:
Thank you for finding and providing a detailed description of the bug for us to reproduce. We greatly appreciate your contribution to our community. :hugs:

We reproduced this problem and added the bug to our tracking system.
We’re working on the solution of the issue, but I can’t say the exact dates.

Hello, @Toaster
In version 8.0, we have fixed the issue you reported.

  • ONLYOFFICE Docs is already available at the following link

  • ONLYOFFICE Desktop will be released within the week.