Page 1 of 1

Spreadsheet formulas issue when datas are located on another sheet

Posted: Wed Oct 21, 2020 10:23 am
by Louis Moreaux
Hi,

We are facing an issue with formulas SLOPE, INTERCEPT and CORREL when using datas that are located into another sheet.
I use the cloud try environment and the sample spreadsheet file to reproduce the issue.

On Sheet1, I am able to calculate SLOPE, INTERCEPT and CORREL whith those formulas :
  • =SLOPE(D3:D27,E3:E27)
  • =INTERCEPT(D3:D27,E3:E27)
  • =CORREL(D3:D27,E3:E27)
But on Sheet2, those fomulas don't work :
  • =SLOPE(Sheet1!D3:D27,Sheet1!E3:E27)
  • =INTERCEPT(Sheet1!D3:D27,Sheet1!E3:E27)
  • =CORREL(Sheet1!D3:D27,Sheet1!E3:E27)
Anyone have the same issue and maybe a solution?

Thanks
Louis

Re: Spreadsheet formulas issue when datas are located on another sheet

Posted: Thu Nov 26, 2020 1:52 pm
by Alexandre
Hello Louis Moreaux.
Sorry for the late reply.

Please provide us some additional information:
1. Example of the file where the issue reappears.
2. The scenario how to reproduce the issue step by step.
3. Version of your Document server.