Hi there
New to ONLYOFFICE so bear with my unskilled way of explaining things.
Been using GDRIVE and wanted to move to a non evil company, so move to Infomaniak kdrive solution.
Thing is I need to use almost all the time links between the spreadsheets I’m using, and despite having the IMPORTRANGE function avail in Onlyoffice, no way to make it work.
I’ve read other topics on it, but no real solution seemed to come out of it.
Re the function itself, I think I spell it right (below), it links toward an xlsx document, accessible to anyone with the link (no confidential informations there, only a test file).
The importrange function is written either from the onlyoffice online from the Infomaniak/kdrive solution or from the app onlyoffice directly, no matter, never working.
It either lead me to a #N/A outcome, or sometimes 0, but never the looked upon informations on the linked document.
Welcome to ONLYOFFICE, and thanks for the details about the IMPORTRANGE issue! Your formula format, IMPORTRANGE("URL";"B1"), is correct with the semicolon for your language settings.
Try this: Download the file from Google Sheets as XLSX and upload it to kDrive. Then, use the ONLYOFFICE URL (like https://your-kdrive-domain/files/DocEditor.aspx?fileid=XXX) in the formula. This should work within kDrive.
Quick note: The formula separator (; or ,) depends on app’s regional settings (locale). For example:
en-US, en-GB, ja-JP: use , (e.g., =SUM(A1,B1))
ru-RU, de-DE, fr-FR, es-ES: use ; (e.g., =SUM(A1;B1))
If it still doesn’t work, let me know, and we’ll sort it out together!
I’m using the ; as I’m on the French edition. Tried also with , hoping it would be the solution, but doesn’t fixed anything.
I tried with a native onlyoffice xlsx, a google spreadsheet transformed, a native excel document, a spreadsheet downloaded in .ods, unfortunately it doesn’t change anything.
Also was thinking the issue could come from the URL itself, as there either a public url or a private one, tried both, it doesn’t change anything.
Also I tried with a native onlyoffice document (so not the web version of onlyoffice), saved in my kdrive trying an import range on a native excel/onlyoffice document, still not working. Which is really weird, because I guess this one is supposed to work.
So my guess would be my kdrive isn’t really providing the right url ?
Maybe I should try with a publicly available URL pointing to a xlsx document see if it works ?
Thanks for trying all those variations and sharing the update — sorry it’s still not clicking!
I personally haven’t tested IMPORTRANGE with kDrive yet, and it looks like their integration with ONLYOFFICE focuses on editing/collaborating on files but doesn’t yet support advanced functions like IMPORTRANGE across spreadsheets.
In the meantime, as a workaround, you could try linking data manually (e.g., copy-paste values or use simple cell references if files are open side-by-side) or export/import between sheets. If kDrive adds this support down the line, we’ll update here.
Let me know if there’s another angle we can explore!
I guess that’s the only viable explanation indeed…
Will do as you said, but really hope import range will work with kdrive…leaving google is the goal but we need to have the best alternative possible before doing so
