Copying/Pasting from Excel - how to keep column alignments?

  •  01-17-2006, 7:49 PM

    Copying/Pasting from Excel - how to keep column alignments?

    Hi there,
     
    I need to be able to copy a table from Excel and paste it into the editor. This works fine but no matter what paste method I use (normal, from Word) the column alignments always default to Left, for example:

    Overseas Indicies Current +/- % Previous Trend
    Dow Jones 0,000.00 +0.0 0.0000 0.0000 Up
    NASDAQ 0,000.00 +0.0 0.0000 0.0000 Down
    S&P 500 0,000.00 +0.0 0.0000 0.0000 Sideways
    FTSE 100 0,000.00 +0.0 0.0000 0.0000
    Nikkei 225 0,000.00 +0.0 0.0000 0.0000

    All columns after the first one should be right aligned and are  in the Excel document. If I edit the HTML I can apply align=right to the columns manually. I just tried to demonstrate this here but your forums don't display it correctly anyway.
    Obviously I don't want the user to do this. 

    How can I ensure columns come through from Excel correctly? Is there an easier way to manipulate the columns when in the editor?

    Thanks

    Simon 
View Complete Thread