abe33 / atom-tablr

Edit CSV files using a table editor
MIT License
165 stars 44 forks source link

copy broken by newlines in cell #54

Open d3v-null opened 8 years ago

d3v-null commented 8 years ago

hey there, what a beautiful plugin you have! unfortunately, I can't use it for analysing a contact database as my address fields are exported from my contact database with newlines (out of my control) and although your parser handles these fields and places them in cells correctly, i can't copy out of the cells because the newlines aren't escaped correctly for either OSX numbers or Google Drive.

Here's some test data that u can use to reproduce my problem:

"qwe","rty","uio"
"asd","fg
h","jkl"
"zxc","vbn","m."

here are my settings

screen shot 2016-05-18 at 11 22 21 am

and here is my sys conf:

atom 1.7.3, tablr 1.3.0, MacBookPro11,3, OS X 10.11.4 (15E65)

Also as a side note, the ability to open a new spreadsheet from the command palette would be very helpful :)

abe33 commented 8 years ago

and although your parser handles these fields and places them in cells correctly, i can't copy out of the cells because the newlines aren't escaped correctly for either OSX numbers or Google Drive.

So that I understand correctly, what you want is to copy these string from Atom and paste them into Numbers/Google Drive but it fails due to the newline format?

d3v-null commented 8 years ago

what happens is that when it is pasted into the external program, it copies it as if there cell containing a newline broke the row, which i suspect is caused by incorrectly escaped newlines.

it should copy like this

| qwe | rty      | uio |
| --- | -------- | --- |
| asd | fg<br/>h | jkl |
| zxc | vbn      | m.  |

but it copies like this instead

| qwe | rty      | uio |
| --- | -------- | --- |
| asd | fg       |     |
|  h  | jkl      |     |
| zxc | vbn      | m.  |