Summary of the issue you are facing:
I am unable to get IMPORTRANGE working using Euro-Office on Nextcloud. I’m trying to copy a range from one spreadsheet (that happens to be the output of a Nextcloud Forms form), and import it into a different spreadsheet.
This occurs when either through using the graphical formula editor, or by typing it out myself.
The formula results always expands writing “n/a” into all boxes.
I am uncertain what the correct “spreadsheet URL” would be to use. I’ve tried the browser URL to the source file, a public share link, as well as a private share link. No change.
Server:
- Nextcloud Server version (e.g., 29.x.x):
34.0.1
- Installation method (e.g. AlO, NCP, Bare Metal/Archive, etc.)
AIO
- Are you using CloudfIare, mod_security, or similar? (Yes / No)
No