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

Desktop editors
,
1

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

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

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

2

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.

4

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.