Avatar for Username

搜索 | 用户支持

防范以用户支持为名的诈骗。我们绝对不会要求您拨打电话或发送短信，及提供任何个人信息。请使用“举报滥用”选项报告涉及违规的行为。

详细了解

话题已存档。 如果需要帮助请提出新问题。

I lose formatting when I paste into Excel

  • 2 个回答
  • 7 人有此问题
  • 5 次查看
  • 最后回复者为 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

由cor-el于修改

所有回复 (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!