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,353 of 5,620   
   Doug G to Leonidas Jones   
   Re: Copying from Excel or Access into em   
   01 Nov 05 20:55:22   
   
   From: doug4179@comcast.net   
      
   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.   
      
   --- 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