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.
