Avatar for Username

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Teema arhiveeriti. Please ask a new question if you need help.

I lose formatting when I paste into Excel

  • 2 vastust
  • 7 on selline probleem
  • 5 views
  • Viimati vastas mtbchik

PeterG
PeterG
more options

I occasionally need to paste from formatted tables into Excel. When I do it in Firefox I lose all formatting, so I have to bring up IE, when I have no problem. Is there a way of copying formatting too?

If I copy to Word there is again no formatting.

Sample html: 

<tr>
            <td>1</td>
            <td class="centre">2</td>
            <td>Graham Gristwood</td>
            <td>Great Britain</td>
            <td>GBR</td>
            <td class="centre">M21</td>
            <td class="right">13:49</td>
          </tr>
          <tr class="alt">
            <td>2</td>
            <td class="centre">7</td>
            <td>Raffael Huber</td>
            <td>Switzerland</td>
            <td>SUI</td>

After pasting into Word: 1 2 Graham Gristwood Great Britain GBR M21 13:49 2 7 Raffael Huber Switzerland SUI

I occasionally need to paste from formatted tables into Excel. When I do it in Firefox I lose all formatting, so I have to bring up IE, when I have no problem. Is there a way of copying formatting too? If I copy to Word there is again no formatting. Sample html: <pre><nowiki><tr> <td>1</td> <td class="centre">2</td> <td>Graham Gristwood</td> <td>Great Britain</td> <td>GBR</td> <td class="centre">M21</td> <td class="right">13:49</td> </tr> <tr class="alt"> <td>2</td> <td class="centre">7</td> <td>Raffael Huber</td> <td>Switzerland</td> <td>SUI</td></nowiki></pre> After pasting into Word: 1 2 Graham Gristwood Great Britain GBR M21 13:49 2 7 Raffael Huber Switzerland SUI

Muudetud cor-el poolt

All Replies (2)

TonyE
TonyE
  • Moderator
more options

You can try the Dafizilla Table2Clipboard add-on to see if it helps.

mtbchik
mtbchik
more options

Ahhhh XML for the FIS huh?

I actually use TextPad to retain the formatting and edit.

Have you tried the SplitSecond http://splitsecond.com software which automatically generates all that you need so that you don't have to deal with Excel? It's very easy to use and has alpine, cross country and snowboard modules. Best of all, it's free unless you want to interface with the timing module.

Cheers!