Paste data
Copy rows from a spreadsheet or a text file and paste them onto the canvas to make a new table. What a paste does depends on where it lands: on empty canvas it creates a table, on a selected cell it fills that cell.
Paste rows as a new table
- Copy the rows in your spreadsheet, header row included.
- In Mycorr, click an empty part of the canvas so that no cell is selected.
- Paste with ⌘ V (Ctrl V on Windows and Linux).
Mycorr detects whether the text is tab- or comma-separated, reads the first row as column names, infers each column's type, and creates a table named Table 1, Table 2 and so on.
Like an upload, a pasted table is owned by the model, and anyone who can edit the model can make one. If the text doesn't parse as a regular table, for example because rows have different numbers of fields, Mycorr says "Failed to parse into regular table" and creates nothing. Save the text as a file and upload it instead, where you can set the delimiter, quote character and encoding yourself.
Paste into a cell
With a single cell selected, a paste replaces that cell's value, exactly as if you had typed it.
A cell takes one line of text. To paste text that spans several lines into one cell, press Enter to edit the cell first, then paste. Pasting multi-line text onto a selected cell without editing it is refused, so a stray paste never spreads across a table.
Paste what you copied in Mycorr
Copying inside Mycorr carries more than text, so pasting it back does more than a plain paste:
| You copied | You paste | You get |
|---|---|---|
| A cell | On a selected cell | Its value, with its type |
| A table view (select the view, ⌘ C) | On the canvas | A second view of the same table, where your pointer is |
| One or more columns | On empty canvas | A new view of that table showing only those columns |
| One or more columns | On a selected view of the same table | Those columns added to the view |
None of these copies data: a view is another window onto the same table. See Tables and views.