X
Érintse meg, ha az oldal mobil verziójára kíván váltani.

Támogatói fórum

A témacsoportot lezárták és archiválták. Tegyen fel új kérdést, ha segítségre van szüksége.

Cannot copy formatted tables

Beküldve

I use FireFox to print our EMC SAN data which is basically a table of coloured cells. I used to be able to copy & paste the data from FireFox to Excel but now with the latest version I can only copy text but not the formatting. The text is in the correct cell allignment when pasted, but the colours and table borders etc are missing.

Can I fix this?

Currently on FF 51.

I use FireFox to print our EMC SAN data which is basically a table of coloured cells. I used to be able to copy & paste the data from FireFox to Excel but now with the latest version I can only copy text but not the formatting. The text is in the correct cell allignment when pasted, but the colours and table borders etc are missing. Can I fix this? Currently on FF 51.

További rendszeradatok

Telepített bővítmények

  • ActiveTouch General Plugin Container Version 202
  • ActiveTouch General Plugin Container Version 106
  • Adobe PDF Plug-In For Firefox and Netscape 17.12.20093
  • Citrix Online App Detector Plugin
  • Fire IE DLL
  • NPRuntime Script Plug-in Library for Java(TM) Deploy
  • Next Generation Java Plug-in 10.25.2 for Mozilla browsers
  • The plugin allows you to have a better experience with Microsoft Lync
  • The plugin allows you to have a better experience with Microsoft SharePoint
  • Shockwave Flash 27.0 r0
  • Adobe Shockwave for Director Netscape plug-in, version 12.0.7.148
  • 5.1.50907.0
  • Skype for Business Web App Plug-in
  • VLC media player Web Plugin
  • VMware Remote Console Plug-in

Alkalmazás

  • Firefox 51.0.1
  • Felhasználói ügynök: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:51.0) Gecko/20100101 Firefox/51.0
  • Támogatás URL: https://support.mozilla.org/1/firefox/51.0.1/WINNT/en-GB/

Kiegészítők

  • Adblock Plus 2.9.1 ({d10d0bf8-f5b5-c8b4-a8b2-2b9879e08c5d})
  • Application Update Service Helper 1.0 (aushelper@mozilla.org)
  • Diagnostics for Adblock Plus 1.3.2 (abpwatcher@adblockplus.org)
  • Element Hiding Helper for Adblock Plus 1.4 (elemhidehelper@adblockplus.org)
  • Fire IE 0.4.6.2 (fireie@fireie.org)
  • Multi-process staged rollout 1.7 (e10srollout@mozilla.org)
  • Pocket 1.0.5 (firefox@getpocket.com)
  • RoboForm Password Manager 8.4.1.1 (rf-firefox@siber.com)
  • Tab Mix Plus 0.5.0.4 ({dc572301-7619-498c-a57d-39143191b318})
  • Web Compat 1.0 (webcompat@mozilla.org)
  • McAfee ScriptScan for Firefox 15.4.0 ({D19CA586-DD6C-4a0a-96F8-14644F340D60}) (Inaktív)
  • Open in IE 1.5.0.1-signed (openinie@wittersworld.com) (Inaktív)
  • Skype 8.3.0.9150 ({82AF8DCA-6DE9-405D-BD5E-43525BDAD38A}) (Inaktív)
  • WebEx Productivity Tools 2.0 (ocplugin@webex.com) (Inaktív)

JavaScript

  • incrementalGCEnabled: True

