Spreadsheet formulas issue when datas are located on another sheet

[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

[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.