Start a new topic

Cut/Paste + carriage returns

[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.
1 Comment

[This reply is migrated from our old forums.]

Re: Cut/Paste + carriage returns
Hi, 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! Best Regards Roger