Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

What's spreadsheet data?

Copied from multiple cells, you will always get a new paragraph per cell border. Copying from one cell and inserting by 'Paste Special' as 'unformatted text' you will not get a NewParagraph inserted.

What's spreadsheet data?

Copied from multiple cells, you will always get a new paragraph per cell border. shifting from one cell to the next one. Copying from one cell and inserting by 'Paste Special' as 'unformatted text' you will not get a NewParagraph inserted.

==== Editing with regard to the questioner's comments. ==== Any application accepting text from the clipboard will have to insert it on its own responsibility. LibreOffice cannot even prevent a substitution of any "u" by an "x" if the accepting software is programmed to do that.

If you want no (or as few as possible) line breaks (may also be NewParagraph) you first must prevent Calc from exporting them. To achieve this you should assemble the content of as many cells as possible by formulae, suppressing internal LineFeeds and simply inserting a space between the contents of two subsequent cells. This can never be done for more than 65536 characters at a time which is the maximum a single cell can contain. As Calc does not offer a range concatenation, more detailed advice will depend on the details of the task (How many cells, how much text per cell and in total ...).

Hope someone else has better ideas.