Hello
I’m trying to find a way to import data from a spreadsheet that is in the nextcloud repository to another spreadsheet, is it possible to do this process?
Thank you very much in advance!
Hello tiago.
Unfortunately, there’s no such feature for your request.
Sorry for inconvenience.
Hello Alexander.
Correct, and you don’t have a forecast or interest in composing this function?
Thanks
Sorry, “Alexandre”
Could you please describe in detail the desired scenario of mentioned feature. How exactly do you imagine this process?
Hello Alexandre
As I use Onlyoffice integrated with Nextcloud, it may be possible to have this exchange of information between xlsx files, through its “link” url, being informed together with the cell where the data you want is located. It can also impose that acceptance is requested with an alert of the movement to the user, bringing an extra layer of security.
Grateful!
Hello tiago.
Thank you for detailed description. We thought about something similar. Unfortunately, I cannot provide you with any timeframes or in what form such functionality will be implemented.
But we are planning to implement the similar idea.
Hello Alexandre
Perfect, I’m available to help with anything that is relevant.
Att.te
1 Like
Hi there, this is a feature I’m also desperately searching for. It’s esp. lacking when you want to move your system from GSuite to ONLYOFFICE.
IMPORTRANGE
Google Sheets has a very good way to import a range from another spreadsheet.
Maybe this can be some inspiration. spreadsheet_url could be a link to another ONLYOFFICE file.
IMPORTRANGE(spreadsheet_url, range_string)
EXAMPLE
IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Hh2grfB6rp9OQ2yAIu3S5YF_CCFJGwyqPGveABlOZKg/edit", "World Cup!A1:D21")ABOUT
Imports a range of cells from a specified spreadsheet.
spreadsheet_url
The URL of the spreadsheet from which data will be imported.
range_string
A string of the format “[sheet_name!]range” (e.g. “Sheet1!A2:B6” or “A2:B6”) specifying the range to import.
Further Import functions
There is also a number of other import functions as can be seen in the picture below. All doing essentially the same thing but are different in the way they consume the data.
1 Like
you have found a solution?
Thanks
We have a license of onlyoffice within nextclod and I see that the possibility to import data from another excel sheet to the document, or the possibility to copy-paste, is still not included.
This is a basic and fundamental question, how is it possible that in 2022 it is still not implemented?
Hello @foton
We are still working on the linked spreadsheet cell values feature as it is described by topic starter. But copy-paste feature between xlsx files works properly. Please clarify the issue which you faced.
By the way, if you have commercial license, it’s better to contact us viz Zendesk to get prompt replies.