// ==UserScript==
// @name PasteTable
// @namespace http://excelworld.ru/
// @require https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js
// @version 0.02
// @description Вставка таблицы word/excel в textarea из буфера обмена
// @author krosav4ig
// @include *.excelworld.ru/*
// ==/UserScript==
$(document).ready(
function(){
$("span.ucoz-forum-post").filter(function(a,b){return ($(b).html()).search(/\[\/?table[^\]]*\]/gim)!=-1}).each(function(a,b){$(b).html(($(b).html()).replace(/\[((table)[^\]]*)\]([\s\S]*?)\[\/\2\]/gim,'<div style="padding:12px;"><\x241 class="mTable-blue" align="center">\x243</\x241>').replace(/\[(\/?t[drh][^\]]*)\]/gim,'<\x241>'))})
$('#message')[0].addEventListener('paste',function(ev){var text=(ev.originalEvent||ev||window).clipboardData.getData('text/html');var DOM=$.parseHTML(text);if($.inArray($(DOM).filter('meta[name="ProgId"]').attr('content'),["Excel.Sheet","Word.Document"])<0){return!1};var Tables=$(DOM).filter('table');if(Tables.length=0){return!1}if(confirm("В буфере обмена обнаружена таблица.\nВставить как таблицу (ОК) или как обычный текст (Отмена)?")==!1){return!1}var mnem=Object.assign({34:"quot",38:"amp",39:"apos",60:"lt",62:"gt",402:"fnof",338:"OElig",339:"oelig",352:"Scaron",353:"scaron",376:"Yuml",710:"circ",732:"tilde",8226:"bull",8230:"hellip",8242:"prime",8243:"Prime",8254:"oline",8260:"frasl",8472:"weierp",8465:"image",8476:"real",8482:"trade",8501:"alefsym",8592:"larr",8593:"uarr",8594:"rarr",8595:"darr",8596:"harr",8629:"crarr",8656:"lArr",8657:"uArr",8658:"rArr",8659:"dArr",8660:"hArr",8704:"forall",8706:"part",8707:"exist",8709:"empty",8711:"nabla",8712:"isin",8713:"notin",8715:"ni",8719:"prod",8721:"sum",8722:"minus",8727:"lowast",8730:"radic",8733:"prop",8734:"infin",8736:"ang",8743:"and",8744:"or",8745:"cap",8746:"cup",8747:"int",8756:"there4",8764:"sim",8773:"cong",8776:"asymp",8800:"ne",8801:"equiv",8804:"le",8805:"ge",8834:"sub",8835:"sup",8836:"nsub",8838:"sube",8839:"supe",8853:"oplus",8855:"otimes",8869:"perp",8901:"sdot",8968:"lceil",8969:"rceil",8970:"lfloor",8971:"rfloor",9001:"lang",9002:"rang",9674:"loz",9824:"spades",9827:"clubs",9829:"hearts",9830:"diams",8194:"ensp",8195:"emsp",8201:"thinsp",8204:"zwnj",8205:"zwj",8206:"lrm",8207:"rlm",8211:"ndash",8212:"mdash",8216:"lsquo",8217:"rsquo",8218:"sbquo",8220:"ldquo",8221:"rdquo",8222:"bdquo",8224:"dagger",8225:"Dagger",8240:"permil",8249:"lsaquo",8250:"rsaquo",8364:"euro",977:"thetasym",978:"upsih",982:"piv"},[[[].concat.apply([],[[[96,17,7,25],[160,913,931,945]]].map(function(a){return Object.keys(a[0]).map(function(b){return a.map(function(c){return c[b]})})})[0].map(function(d){return Array(d[0]).fill(d[1]).map((e,f)=>e+f)})),('nbsp|iexcl|cent|pound|curren|yen|brvbar|sect|uml|copy|ordf|laquo|not|shy|reg|macr|deg|plusmn|sup2|sup3|acute|micro|para|middot|cedil|sup1|ordm|raquo|frac14|frac12|frac34|iquest|Agrave|Aacute|Acirc|Atilde|Auml|Aring|AElig|Ccedil|Egrave|Eacute|Ecirc|Euml|Igrave|Iacute|Icirc|Iuml|ETH|Ntilde|Ograve|Oacute|Ocirc|Otilde|Ouml|times|Oslash|Ugrave|Uacute|Ucirc|Uuml|Yacute|THORN|szlig|agrave|aacute|acirc|atilde|auml|aring|aelig|ccedil|egrave|eacute|ecirc|euml|igrave|iacute|icirc|iuml|eth|ntilde|ograve|oacute|ocirc|otilde|ouml|divide|oslash|ugrave|uacute|ucirc|uuml|yacute|thorn|yuml|Alpha|Beta|Gamma|Delta|Epsilon|Zeta|Eta|Theta|Iota|Kappa|Lambda|Mu|Nu|Xi|Omicron|Pi|Rho|Sigma|Tau|Upsilon|Phi|Chi|Psi|Omega|alpha|beta|gamma|delta|epsilon|zeta|eta|theta|iota|kappa|lambda|mu|nu|xi|omicron|pi|rho|sigmaf|sigma|tau|upsilon|phi|chi|psi|omega').split('|')]].map(function(x){return Object.assign(...x[0].map((g,h)=>({[g]:x[1][h]})))})[0]);var k;text=Tables[0].outerHTML.replace(/[\v\s]*<\/?(?:p|o:p|span)[^\>]*\>[\v\s]*|(?:<\/?(?:col|tbody)[^\>]*>|[\v\s]*<!--[\s\S]*?--\>)[\v\s]*|(<t[adhr](?:ble)?)(?:[^>]*?(?=(\s*[rc]o[lw]span="?\d+"?))|\2)(?:\2[^>]*?(?=(\s*[rc]o[lw]span="?\d+"?))|\3)?[^>]*?(>)|[\s\v]*(?=<\/?t[adrbh])|\s*<br>(?=(\cJ))\s*|\cJ\x20/gim,'\x241\x242\x243\x244\x245').replace(/(<\/*)a(\s*href)*/gim,'\x241url').replace(/<(\/?[ibus])(?:\s[^>]*)?>/g,'[\x241]').replace(/\&#?(\w+);/g,function(i,j){if(Number(j))return String.fromCharCode(Number(j));return String.fromCharCode($(Object.entries(mnem)).filter(function(k,l){return l[1]===j})[0][0])}).replace(/\>/g,']').replace(/</g,'[');if(text){ev.preventDefault();if((this.selectionStart)||(this.selectionStart=='0')){this.value=this.value.substring(0,this.selectionStart)+unescape(text)+this.value.substring(this.selectionEnd,this.value.length)}if(document.selection){this.focus();var sel=document.selection.createRange();sel.text=text}}},!1)
}
);
