Re: How can I Cut and Paste Calc's Formulae Data into Thunderbird email Client?

2016-10-17 Thread Jean Lear
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  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: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>


Re: How can I Cut and Paste Calc's Formulae Data into Thunderbird email Client?

2016-10-17 Thread Vince



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: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org



Re: How can I Cut and Paste Calc's Formulae Data into Thunderbird email Client?

2016-10-16 Thread Brian Barker

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.


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.

I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org



Re: How can I Cut and Paste Calc's Formulae Data into Thunderbird email Client?

2016-10-16 Thread Julian Thomas

> On Oct 16, 2016, at 12:53, Wade Smart  wrote:
> 
> You can copy each cells formula
> but not multiple cells. I just tried it here
> and it only displays the results.

It might be useful to save the spreadsheet as a CSV file and extract the 
formulae [formulas?] from it.

 —
jt - j...@jt-mj.net

Literature encourages tolerance - bigots and fanatics seldom have any use for 
the arts, because they're so preoccupied with their beliefs and actions that 
they can't see them also as possibilities. - Northrop Frye 





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org



Re: How can I Cut and Paste Calc's Formulae Data into Thunderbird email Client?

2016-10-16 Thread Vince
TNX Steve. Right now I am not sure I can send anything via Verizon SMTP 
server.


Will try to create a portion of the spreadsheet and place it on DropBox 
for creation of a link before halftime of football game (being recorded 
now). Have not ever done that, yet! (Or, perhaps the whole nine yards.)


Regards,

VinceB.



On 10/16/2016 1:04 PM, Steven Ahlers wrote:

Vince,

You can share the spread sheet through Drop Box and put the link in an email.

Steve

Sent from my iPhone


On Oct 16, 2016, at 9:53 AM, Wade Smart  wrote:


On Sun, Oct 16, 2016 at 11:24 AM, Vince@Gmail  wrote:

I am attempting to paste a portion of a AOO 4.1.2 Calc sheet with Formulae
displayed into Thunderbird45.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.

What am I missing?

Can someone recommend a website for storage of a Print Screen for this
purpose?

Regards,

VinceB.


You can copy each cells formula
but not multiple cells. I just tried it here
and it only displays the results.


--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org



Re: How can I Cut and Paste Calc's Formulae Data into Thunderbird email Client?

2016-10-16 Thread Steven Ahlers
Vince,

You can share the spread sheet through Drop Box and put the link in an email.

Steve 

Sent from my iPhone

> On Oct 16, 2016, at 9:53 AM, Wade Smart  wrote:
> 
>> On Sun, Oct 16, 2016 at 11:24 AM, Vince@Gmail  wrote:
>> 
>> I am attempting to paste a portion of a AOO 4.1.2 Calc sheet with Formulae
>> displayed into Thunderbird45.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.
>> 
>> What am I missing?
>> 
>> Can someone recommend a website for storage of a Print Screen for this
>> purpose?
>> 
>> Regards,
>> 
>> VinceB.
> 
> 
> You can copy each cells formula
> but not multiple cells. I just tried it here
> and it only displays the results.
> 
> 
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org



Re: How can I Cut and Paste Calc's Formulae Data into Thunderbird email Client?

2016-10-16 Thread Wade Smart
On Sun, Oct 16, 2016 at 11:24 AM, Vince@Gmail  wrote:
>
> I am attempting to paste a portion of a AOO 4.1.2 Calc sheet with Formulae
> displayed into Thunderbird45.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.
>
> What am I missing?
>
> Can someone recommend a website for storage of a Print Screen for this
> purpose?
>
> Regards,
>
> VinceB.


You can copy each cells formula
but not multiple cells. I just tried it here
and it only displays the results.


--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org