Community Discussions and Support
Column width lost when copying Excel spread content to a message

[quote user="PaulW"]Do you mean being altered when they forward/reply to it?  I can't quite imagine why your mesage should be changed in that instance. [/quote]

The wrapping of cell content is the major issue but I will copy table content out a message for pasting into Excel so picture that being done by my message recipients as well.

[quote user="PaulW"]Is creating your own table using Pegasus' html capability too long-winded to be of use?[/quote]

Yes.  Six columns, often +30 rows. 

 

<p>[quote user="PaulW"]Do you mean being altered when they forward/reply to it?  I can't quite imagine why <b>your</b> mesage should be changed in that instance. [/quote]</p><p>The wrapping of cell content is the major issue but I will copy table content out a message for pasting into Excel so picture that being done by my message recipients as well. </p><p mce_keep="true">[quote user="PaulW"]Is creating your own table using Pegasus' html capability too long-winded to be of use?[/quote]</p><p mce_keep="true">Yes.  Six columns, often +30 rows.  </p><p mce_keep="true"> </p>

I often have the need to insert the region of an Excel spread into a new message (from template).  Copy/paste works but column width is lost requiring manual manipulation in the message.  Does anyone know of a work around? 

Spreadsheet content is being added to the body of the message as supporting detail. Sending an attachment is not an option. 

TIA!

 

<p>I often have the need to insert the region of an Excel spread into a new message (from template).  Copy/paste works but column width is lost requiring manual manipulation in the message.  Does anyone know of a work around?  </p><p>Spreadsheet content is being added to the body of the message as supporting detail. Sending an attachment is not an option.  </p><p>TIA!</p><p> </p>

Brian,

   Have you checked out what sorts of data formats are available on the clipboard once you have copied the cells from Excel to the clipboard ?  I don't have Excel, but I have LibreOffice.

I suspect you will see alternative formats to the cells, ie Excel, or plain text, or perhaps even html   You would need to attempt a Paste Special to be given a list of formats on the clipboard.

HTH

Martin

<p>Brian,</p><p>   Have you checked out what sorts of data formats are available on the clipboard once you have copied the cells from Excel to the clipboard ?  I don't have Excel, but I have LibreOffice. </p><p>I suspect you will see alternative formats to the cells, ie Excel, or plain text, or perhaps even html   You would need to attempt a Paste Special to be given a list of formats on the clipboard.</p><p>HTH</p><p>Martin </p>

Martin,

I have the "always paste plain text" option enable so must always use Paste Special but within Pmail the options always the same, formatted text and the three plain text options.  I have Libre office here at home so tested a paste and found the column width was maintained but not the font.  The font in the spread is Arial 10 as is the new message font in Pmail but the pasted font is Arial 12.  I hadn't noticed a font change at the office so will need to look at that.  Who knows what is going on with the column widths.

 

<p>Martin,</p><p>I have the "always paste plain text" option enable so must always use Paste Special but within Pmail the options always the same, formatted text and the three plain text options.  I have Libre office here at home so tested a paste and found the column width was maintained but not the font.  The font in the spread is Arial 10 as is the new message font in Pmail but the pasted font is Arial 12.  I hadn't noticed a font change at the office so will need to look at that.  Who knows what is going on with the column widths.</p><p> </p>

I usually take a screen grab and post it as an image - that way you know the formatting won't be changed for the reader.

I usually take a screen grab and post it as an image - that way you know the formatting won't be changed for the reader.

This is business correspondence so my preference is for the table to be clear and capable of manipulation by the recipient. 

The one thing that makes the manual column width adjustments overly tedious is that when adjusting a left column the right columns don't slide requiring that column widths be adjusted from right to left and if you mis-guess on the overall table size needed you have to start with the right most column again.

 

 

<p>This is business correspondence so my preference is for the table to be clear and capable of manipulation by the recipient.  </p><p>The one thing that makes the manual column width adjustments overly tedious is that when adjusting a left column the right columns don't slide requiring that column widths be adjusted from right to left and if you mis-guess on the overall table size needed you have to start with the right most column again.</p><p> </p><p> </p>

[quote user="Brian Fluet"]

This is business correspondence so my preference is for the table to be clear and capable of manipulation by the recipient.[/quote]

Do you mean being altered when they forward/reply to it?  I can't quite imagine why your mesage should be changed in that instance. 

[quote]The one thing that makes the manual column width adjustments overly tedious is that when adjusting a left column the right columns don't slide requiring that column widths be adjusted from right to left and if you mis-guess on the overall table size needed you have to start with the right most column again.

[/quote]

Is creating your own table using Pegasus' html capability too long-winded to be of use?

[quote user="Brian Fluet"] <P>This is business correspondence so my preference is for the table to be clear and capable of manipulation by the recipient.[/quote]</P> <P>Do you mean being altered when they forward/reply to it?  I can't quite imagine why <STRONG>your</STRONG> mesage should be changed in that instance.  </P> <P>[quote]The one thing that makes the manual column width adjustments overly tedious is that when adjusting a left column the right columns don't slide requiring that column widths be adjusted from right to left and if you mis-guess on the overall table size needed you have to start with the right most column again.</P> <P mce_keep="true">[/quote]</P> <P mce_keep="true">Is creating your own table using Pegasus' html capability too long-winded to be of use?</P>
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft