[This topic is migrated from our old forums. The original author name has been removed]
If I cut/paste some CSV (say some cells copied from Excel) into a new row, thus creating several rows in the database then a row of NULL values appears at the end if the last line contains a carrage return.
If the last line contains only the record seperator without any field seperators, it should be ignored during paste.
over 14 years ago
[This reply is migrated from our old forums.]
Re: Cut/Paste + carriage returns
Pasting into the grid may seem to be an easy task... After testing with a number of spreadsheet applications it appear they all prepare the copied data differently (appending carriage returns, skipping column delimiters if empty cells, etc).
However, the behavior you've found is a bug and will be fixed in the next version.
Thanks for reporting it!