IMPORTRANGE Function Not Working in DocumentServer 8.3.1.1

Workspace
1

Hello, the IMPORTRANGE function isn’t working properly in DocumentServer 8.3.1.1. I’m trying to link data from Document #1 to Document #2, but it returns values like N/A, NUM, or 0, even though the source document contains valid data. I’m using the following function:

=IMPORTRANGE(“https://xxxxxxxx/Products/Files/DocEditor.aspx?fileid=1614";"‘page1’!D17”)

What could be causing this issue?

image
image761×518 18.6 KB

2

Hello @Yuri

Try passing range_string value for the formula with exclamation mark only, like that:

"Sheet2!A1"
3

Do you mean in this format? :

=IMPORTRANGE(“https://xxxxxxxxxxx/Products/Files/DocEditor.aspx?fileid=1614";"page1!D17”)

It still doesn’t show the value and returns N/A.

4

Judging by the link, I may assume you are using Workspace, aren’t you? Can you specify version of it?

5

Workspace 12.7.1.1942

6

Thank you. Please try the following approach to insert the function:

  1. Open both the source and the destination spreadsheets;
  2. In the destination spreadsheet select necessary cell for formula insertion;
  3. Go to Fomula > Function and in the search box find IMPORTRANGE, then click OK;
  4. In the Function arguments window paste necessary values in quotation marks:
    4.1 Speadsheet_url: "https://workspace/Products/Files/DocEditor.aspx?fileid=125";
    4.2 Range_string: "Sheet2!A1".
  5. Then check if the value next to Function result is displayed;
  6. If it is, then click OK to insert function.

Let me know if it works that way.

7

It doesn’t help, the problem remains the same.

8

I’ve just noticed that you are using Document Server 8.1.1. I’ve tested the functionality on actual version, so please update your instance to the actual version 8.3.2 and check the situation again.

9

I updated to version 8.3.2.1, but the issue still hasn’t been resolved.

10

Is it possible to share those two files that produce the issue for tests? By the way, do you use proxy in your environment?

11

We have ONLYOFFICE running through a reverse proxy.

12

That could be the reason why editor cannot fetch the file and import range from it. Unfortunately, we do not have any samples of proxy configuration for Workspace as it already relies on a complex structure of internal communication.