Avatar for Username

Mozilla 도움말 검색

고객 지원 사기를 피하세요. 저희는 여러분께 절대로 전화를 걸거나 문자를 보내거나 개인 정보를 공유하도록 요청하지 않습니다. "악용 사례 신고"옵션을 사용하여 의심스러운 활동을 신고해 주세요.

자세히 살펴보기

이 쓰레드는 보존되었습니다. 만약 도움이 필요하시면 새로운 질문을 올려주세요.

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!