Hello,
There’s a cool formula in Google Sheets called IMPORTRANGE
that allows you to reference ranges in other sheets.
Does Collabora Online have a similar feature?
1 Like
Tex
August 24, 2023, 1:57pm
2
Welcome to the forum, @EtagiBI .
Thanks for the question.
No. Not currently.
But it would make a good enhancement request!
Do you have a Github account? You could submit it as a “Feature Request” to the Collabora Online github:
It would probably also help to include a link to:
and any other examples/supporting documentation/use-cases you have on it.
As to the technical reasons why it isn’t implemented yet…
There are a lot of tricky issues with loading external resources/files, or running across “infinite loops” where A->B + B->A.
So right now, each Collabora document is “stuck in its own jail”.
Side Note: On a similar note:
Links to ranges in other external documents isn’t supported yet either.
It is in the list of feature enhancements though.
I even brought it up back in July’s weekly meeting #128:
1 Like
Rodal
September 1, 2023, 8:26am
3
Hi,
This long time waited enhacement is alredy in Github
opened 07:59AM - 05 Dec 22 UTC
enhancement
**Is your feature request related to a problem? Please describe.**
Sometimes it… is very useful to be able to import data from another spreadsheet. For example, I have used this in the past to keep some base information (freelancer rates) in one file or to keep lists separate (with different access rights) but having an overview list that merges data from several lists.
**Describe the solution you'd like**
Google sheets has the function IMPORTRANGE (https://support.google.com/docs/answer/3093340) while microsoft excel online has workbook links (https://techcommunity.microsoft.com/t5/excel-blog/workbook-link-support-coming-to-excel-for-the-web/ba-p/1590314)
**Describe alternatives you've considered**
A solution would be an external app that is used to register links between spreadsheets and knows which range to copy, but I haven't seen something like this.
**Additional context**
i found several feature requests on the forums and other places:
- https://forum.collaboraonline.com/t/insert-data-from-other-spreadsheets/93
- https://forum.onlyoffice.com/t/import-data-from-different-spreadsheet-files/369/8
- https://help.nextcloud.com/t/how-to-manage-link-between-cells-inside-spreasheets-with-collabora/45472
- https://www.reddit.com/r/selfhosted/comments/jj55lt/looking_for_online_database_spreadsheet_software/
- demo of importrange https://www.youtube.com/watch?v=DO0eacge-Cg
2 Likes
Tex
September 6, 2023, 7:49pm
4
Fantastic @Rodal . Thanks for linking to that exact Github issue.