Libre Calc - copying cell text to other app has added CR at end

When I copy a cell’s text to the windows copy buffer and then go to notepad and paste, the text is pasted with an added carriage return. Or maybe line feed. Either way, it’s something I’d rather not happen.

Likely it is done for the sake of multi-cell copy-paste. In that case, when you copy a range, the buffer gets a TSV data, where columns get separated by tabs, and rows - by newlines. Each row ends with newline, including the last one, as is permitted by CSV standard. A single cell is a simplest case of such TSV :slight_smile:

However, it’s not even clear that an empty last line permitted by the standard is a good thing; so maybe we need to really make sure to not have that trailing newline. Maybe @erAck has a better insight?

Anyway, if you want something “rather not happen”, please file a bug report.

3 Likes

F2, CtrlA, Ctrl+C, Esc

Thanks. I will do that until I hear of a better way, like a setting in Calc to remove that extra CR/LF.

Is Notepad a must? For example, if you use LO Writer then you can Paste-Special>Unformatted Text. Other programs may have similar options.