Spreadsheet formulas issue when datas are located on another sheet

Any issues about docs (uploading, editing and etc.)
Post Reply
Louis Moreaux
Posts: 1
Joined: Wed Oct 21, 2020 10:05 am

Spreadsheet formulas issue when datas are located on another sheet

Post by Louis Moreaux » Wed Oct 21, 2020 10:23 am

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
Posts: 164
Joined: Thu Dec 12, 2019 11:08 am

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

Post by Alexandre » Thu Nov 26, 2020 1:52 pm

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.

Post Reply