Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Editable spreadsheet view for table values #35

Closed
chrismheiser opened this issue May 22, 2018 · 5 comments
Closed

Editable spreadsheet view for table values #35

chrismheiser opened this issue May 22, 2018 · 5 comments
Assignees
@chrismheiser
Labels
enhancement

Comments

@chrismheiser
Copy link
Owner

chrismheiser commented May 22, 2018 •
edited
Loading

The current way that values are handled isn't ideal. There should be a better way to visualize and edit data in a spreadsheet-like way.

There are a couple ways that I found so far.

  • Google Drive API + Google Sheets API
    Normally you can only embed a single google sheet after you manually go into an account and "share > publish" that specific sheet. You can get around this using the Google Drive API to create, publish, and then piece together the shared URL, and place it into the HTML DOM with javascript. The problem with this is it's overly complicated, and you would need a separate sheet for every table (or at least a separate tab for every table)
    Pros: Google sheets works well and would be nice to have
    Cons: It'd be quite complicated to get running and this would create a lot of random sheets in our google account. I'm not sure if this would go against and TOS.

  • Handsontable
    Javascript implementation of a table that should be easy to get going. It seems to be the popular choice for embedded tables. Looks clean, simple, and should be easy to create multiple isolated tables.
    Pros: Easier, simple, isolated.
    Cons: There seems to be a bug when trying to copy/paste data from an excel spreadsheet, which is going to be a pretty big use case. Not likely that I can use it if there's not a fix or workaround.
@chrismheiser chrismheiser self-assigned this May 22, 2018
@nickmckay
Copy link
Collaborator

nickmckay commented May 22, 2018 via email

@chrismheiser
Copy link
Owner Author

What example did you try? Every time a go to paste, it'll clear the cell but wont put anything in it.

@nickmckay
Copy link
Collaborator

nickmckay commented May 22, 2018 via email

@chrismheiser
Copy link
Owner Author

Strange. That's the one I was trying and it won't work in Safari. It worked fine in Chrome though.

chrismheiser added a commit that referenced this issue Jun 11, 2018
@chrismheiser
#35 : Embedded Spreadsheet with Handsontable
0a361c7 
There are now two ways to add values to your data tables. One, the classic way by copy pasting values into the textarea box and choosing the parse options. And two, by using the Handsontable embedded spreadsheet view. This is an interactive spreadsheet that works similar to a normal excel spreadsheet. You can:

- copy/paste cells, columns, rows
- add/remove columns via button, add/remove rows via a right-click menu, or do both automatically via copy/pasting. The table will expand to fit whatever you paste into it.
- Header row that shows the variable name and units (when available from column metdata)
@chrismheiser
Copy link
Owner Author

NOTE: Limited support for Safari.

Copy/paste does not work on Safari, which really limits the use of the spreadsheet idea when creating and editing data. All functions tested working on Firefox and Chrome

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@chrismheiser chrismheiser

Labels
enhancement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@chrismheiser @nickmckay