Hello, In reference to - "o Paste plain text. If Thunderbird has a facility to paste unformatted text only," I have always used - Ctrl + Shift + V (the Paste Shortcut) to paste into a Thunderbird e mail to paste as unformatted text. This may clear part of the original users problem. Jean
On Tue, Oct 18, 2016 at 6:34 AM, Vince@Gmail <[email protected]> wrote: > > > On 10/16/2016 10:41 PM, Brian Barker wrote: > >> At 12:24 16/10/2016 -0400, Vince Bonly wrote: >> >>> I am attempting to paste a portion of a AOO 4.1.2 Calc sheet with >>> Formulae displayed into Thunderbird 45.4.0 compose window on WIN10x64 >>> machine. My ISP is Verizon. Seems that I am not able to show the formulae, >>> which is what I want to discuss, into the email compose window; only the >>> results of the existing formulae can be pasted. >>> >> >> Two suggestions: >> >> o Paste plain text. If Thunderbird has a facility to paste unformatted >> text only, I think that should work. If not, consider staging the copy via >> a plain text editor or even via an OpenOffice text (Writer) document, using >> Paste Special and "Unformatted text" to paste there. Values will be >> separated by tab characters, so you will need to set tabs to space your >> columns out appropriately. >> >> > I must look onto obtaining a better understanding of the Paste Special and > the "Unformatted test" features...:-) > >> o Save the sheet as CSV (as has been suggested). >> o Reopen the CSV file in Calc. >> o In the Text Import window, select appropriate columns and change >> "Column type" from Standard to Text. >> o You now have a new spreadsheet with just the appearance of your >> original one with formulae viewed. >> o Copy and paste from that. >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
