Important Notice: We're experiencing email notification issues. If you've posted a question in the community forums recently, please check your profile manually for responses while we're working to fix this.

Avatar for Username

חיפוש בתמיכה

יש להימנע מהונאות תמיכה. לעולם לא נבקש ממך להתקשר או לשלוח הודעת טקסט למספר טלפון או לשתף מידע אישי. נא לדווח על כל פעילות חשודה באמצעות באפשרות ״דיווח על שימוש לרעה״.

מידע נוסף

אשכול זה הועבר לארכיון. נא לשאול שאלה חדשה אם יש לך צורך בעזרה.

I lose formatting when I paste into Excel

  • 2 תגובות
  • 7 have this problem
  • 5 views
  • תגובה אחרונה מאת 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!