Kép

  • adapterDescription: Intel(R) HD Graphics 4000
  • adapterDescription2:
  • adapterDeviceID: 0x0166
  • adapterDeviceID2:
  • adapterDrivers: igdumd64 igd10umd64 igd10umd64 igdumd32 igd10umd32 igd10umd32
  • adapterDrivers2:
  • adapterRAM: Unknown
  • adapterRAM2:
  • adapterSubsysID: 17a7103c
  • adapterSubsysID2:
  • adapterVendorID: 0x8086
  • adapterVendorID2:
  • clearTypeParameters: Gamma: 2.2 Pixel Structure: RGB ClearType Level: 100 Enhanced Contrast: 50
  • crashGuards: []
  • currentAudioBackend: wasapi
  • direct2DEnabled: True
  • directWriteEnabled: True
  • directWriteVersion: 6.2.9200.22164
  • driverDate: 3-26-2012
  • driverDate2:
  • driverVersion: 8.15.10.2712
  • driverVersion2:
  • failures: [u'[GFX1]: [D3D11] 2 CreateTexture2D failure Size(1903,1065) Code: 0x8007000e', u'[GFX1]: Failed 2 buffer db=00000000 dw=00000000 for 0, 0, 1903, 1065', u'[GFX1]: [D3D11] 2 CreateTexture2D failure Size(1903,1065) Code: 0x8007000e', u'[GFX1]: Failed 2 buffer db=00000000 dw=00000000 for 0, 0, 1903, 1065', u'[GFX1]: [D3D11] 2 CreateTexture2D failure Size(1508,880) Code: 0x8007000e', u'[GFX1]: [D3D11] 2 CreateTexture2D failure Size(1903,1065) Code: 0x8007000e', u'[GFX1]: Failed 2 buffer db=00000000 dw=00000000 for 0, 0, 1903, 1065', u'[GFX1]: [D3D11] 2 CreateTexture2D failure Size(1903,1065) Code: 0x8007000e', u'[GFX1]: Failed 2 buffer db=00000000 dw=00000000 for 0, 0, 1903, 1065']
  • featureLog: {u'fallbacks': [], u'features': [{u'status': u'available', u'description': u'Compositing', u'log': [{u'status': u'available', u'type': u'default'}], u'name': u'HW_COMPOSITING'}, {u'status': u'available', u'description': u'Direct3D11 Compositing', u'log': [{u'status': u'available', u'type': u'default'}], u'name': u'D3D11_COMPOSITING'}, {u'status': u'disabled', u'description': u'Direct3D9 Compositing', u'log': [{u'status': u'disabled', u'message': u'Disabled by default', u'type': u'default'}], u'name': u'D3D9_COMPOSITING'}, {u'status': u'available', u'description': u'Direct2D', u'log': [{u'status': u'available', u'type': u'default'}], u'name': u'DIRECT2D'}, {u'status': u'available', u'description': u'Direct3D11 hardware ANGLE', u'log': [{u'status': u'available', u'type': u'default'}], u'name': u'D3D11_HW_ANGLE'}]}
  • indices: [0, 1, 2, 3, 4, 5, 6, 7, 8]
  • info: {u'AzureCanvasAccelerated': 0, u'AzureCanvasBackend': u'direct2d 1.1', u'AzureFallbackCanvasBackend': u'cairo', u'AzureContentBackend': u'direct2d 1.1'}
  • isGPU2Active: False
  • numAcceleratedWindows: 1
  • numTotalWindows: 1
  • supportsHardwareH264: No; Hardware video decoding disabled or blacklisted
  • webgl2Renderer: Google Inc. -- ANGLE (Intel(R) HD Graphics 4000 Direct3D11 vs_5_0 ps_5_0)
  • webglRenderer: Google Inc. -- ANGLE (Intel(R) HD Graphics 4000 Direct3D11 vs_5_0 ps_5_0)
  • windowLayerManagerRemote: True
  • windowLayerManagerType: Direct3D 11

Módosított tulajdonságok

Egyéb

  • Felhasználói JS: Nem
  • Akadálymentesítés: Igen
jscher2000
  • Top 10 Contributor
8893 megoldás 72765 válasz

What you are describing is normal in my experience for as long as I can remember. When you copy a selection in a Windows application, the application puts several different formats on the clipboard. You are getting HTML, but it does not have the styles you expected. Usually that's because the styles are in a style sheet outside of the selection. Firefox will include styles that are "inline" in the copied HTML, but if they are outside, then the styles are not copied along with the HTML and it ends up having the default appearance instead. This is a tricky problem to work around because often you do not want to copy the entire page and then have to clean up the paste.

Also, not that it helps with this problem, but "the latest version" is not Firefox 51, but Firefox 56.

What you are describing is normal in my experience for as long as I can remember. When you copy a selection in a Windows application, the application puts several different formats on the clipboard. You are getting HTML, but it does not have the styles you expected. Usually that's because the styles are in a style sheet outside of the selection. Firefox will include styles that are "inline" in the copied HTML, but if they are outside, then the styles are not copied along with the HTML and it ends up having the default appearance instead. This is a tricky problem to work around because often you do not want to copy the entire page and then have to clean up the paste. Also, not that it helps with this problem, but "the latest version" is not Firefox 51, but Firefox 56.
jscher2000
  • Top 10 Contributor
8893 megoldás 72765 válasz

Two other things:

(1) Many Microsoft applications give you options when you paste, or a Paste Special command. You can use one of those to ensure that you are pasting the HTML. (Example screenshot attached.)

(2) It sometimes gives better results to use Excel's Data tab, From Web feature, to open a page and import a table. This is intermediated by components of Internet Explorer, so if the page doesn't work in IE, that may not work, either.

Two other things: (1) Many Microsoft applications give you options when you paste, or a Paste Special command. You can use one of those to ensure that you are pasting the HTML. (Example screenshot attached.) (2) It sometimes gives better results to use Excel's Data tab, From Web feature, to open a page and import a table. This is intermediated by components of Internet Explorer, so if the page doesn't work in IE, that may not work, either.