How do I copy Text from Writer to Calc and Keep Font Style?

English
, ,
#1

I currently have some Text in a LibreOffice Writer Document, separated on different lines (with Carriage Returns), and each line of text has a different Font (sometimes called Font Family, example: Arial, Calibri, Georgia, etc.). There are a lot of lines.

I want to copy this text in Calc as a “one time deal”, and keep all the Text Formatting that’s in my Writer document. For each line in my Writer document, I want them to be pasted in separate distinct Cells in a Calc sheet (and keep it’s text Fonts and Formatting ).

When I select all the lines in Writer, then paste in Calc, the text is pasted in Calc in separate cells, but all Fonts are lost, NO MATTER what type of “Paste special” I try. I can double click in each separate Cell and paste each line of text manually, but that will take too long. I could also manually select each cell afterwards and change the Font type of each separate cell manually, but that also would take too long. Even if I try pasting Tables that are in a Writer document, into a Calc sheet, that doesn’t work, Font Type is lost.

Is there any type of “Exporting” possible, from Writer to an ods File? Is there any way to paste into a Calc file and keep all text formatting?

I’m ripping my hair out trying to keep Fonts and Formatting copying text between Writer documents and Calc sheets. Any help would be greatly appreciated.

#2

You can’t keep Writer formatting in Calc because it is far more sophisticated than what Calc can do. The “styles” don’t cover the same notions in Writer and Calc.

#3

Well listen, I understand that both operate differently. However, one fact that is true is: it is possible to get the result I’m looking for, but with a lot of manual labor. The question is: is there another way? A better way?

Perhaps there’s some sort of process that can be automated to do this. Just thinking out loud: perhaps there’s a way to go through each cell, enter “edit” mode, paste the value of “Array_1” (say), then move on to the next cell, and repeat? With a Macro? With an Extension? Perhaps there are other underpinnings of LibreOffice that would allow to do this some other way? Would Calc allow Formatting the text of each Cell from some other File Format? docx File? PDF File? Does Calc recognize Markdown Formatting better than HTML Formatting?..

#4

Perhaps, but I never wrote a macro in more than 20-yr LO practice.

None of these

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.