home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   alt.netscape      Ahh the beloved Netscrape Crashigator      5,620 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 4,355 of 5,620   
   Leonidas Jones to Doug G   
   Re: Copying from Excel or Access into em   
   02 Nov 05 02:56:45   
   
   From: Cap1MD@att.net   
      
   Doug G wrote:   
   > Leonidas Jones wrote:   
   >> Ray wrote:   
   >>> Regardless of whether the typeface in the spreadsheet or database is   
   >>> fixed width or variable, and regardless of whether I choose fixed or   
   >>> variable as the email typeface, once I paste the selected cells into   
   >>> the email I'm composing, the columns are no longer aligned. Sometimes   
   >>> there are four blank spaces between the last character in one column   
   >>> and the first character of the next column to the right. In the two   
   >>> samples below, however, there seems to be a tab between the columns,   
   >>> but the white space varies.   
   >>>   
   >>> What's the trick to keeping the columns nicely lined up?   
   >>>   
   >>> Thanks,   
   >>>   
   >>> Ray   
   >>>   
   >>> Here's a sample from Access:   
   >>> (The column headings are: Last Name, Mar Name, First Name, Add, and   
   >>> EM. So in the first row, the second Ariel should be under MarName,   
   >>> Arthur should be under First Name, etc. In the sixth row, the Y   
   >>> should be under Add.)   
   >>>   
   >>> Last Name    MarName    First Name    Add    EM   
   >>> Airel    Airel    Arthur       Allen    Giordano    Rosemary   
   >>> Ambrosio    Ambrosio    Cesare       Amodio    Amodio   
   >>> Pasquale       Arnold    Arnold    Alfred       Asplund    Sifrit   
   >>> Barbara Ann    Y    ?   
   >>> Autenrieth    Autenrieth    Fred       Baffa    Baffa    Frank   
   >>> Bambrick    Bambrick    William E.    Y    Y   
   >>> Bange    Bange    Joyce       Barnes    Barnes    Dorothy   
   >>> Bartels    Bartels    William J.       Bass    Bass    Ralph   
   >>> Bennett    Bennett    Josephine       Berberich    Berberich   
   >>> Ronald       Bernhardt    Bernhardt    Marcia       Blair    Blair   
   >>> Ernest       Bohrman    Bohrman    Jacqueline    Y    ?   
   >>> Bolger    Gallo    Dorothy       Boucher    Boucher    Barbara   
   >>> Brosonski    Brosonski    Chester    Y    N   
   >>> Brown    Brown    Carol       Butkus    Burke    Dorothy   
   >>> Butler    Butler    Thomas       Calianese    Calianese    Mary   
   >>> Ann       Campbell    Campbell    Lawrence       Cannon    Cannon   
   >>> George       Cantor    Cantor    Howard       Carlock    Carlock   
   >>> William    Y    ?   
   >>> Cerchio    Cerchio    Gilda       Ciacciarelli    Barrett   
   >>> Gloria    Y    ?   
   >>>   
   >>> Here's a sample for Word 97 (column headings are lost, probably   
   >>> because I only selected a limited range of cells):   
   >>>   
   >>> Abrutyn    Blackman    Elayne       Airel    Airel    Arthur   
   >>> Allen    Giordano    Rosemary       Ambrosio    Ambrosio   
   >>> Cesare       Amodio    Amodio    Pasquale       Arnold    Arnold   
   >>> Alfred       Asplund    Sifrit    Barbara Ann    Y    ?   
   >>> Autenrieth    Autenrieth    Fred       Baffa    Baffa    Frank   
   >>> Bambrick    Bambrick    William       Bange    Bange    Joyce   
   >>> Barnes    Barnes    Dorothy       Bartels    Bartels    William   
   >>> J.       Bass    Bass    Ralph       Bennett    Bennett   
   >>> Josephine       Berberich    Berberich    Ronald       Bernhardt   
   >>> Bernhardt    Marcia       Blair    Blair    Ernest       Bohrman   
   >>> Bohrman    Jacqueline    Y    ?   
   >>> Bolger    Gallo    Dorothy       Boucher    Boucher    Barbara   
   >>> Brosonski    Brosonski    Chester    Y    N   
   >>> Brown    Brown    Carol       Butkus    Burke    Dorothy   
   >>> Butler    Butler    Thomas       Calianese    Calianese    Mary   
   >>> Ann       Campbell    Campbell    Lawrence       Cannon    Cannon   
   >>> George       Cantor    Cantor    Howard       Carlock    Carlock   
   >>> William    Y    ?   
   >>> Cerchio    Cerchio    Gilda       Ciacciarelli    Barrett   
   >>> Gloria    Y    ?   
   >>>   
   >>>   
   >>   
   >> Are you composing in plain text, or html?   
   >>   
   >> I always noticed this pasting from spreadsheets in plain text, and I   
   >> alway just corrected it manually.  I don;t know if it would behave   
   >> better in html, but it might.   
   >>   
   >> Lee   
   >   
   > Column alignment is retained when I use the HTML editors in Mozilla   
   > 1.7.12 and Thunderbird 1.0.7.  Leading or trailing spaces in cells can   
   > affect alignment.   
      
   Thanks Doug, that's what I suspected.   
      
   Lee   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca