OpenOffice Calc cut&paste to Thunderbird

This blog entry is about how to copy this OpenOffice 3.1 data:

OOo2TB/calc_1.jpg

Into this Thunderbird 2.0 e-mail:

OOo2TB/mail_1.jpg

 First I used "gimp" to save a jpg version of the graph:

OOo2TB/SaveRegion.png

OOo2TB/SaveRegion_2.png

Then inserted into the e-mail.

Thunderbird -> Insert -> Image

OOo2TB/mail_2.jpg

OK - not too hard, but a more direct method would be convenient.

Inserting the OpenOffice Calc cells as a Thunderbird Table is almost easy.  Just select the cells in Calc, <ctrl>C, and paste into Thunderbird with <ctrl>V:

OOo2TB/mail_3.jpg

The problem, IMHO, is that when the OpenOffice Calc data is pasted into the Thunderbird message, all of the existing text in the Thunderbird message is assigned a font that is "too small".  Changing the font of the existing text was not an intended consequence of inserting a table into the message.

If you use "Paste Without Formating", Thunderbird puts text, not an HTML table, into your email, which may or may not be OK depending on the task at hand.

After you have pasted a table into your e-mail, if you want to increase the font size of some or all of your data, you can select any area, and use "<ctrl>+" (or Format->Size->Larger) to manually set the font size to what you had in mind.

Instead, I prefer to use the following approach to return to the original font size:

1) After the paste, in Thunderbird, type "<ctrl>A" to select all of the text

2) Click "Insert" -> "HTML" from the Thunderbird pulldown menus.  This brings up a window with all of the HTML for the current window

OOo2TB/html.jpg

 3) Delete:
    ; font-size:x-small

4) Click "insert"

Voila!!

OOo2TB/mail_4.jpg

You may want to experiment with removing the entire "style" tag if you don't like the Liberation Sans font.

I hope that someone out there in the WWW finds that this blog entry is helpful.



Comments:

Hi Jeff,

Thanks a lot for posting this man ! I've been wrestling with this problem since Thunderbird 3.0

Thanks again,
Ciprian

Posted by Ciprian on April 29, 2010 at 04:15 AM EDT #

Thanks a bunch, this fixed me right up!

Posted by Ryan on June 27, 2012 at 02:26 PM EDT #

Very helpful! My workaround has been a 2 stage process. First, copy/paste from OpenOffice Calc into OpenOffice Writer using "paste special/Paste as RTF", and clean up the table in Writer. Second, re-paste from Writer into Thunderbird.

That worked, but your solution is much simpler and more elegant.
Of course, even better would be to have this annoyance fixed in Thunderbird in the first place.

Posted by guest on August 10, 2012 at 12:32 PM EDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

user12620111

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today