Right - these outcomes are less than ideal and can be very annoying to users. However, it’s possible what you and your team are experiencing is environmental, not Airtable.
Have you experimented with the copy buffers you are employing?
There are many copy buffers; cmd-c, right-click-copy, [browser] edit-copy, etc.
There are many browsers; each handle copy paste in their own ways.
As you point out, there are also different contexts for each buffer; edit mode, display mode, end even other contexts such display in iFrame, etc.
There are also the interpretations made on the paste side; some apps interpret CR + LF differently, and some copy operations transform CR + LF into CR + CR.
Then there are the nuances of rich text; Airtable implements a unique flavor of Markdown (not HTML) and paste targets are free to do the same. Slack, for instance supports a completely non-standard Markdown unlike Airtable.
We cannot rule out the influence of browsers and unique interpretations for copy and paste events across the multiple buffers.
Lastly, we cannot easily predict how long-line texts are created; newline keyboard entry using
cmd-return insert very different character sequences. Is the content manually typed or is the content imported with new-line sequences?
Given all the variations and underlying machinery at work, it’s not surprising to encounter unexpected or undesireable outcomes. But it’s also unreasonable to expect any single vendor to behave with perfect precision with every paste target which leads me to ask - what are you pasting your content into and what method are you using? Is it…
- Right-click-paste with formatting?
- Right-click-paste without formatting?
- Browser menu option Edit | Paste with formatting?
- Browser menu option Edit | Paste without formatting?
As you can see, despite the three-factorial options on the copy side (i.e., 27 variants), there are many more variants on the paste side.
My hunch is there’s a way for your team to perform copy-paste processes with success; you just haven’t found the one that works with all factors considered.