Support Google Sheets

[romicolman]

Problem description

Right now, public spreadsheets do not load properly when using the Remote File feature (use this URL for testing purposes).

The ODE loads the data with no preview. It just adds the file (changing its original name) to the left menu:

Steps to reproduce it

• Open the ODE.
• Go to ADD---Remote File. Paste this URL

Questions/comments

Let's say a user adds the URL above and then someone makes changes to the online data. Will the ODE take those changes or once data is uploaded we show a "photo" of the tabular at a particular time?

[guergana]

@romicolman in principle when you add a remote file to the project, you are creating a local copy of the file on the computer, so when the user changes the file on the remote address it should make any changes to the local imported one unless you import it again. at least this is how i would expect this to work, right? @roll

[roll]

"Remote File" adds a copy of a remote file to the local folder (project)

[romicolman]

Understood. However, I have a question. The name of the Google Sheets is not EDIT. If you check the URL the name of the file is Ethical Tech Job Resources. Can we fix that? This ticket is about that issue.

[romicolman]

@roll just to be clear: this ticket is to make available Google Sheets on the ODE. In addition, the ODE should consider the title of the spreadsheet to name the file. In this case: Ethical Tech Job Resources

[romicolman]

I tested the change on Mac. It works!:)