123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116 |
- Namespace.register("U.MD.O.E.RC");
- U.MD.O.E.RC.addLine = function (checkdCell, lineNum, req) {
- var _excel = U.MD.O.E,
- _cellBox = $(".U_MD_O_E_cellBox")[0],
- _rBList = U.UF.C.toArray($(".U_MD_O_E_row")),
- _cBList = U.UF.C.toArray($(".U_MD_O_E_column")),
- _cellList = U.UF.C.toArray($(".U_MD_O_E_cell")),
- _rBBox = $(".U_MD_O_E_rowBoard")[0],
- _cellLast = checkdCell,
- _rowNum = _cellLast.row,
- _rBoardCurrent = $(".U_MD_O_E_row")[_rowNum - 1],
- _rBoardNext,
- _rBLen = _rBList.length,
- _rowNext,
- _height,
- _top,
- _frag = $$("frag"),
- _mergeCellList,
- _newEl,
- _iRowCell,
- _colName,
- _rowName,
- _newRow,
- _newrB,
- _rowRule,
- _mergeId,
- _addHeight,
- _mergeChangeArr = [],
- i,
- j;
- if (_rowNum < _rBLen) {
- _rBoardNext = $(".U_MD_O_E_row")[_rowNum];
- _rowNext = _cellList.filter(function (el) {
- return +(el.row) === (_rowNum + 1);
- });
- _height = _rBoardNext.offsetHeight;
- _top = _rBoardNext.offsetTop;
- } else {
- _rBoardNext = _rBoardCurrent;
- _rowNext = _cellList.filter(function (el) {
- return +(el.row) === (_rowNum);
- });
- _height = _rBoardCurrent.offsetHeight;
- _top = _rBoardCurrent.offsetTop;
- }
- _addHeight = _height * lineNum;
- _rowNext.forEach(function (el) {
- _colName = +(el.col);
- _rowName = +(el.row);
- var lineLen;
- if (_rowNum < _rBLen) {
- i = 0;
- lineLen = lineNum;
- } else {
- i = 1;
- lineLen = lineNum + 1;
- }
- var _newEl = el.cloneNode(),
- _mergeArr,
- _mergeEl;
- if (el.s_mergerow === _rowName) {
- _mergeId = el.s_merge;
- _newEl.style.display = "block";
- _newEl.style.height = _height + "px";
- _newEl.style.width = _cBList[_colName - 1].offsetWidth + "px";
- $(_newEl).eRmAttr("s_mergecol");
- $(_newEl).eRmAttr("s_mergerow");
- $(_newEl).eRmAttr("e_mergecol");
- $(_newEl).eRmAttr("e_mergerow");
- $(_newEl).eRmAttr("s_merge");
- $(_newEl).eRmAttr("e_merge");
- }
- if (el.s_merge && _mergeId !== el.s_merge) {
- _mergeId = el.s_merge;
- _mergeEl = $("#" + _mergeId)[0];
- _mergeEl.style.height = _mergeEl.offsetHeight + _addHeight + "px";
- _mergeArr = _cellList.filter(function (el) {
- return el.s_merge === _mergeId;
- });
- _mergeArr.forEach(function (el) {
- $(el).eAttr("e_mergerow", el.e_mergerow + lineNum);
- $(el).eAttr("e_merge", "POS_" + el.e_mergecol + "_" + el.e_mergerow);
- });
- var temp = {
- col: el.s_mergecol,
- row: el.s_mergerow
- };
- _mergeChangeArr.push(temp);
- }
- for (; i < lineLen; i++) {
- _newEl = _newEl.cloneNode();
- if (el.s_merge && el.s_mergerow !== _rowName) {
- $(_newEl).eAttr("s_merge", el.s_merge);
- $(_newEl).eAttr("s_mergerow", el.s_mergerow);
- $(_newEl).eAttr("s_mergecol", el.s_mergecol);
- $(_newEl).eAttr("e_mergerow", el.e_mergerow);
- $(_newEl).eAttr("e_mergecol", el.e_mergecol);
- $(_newEl).eAttr("e_merge", "POS_" + _newEl.e_mergecol + "_" + _newEl.e_mergerow);
- }
- _newEl.style.top = _top + _height * i + "px";
- _newRow = _rowName + i;
- $(_newEl).eAttr("row", _newRow);
- _newEl.col = _colName;
- _newEl.id = "POS_" + _colName + "_" + _newRow;
- U.MD.O.E.BC.Focus(_newEl);
- U.MD.O.E.BC.dragCheckd(_newEl);
- _frag.appendChild(_newEl);
- }
- });
- for (i = 0; i < lineNum; i++) {
- _newrB = _rBoardNext.cloneNode(true);
- _newrB.firstChild.textContent = +(_rBoardCurrent.innerText) + 1;
- $(_newrB).eAttr("rowname", +(_rBoardCurrent.innerText) + 1);
- _rowRule = $(_newrB).find(".U_MD_O_E_rowRule");
- U.MD.O.E.BC.rowExpanding(_rowRule);
- U.MD.O.E.BC.rBoardChecked(_newrB);
- _excel.After(_rBoardCurrent, _newrB);
- _rBoardCurrent = _newrB;
- };
- for (i = _rowNum + 1; i <= _rBLen; i++) {
- _rBList[i - 1].firstChild.textContent = i + lineNum;
- $(_rBList[i - 1]).eAttr("rowname", i + lineNum)
- _iRowCell = _cellList.filter(function (el) {
- return (+(el.row) === i && (el.parentNode.nodeType !== 11));
- });
- _top = _rBList[i - 1].offsetTop;
- _iRowCell.forEach(function (el) {
- _frag.appendChild(el);
- el.style.top = _top + "px";
- _colName = el.col;
- _newRow = +(i + lineNum);
- el.id = "POS_" + _colName + "_" + _newRow;
- $(el).eAttr("row", _newRow);
- })
- }
- _cellBox.appendChild(_frag);
- _mergeCellList = _cellList.filter(function (el) {
- return +(el.s_mergerow) > _rowNum;
- });
- _mergeCellList.forEach(function (el) {
- $(el).eAttr("s_mergerow", el.s_mergerow + lineNum);
- $(el).eAttr("e_mergerow", el.e_mergerow + lineNum);
- $(el).eAttr("s_merge", "POS_" + el.s_mergecol + "_" + el.s_mergerow);
- $(el).eAttr("e_merge", "POS_" + el.e_mergecol + "_" + el.e_mergerow);
- });
- var _data = {
- start: _rowNum,
- lineNum: lineNum,
- sizeChange: (_rBoardNext.offsetHeight === U.MD.O.E.rowBoardHeight ? false : _rBoardNext.offsetHeight),
- mergeArr: _mergeChangeArr
- };
- U.MD.O.E.dataChange(U.MD.O.E.excelInfo("addLine", _data), req);
- }
- U.MD.O.E.RC.removeLine = function (startCell, endCell, req) {
- var _excel = U.MD.O.E,
- _cellList = U.UF.C.toArray($(".U_MD_O_E_cell")),
- _rBList = $(".U_MD_O_E_row"),
- _rBBox = $(".U_MD_O_E_rowBoard")[0],
- _rBLen = _rBList.length,
- _startNum = +(startCell.row),
- _endNum = +(endCell.row),
- _rmNum = _endNum - _startNum + 1,
- _iRowCell,
- _rBEl,
- _newRowNum,
- _mergeCellList,
- _colName,
- _mergeId,
- s_mergerow,
- e_mergerow,
- s_mergecol,
- e_mergecol,
- _mergeArr = [],
- _mergeChangeArr = [],
- _mergeInfo,
- _mergeNum,
- _top,
- i;
- for (i = _startNum; i <= _endNum; i++) {
- _rBList[i - 1].remove();
- _iRowCell = _cellList.filter(function (el) {
- return +(el.row) === i;
- })
- _iRowCell.forEach(function (el) {
- if (el.s_merge && (_mergeId !== el.s_merge)) {
- _mergeId = el.s_merge;
- s_mergerow = el.s_mergerow;
- e_mergerow = el.e_mergerow;
- s_mergecol = el.s_mergecol;
- e_mergecol = el.e_mergecol;
- if (_startNum <= s_mergerow && _endNum >= e_mergerow) {
- el.remove();
- return; 返回
- }
-
- if ((_startNum <= s_mergerow && _endNum >= s_mergerow)) {
- _mergeNum = _endNum - s_mergerow + 1
- s_mergerow = s_mergerow + _mergeNum - _rmNum;
- e_mergerow = e_mergerow - _rmNum;
- _mergeInfo = {
- smergeId: "POS_" + s_mergecol + "_" + s_mergerow,
- emergeId: "POS_" + e_mergecol + "_" + e_mergerow,
- row: s_mergerow,
- col: s_mergecol,
- endRow: e_mergerow,
- endCol: e_mergecol
- };
- _mergeArr.push(_mergeInfo);
- } else if (_startNum <= e_mergerow && _endNum >= e_mergerow) {
- _mergeNum = e_mergerow - _startNum + 1;
- e_mergerow = e_mergerow - _mergeNum;
- _mergeInfo = {
- smergeId: "POS_" + s_mergecol + "_" + s_mergerow,
- emergeId: "POS_" + e_mergecol + "_" + e_mergerow,
- row: s_mergerow,
- col: s_mergecol,
- endRow: e_mergerow,
- endCol: e_mergecol
- };
- _mergeArr.push(_mergeInfo);
- } else if (_startNum > s_mergerow && _endNum < e_mergerow) {
- e_mergerow = e_mergerow - _rmNum;
- _mergeInfo = {
- smergeId: "POS_" + s_mergecol + "_" + s_mergerow,
- emergeId: "POS_" + e_mergecol + "_" + e_mergerow,
- row: s_mergerow,
- col: s_mergecol,
- endRow: e_mergerow,
- endCol: e_mergecol
- };
- _mergeArr.push(_mergeInfo);
- }
- var _splitCells = $("#" + _mergeId)[0];
- _excel.RC.splitCells(_splitCells, true);
- }
- el.remove();
- });
- }
- for (i = _endNum + 1; i <= _rBLen; i++) {
- _rBEl = _rBList[i - 1];
- _newRowNum = +(_rBEl.innerText) - _rmNum;
- _rBEl.firstChild.textContent = _newRowNum;
- $(_rBEl).eAttr("rowname", _newRowNum);
- _iRowCell = _cellList.filter(function (el) {
- return +(el.row) === i;
- })
- _top = _rBEl.offsetTop;
- _iRowCell.forEach(function (el) {
- el.style.top = _top + "px";
- $(el).eAttr("row", _newRowNum);
- _colName = el.col;
- el.id = "POS_" + _colName + "_" + _newRowNum;
- });
- }
- _mergeCellList = _cellList.filter(function (el) {
- return +(el.s_mergerow) > _startNum;
- });
- _mergeCellList.forEach(function (el) {
- $(el).eAttr("s_mergerow", el.s_mergerow - _rmNum);
- $(el).eAttr("e_mergerow", el.e_mergerow - _rmNum);
- $(el).eAttr("s_merge", "POS_" + el.s_mergecol + "_" + el.s_mergerow);
- $(el).eAttr("e_merge", "POS_" + el.e_mergecol + "_" + el.e_mergerow);
- });
- console.log(_mergeArr);
- var smergeCell,
- emergeCell;
- _mergeArr.forEach(function (json) {
- smergeCell = $("#" + json.smergeId)[0];
- emergeCell = $("#" + json.emergeId)[0];
- _excel.RC.mergeCells(smergeCell, emergeCell, true);
- json.content = smergeCell.innerHTML;
- });
- var _data = {
- start: _startNum,
- end: _endNum,
- lineNum: _rmNum,
- mergeArr: _mergeArr
- };
- U.MD.O.E.dataChange(U.MD.O.E.excelInfo("delLine", _data), req);
- };
- U.MD.O.E.RC.addCol = function (checkdCell, colNums, req) {
- var _excel = U.MD.O.E,
- _cellBox = $(".U_MD_O_E_cellBox")[0],
- _cellList = U.UF.C.toArray($(".U_MD_O_E_cell")),
- _rBList = $(".U_MD_O_E_row"),
- _cBList = $(".U_MD_O_E_column"),
- _cBBox = $(".U_MD_O_E_colBoard")[0],
- _cellLast = checkdCell,
- _colNum = _cellLast.col,
- _cBoardCurrent = $(".U_MD_O_E_column")[_colNum - 1],
- _cBoardNext,
- _colNext,
- _cBLen = _cBList.length,
- _width,
- _left,
- _frag = $$("frag"),
- _newEl,
- _addWidth,
- _iColCell,
- _mergeChangeArr = [],
- _rowName,
- _mergeCellList,
- _mergeId,
- _newCol,
- _newcB,
- _colRule,
- _colName,
- i,
- j;
- if (_colNum < _cBLen) {
- _cBoardNext = $(".U_MD_O_E_column")[_colNum];
- _colNext = _cellList.filter(function (el) {
- return +(el.col) === (_colNum + 1);
- });
- _width = _cBoardNext.offsetWidth;
- _left = _cBoardNext.offsetLeft;
- } else {
- _cBoardNext = _cBoardCurrent
- _colNext = _cellList.filter(function (el) {
- return +(el.col) === (_colNum);
- });
- _width = _cBoardCurrent.offsetWidth;
- _left = _cBoardCurrent.offsetLeft;
- }
- _addWidth = _width * colNums,
- _cBBox.style.width = _cBBox.offsetWidth + _addWidth + "px";
- _colNext.forEach(function (el) {
- _rowName = +(el.row);
- _colName = +(el.col);
- var colLen;
- if (_colNum < _cBLen) {
- i = 0;
- colLen = colNums;
- } else {
- i = 1;
- colLen = colNums + 1;
- }
- var _newEl = el.cloneNode(),
- _mergeArr,
- _mergeEl;
- if (el.s_mergecol === _colName) {
- _mergeId = el.s_merge;
- _newEl.style.display = "block";
- _newEl.style.width = _width + "px";
- _newEl.style.height = _rBList[_rowName - 1].offsetHeight + "px";
- $(_newEl).eRmAttr("s_mergecol");
- $(_newEl).eRmAttr("s_mergerow");
- $(_newEl).eRmAttr("e_mergecol");
- $(_newEl).eRmAttr("e_mergerow");
- $(_newEl).eRmAttr("s_merge");
- $(_newEl).eRmAttr("e_merge");
- }
- if (el.s_merge && el.s_merge !== _mergeId) {
- _mergeId = el.s_merge;
- _mergeEl = $("#" + _mergeId)[0];
- _mergeEl.style.width = _mergeEl.offsetWidth + _addWidth + "px";
- _mergeArr = _cellList.filter(function (el) {
- return el.s_merge === _mergeId;
- })
- _mergeArr.forEach(function (el) {
- $(el).eAttr("e_mergecol", el.e_mergecol + colNums);
- $(el).eAttr("e_merge", "POS_" + el.e_mergecol + "_" + el.e_mergerow);
- });
- var temp = {
- col: el.s_mergecol,
- row: el.s_mergerow
- };
- _mergeChangeArr.push(temp);
- }
- for (; i < colLen; i++) {
- _newEl = _newEl.cloneNode();
- if (el.s_mergecol && el.s_mergecol !== _colName) {
- $(_newEl).eAttr("s_merge", el.s_merge);
- $(_newEl).eAttr("s_mergerow", el.s_mergerow);
- $(_newEl).eAttr("s_mergecol", el.s_mergecol);
- $(_newEl).eAttr("e_mergerow", el.e_mergerow);
- $(_newEl).eAttr("e_mergecol", el.e_mergecol);
- $(_newEl).eAttr("e_merge", "POS_" + _newEl.e_mergecol + "_" + _newEl.e_mergerow);
- }
- _newEl.style.left = _left + _width * i + "px";
- _newCol = _colName + i;
- $(_newEl).eAttr("col", _newCol);
- _newEl.row = el.row;
- _newEl.id = "POS_" + _newCol + "_" + _rowName;
- U.MD.O.E.BC.Focus(_newEl);
- U.MD.O.E.BC.dragCheckd(_newEl);
- _frag.appendChild(_newEl);
- }
- });
- for (i = 0; i < colNums; i++) {
- _newcB = _cBoardNext.cloneNode(true);
- _colName = +(_cBoardCurrent.colname);
- _newcB.firstChild.textContent = _excel.fromCharCode(_colName + 1);
- $(_newcB).eAttr("colname", _colName + 1);
- _colRule = $(_newcB).find(".U_MD_O_E_colRule");
- U.MD.O.E.BC.colExpanding(_colRule);
- U.MD.O.E.BC.cBoardChecked(_newcB);
- _excel.After(_cBoardCurrent, _newcB);
- _cBoardCurrent = _newcB;
- };
- for (i = _colNum + 1; i <= _cBLen; i++) {
- _cBList[i - 1].firstChild.textContent = _excel.fromCharCode(i + colNums);
- $(_cBList[i - 1]).eAttr("colname", i + colNums)
- _iColCell = _cellList.filter(function (el) {
- return (+(el.col) === i) && el.parentNode.nodeType !== 11;
- })
- _left = _cBList[i - 1].offsetLeft;
- _iColCell.forEach(function (el) {
- _frag.appendChild(el);
- el.style.left = _left + "px";
- _rowName = el.row;
- _newCol = +(i + colNums);
- el.id = "POS_" + _newCol + "_" + _rowName;
- $(el).eAttr("col", _newCol);
- })
- }
- _cellBox.appendChild(_frag);
- _mergeCellList = _cellList.filter(function (el) {
- return +(el.s_mergecol) > _colNum;
- });
- _mergeCellList.forEach(function (el) {
- $(el).eAttr("s_mergecol", el.s_mergecol + colNums);
- $(el).eAttr("e_mergecol", el.e_mergecol + colNums);
- $(el).eAttr("s_merge", "POS_" + el.s_mergecol + "_" + el.s_mergerow);
- $(el).eAttr("e_merge", "POS_" + el.e_mergecol + "_" + el.e_mergerow);
- });
- var _data = {
- start: _colNum,
- colNums: colNums,
- sizeChange: (_cBoardNext.offsetWidth === U.MD.O.E.colBoardWidth ? false : _cBoardNext.offsetWidth),
- mergeArr: _mergeChangeArr
- };
- U.MD.O.E.dataChange(U.MD.O.E.excelInfo("addCol", _data), req);
- }
- U.MD.O.E.RC.removeCol = function (startCell, endCell, req) {
- var _excel = U.MD.O.E,
- _cellList = U.UF.C.toArray($(".U_MD_O_E_cell")),
- _cBList = $(".U_MD_O_E_column"),
- _cBBox = $(".U_MD_O_E_colBoard")[0],
- _cBLen = _cBList.length,
- _startNum = +(startCell.col),
- _endNum = +(endCell.col),
- _rmNum = _endNum - _startNum + 1,
- _rmWidth = 0,
- _cellList,
- _cBEl,
- _newColNum,
- _iColCell,
- _mergeId,
- _mergeCellList,
- _mergeArr = [],
- _rowName,
- _left,
- i;
- for (i = _startNum; i <= _endNum; i++) {
- _rmWidth += _cBList[i - 1].offsetWidth;
- _cBList[i - 1].remove();
- _iColCell = _cellList.filter(function (el) {
- return +(el.col) === i;
- });
- _iColCell.forEach(function (el) {
- if (el.s_merge && (_mergeId !== el.s_merge)) {
- _mergeId = el.s_merge;
- s_mergerow = el.s_mergerow;
- e_mergerow = el.e_mergerow;
- s_mergecol = el.s_mergecol;
- e_mergecol = el.e_mergecol;
- if (_startNum <= s_mergecol && _endNum >= e_mergecol) {
- el.remove();
- return;
- }
-
- if ((_startNum <= s_mergecol && _endNum >= s_mergecol)) {
- _mergeNum = _endNum - s_mergecol + 1
- s_mergecol = s_mergecol + _mergeNum - _rmNum;
- e_mergecol = e_mergecol - _rmNum;
- _mergeInfo = {
- smergeId: "POS_" + s_mergecol + "_" + s_mergerow,
- emergeId: "POS_" + e_mergecol + "_" + e_mergerow,
- row: s_mergerow,
- col: s_mergecol,
- endRow: e_mergerow,
- endCol: e_mergecol
- };
- _mergeArr.push(_mergeInfo);
- console.log(1);
- } else if (_startNum <= e_mergecol && _endNum >= e_mergecol) {
- _mergeNum = e_mergecol - _startNum + 1;
- e_mergecol = e_mergecol - _mergeNum;
- _mergeInfo = {
- smergeId: "POS_" + s_mergecol + "_" + s_mergerow,
- emergeId: "POS_" + e_mergecol + "_" + e_mergerow,
- row: s_mergerow,
- col: s_mergecol,
- endRow: e_mergerow,
- endCol: e_mergecol
- };
- _mergeArr.push(_mergeInfo);
- console.log(2);
- } else if (_startNum > s_mergecol && _endNum < e_mergecol) {
- e_mergecol = e_mergecol - _rmNum;
- _mergeInfo = {
- smergeId: "POS_" + s_mergecol + "_" + s_mergerow,
- emergeId: "POS_" + e_mergecol + "_" + e_mergerow,
- row: s_mergerow,
- col: s_mergecol,
- endRow: e_mergerow,
- endCol: e_mergecol
- };
- _mergeArr.push(_mergeInfo);
- console.log(3);
- }
- var _splitCells = $("#" + _mergeId)[0];
- _excel.RC.splitCells(_splitCells, true);
- }
- el.remove();
- });
- }
- for (i = _endNum + 1; i <= _cBLen; i++) {
- _cBEl = _cBList[i - 1];
- _newColNum = +(_cBEl.colname) - _rmNum;
- _cBEl.firstChild.textContent = _excel.fromCharCode(_newColNum);
- $(_cBEl).eAttr("colname", _newColNum);
- _iColCell = _cellList.filter(function (el) {
- return +(el.col) === i;
- });
- _left = _cBEl.offsetLeft;
- _iColCell.forEach(function (el) {
- el.style.left = _left + "px";
- $(el).eAttr("col", _newColNum);
- _rowName = el.row;
- el.id = "POS_" + _newColNum + "_" + _rowName;
- });
- }
- _cBBox.style.width = _cBBox.offsetWidth - _rmWidth + "px";
- _mergeCellList = _cellList.filter(function (el) {
- return +(el.s_mergecol) > _startNum;
- });
- _mergeCellList.forEach(function (el) {
- $(el).eAttr("s_mergecol", el.s_mergecol - _rmNum);
- $(el).eAttr("e_mergecol", el.e_mergecol - _rmNum);
- $(el).eAttr("s_merge", "POS_" + el.s_mergecol + "_" + el.s_mergerow);
- $(el).eAttr("e_merge", "POS_" + el.e_mergecol + "_" + el.e_mergerow);
- });
- var smergeCell,
- emergeCell;
- _mergeArr.forEach(function (json) {
- smergeCell = $("#" + json.smergeId)[0];
- emergeCell = $("#" + json.emergeId)[0];
- _excel.RC.mergeCells(smergeCell, emergeCell, true);
- json.content = smergeCell.innerHTML;
- })
- var _data = {
- start: _startNum,
- end: _endNum,
- colNums: _rmNum,
- mergeArr: _mergeArr
- };
- U.MD.O.E.dataChange(U.MD.O.E.excelInfo("delCol", _data), req);
- }
- U.MD.O.E.RC.splitCells = function (cell, dataChange, req) {
- if (!(cell.s_merge)) return;
- var _excel = U.MD.O.E,
- _cellList = U.UF.C.toArray($(".U_MD_O_E_cell")),
- _startX = +(cell.col),
- _startY = +(cell.row),
- _endX = +(cell.e_mergecol),
- _endY = +(cell.e_mergerow),
- _width = $(".U_MD_O_E_column")[_startX - 1].offsetWidth,
- _height = $(".U_MD_O_E_row")[_startY - 1].offsetHeight,
- _id,
- _cell,
- i,
- j;
- cell.edited = true;
- for (i = _startX; i <= _endX; i++) {
- for (j = _startY; j <= _endY; j++) {
- _id = "POS_" + i + "_" + j;
- _cell = $("#" + _id)[0];
- _cell.style.display = "block";
- $(_cell).eRmAttr("s_mergecol");
- $(_cell).eRmAttr("s_mergerow");
- $(_cell).eRmAttr("e_mergecol");
- $(_cell).eRmAttr("e_mergerow");
- $(_cell).eRmAttr("s_merge");
- $(_cell).eRmAttr("e_merge");
- }
- }
- cell.style.width = _width + "px";
- cell.style.height = _height + "px";
- if (dataChange) return;
- var _data = {
- col: _startX,
- row: _startY
- };
- U.MD.O.E.dataChange(U.MD.O.E.excelInfo("splitCells", _data), req);
- };
- U.MD.O.E.RC.mergeCells = function (startCell, endCell, dataChange, req) {
- var _excel = U.MD.O.E;
- if (!startCell || !endCell || endCell === startCell) return;
- var _startCell = startCell,
- _startcol = _startCell.col,
- _startrow = +(_startCell.row),
- _endCell = endCell,
- _endcol = +(_endCell.col),
- _endrow = +(_endCell.row),
- _mergeWidth = 0,
- _mergeHeight = 0,
- _crossCol = _endcol - _startcol + 1,
- _crossRow = _endrow - _startrow + 1,
- _cellList = U.UF.C.toArray($(".U_MD_O_E_cell")),
- _checkCellList,
- _cBList = $(".U_MD_O_E_column"),
- _rBList = $(".U_MD_O_E_row"),
- _cell,
- i,
- _cellcol,
- _cellrow,
- len = _cellList.length;
- _startCell.edited = true;
- for (i = _startcol; i <= _endcol; i++) {
- _mergeWidth += _cBList[i - 1].offsetWidth;
- }
- for (i = _startrow; i <= _endrow; i++) {
- _mergeHeight += _rBList[i - 1].offsetHeight;
- }
- _checkCellList = _cellList.filter(function (el) {
- _cellcol = +(el.col);
- _cellrow = +(el.row);
- return (_cellcol >= _startcol && _cellcol <= _endcol) && (_cellrow >= _startrow && _cellrow <= _endrow);
- })
- if (_startCell.s_merge) return;
- _checkCellList.forEach(function (el) {
- el.style.display = "none";
- $(el).eAttr("s_merge", "POS_" + _startcol + "_" + _startrow);
- $(el).eAttr("e_merge", "POS_" + _endcol + "_" + _endrow);
- $(el).eAttr("s_mergeCol", _startcol);
- $(el).eAttr("e_mergeCol", _endcol);
- $(el).eAttr("s_mergeRow", _startrow);
- $(el).eAttr("e_mergeRow", _endrow);
- if (_startCell.innerText) return;
- _startCell.innerText = el.innerText;
- })
- _startCell.style.width = _mergeWidth + "px";
- _startCell.style.height = _mergeHeight + "px";
- _startCell.style.display = "block";
- if (dataChange) return;
- var _data = {
- row: _startrow,
- col: _startcol,
- content: startCell.innerHTML,
- cssText: startCell.style.cssText,
- endRow: _endrow,
- endCol: _endcol
- };
- U.MD.O.E.dataChange(U.MD.O.E.excelInfo("merge", _data), req);
- };
- U.MD.O.E.RC.taskRename = function (task) {
- var _task = task,
- _text = task.firstChild.textContent,
- _input;
-
- $(_task).addClass('U_MD_O_E_task_renameing');
- $$('input',
- { 'type': 'text', 'id': 'rename', 'value': _text,
- 'style': { 'cssText': 'width:109px;height:38px;position: absolute;left:0;top:0;text-align: center;font-size: 16px;line-height:38px;' }
- },
- _task);
- _input = $('#rename')[0];
- _input.focus()
- _input.onblur = function (e) {
- U.UF.EV.stopBubble(e);
- _task.innerHTML = _input.value;
- $(_task).removeClass('U_MD_O_E_task_renameing');
- var _data = {
- name: _input.value,
- id: _task.id
- }
- U.MD.O.E.dataChange(U.MD.O.E.excelInfo("reNameTask", _data));
- }
- $(_input).bind('keypress', function (e) {
- U.UF.EV.stopBubble(e);
- });
- $(_input).bind('keydown', function (e) {
- U.UF.EV.stopBubble(e);
- });
- $(_input).bind('keyup', function (e) {
- U.UF.EV.stopBubble(e);
- });
- $(_input).bind('dblclick', function (e) {
- U.UF.EV.stopBubble(e);
- })
- }
- U.MD.O.E.RC.taskDelete = function (task, req) {
- var _task = task,
- _id = _task.id,
- _switchTask,
- _data = {
- id: _id
- };
- if ($(".U_MD_O_E_task ").length === 3) {
- U.Alert("至少要有一个工作表!");
- } else if (_id === U.MD.O.E.taskId) {
- _switchTask = _task.nextElementSibling || _task.previousElementSibling;
- $(_switchTask).addClass("U_MD_O_E_taskCheck");
- U.MD.O.E.taskId = _switchTask.id;
- U.MD.O.E.rePrintExcel();
- U.MD.O.E.dataChange(U.MD.O.E.excelInfo("deleteTask", _data), req);
- _task.remove();
- } else {
- U.MD.O.E.dataChange(U.MD.O.E.excelInfo("deleteTask", _data), req);
- _task.remove();
- }
- }
- U.MD.O.E.RC.taskCopy = function (task) {
- var _task = task;
- U.MD.O.E.taskCopyId = _task.id;
- U.MD.O.E.addTask();
- }
- U.MD.O.E.RC.cellCopy = function () {
- var _focusBox = $("#U_MD_O_E_focusBox")[0],
- _editorBox = $("#U_MD_O_E_editorBox")[0],
- _cellList = U.UF.C.toArray($(".U_MD_O_E_cellCheckd"));
- if (!_cellList.length) return;
- U.MD.O.E.RC.cellTaste.copyContent = _cellList;
- return true;
- }
- U.MD.O.E.RC.cellTaste = function (_arrjson, _arrcontent) {
- var _copycontent = U.MD.O.E.RC.cellTaste.copyContent,
- _cutcontent = U.MD.O.E.RC.cellTaste.cutContent,
- _leftCorner = U.UF.C.toArray($(".U_MD_O_E_cellCheckd"))[0];
- if (_cutcontent) {
- var _cutCellColfirst = _cutcontent[0].col,
- _cutCellRowfirst = _cutcontent[0].row;
- _filterCutContent = _cutcontent.filter(function (e) {
- return e.style.display != "none";
- });
- for (var i = 0; i < _filterCutContent.length; i++) {
- _cute_col = _filterCutContent[i].e_mergecol - _filterCutContent[i].s_mergecol,
- _cute_row = _filterCutContent[i].e_mergerow - _filterCutContent[i].s_mergerow;
- _cutCellCol = _filterCutContent[i].col;
- _cutCellRow = _filterCutContent[i].row;
- _cutCellColDifference = _cutCellCol - _cutCellColfirst;
- _cutCellRowDifference = _cutCellRow - _cutCellRowfirst;
- _leftCol = _leftCorner.col;
- _leftRow = _leftCorner.row;
- _cutColDifference = _leftCol + _cutCellColDifference;
- _cutRowDifference = _leftRow + _cutCellRowDifference;
- if (_cute_col) {
- U.MD.O.E.RC.mergeCells($("#POS_" + _cutColDifference + "_" + _cutRowDifference)[0], $("#POS_" + (_cutColDifference + _cute_col) + "_" + (_cutRowDifference + _cute_row))[0]);
- }
- _cutNewCell = $("#POS_" + _cutColDifference + "_" + _cutRowDifference)[0];
- _cutNewCell.innerHTML = _filterCutContent[i].innerHTML;
- _filterCutContent[i].innerHTML = "";
- U.MD.O.E.RC.cellTaste._filterCutContent = null;
- }
- } else if (_copycontent) {
- var _cellColfirst = _copycontent[0].col,
- _cellRowfirst = _copycontent[0].row,
- _copydata = [];
- _filterCopyContent = _copycontent.filter(function (e) {
- return e.style.display != "none";
- });
- for (var i = 0; i < _filterCopyContent.length; i++) {
- _cellCol = _filterCopyContent[i].col;
- _cellRow = _filterCopyContent[i].row;
- _cellColDifference = _cellCol - _cellColfirst;
- _cellRowDifference = _cellRow - _cellRowfirst;
- _leftCol = _leftCorner.col;
- _leftRow = _leftCorner.row;
- _colDifference = _leftCol + _cellColDifference;
- _rowDifference = _leftRow + _cellRowDifference;
- _e_col = _filterCopyContent[i].e_mergecol - _filterCopyContent[i].s_mergecol,
- _e_row = _filterCopyContent[i].e_mergerow - _filterCopyContent[i].s_mergerow;
- if (_e_col) {
- U.MD.O.E.RC.mergeCells($("#POS_" + _colDifference + "_" + _rowDifference)[0], $("#POS_" + (_colDifference + _e_col) + "_" + (_rowDifference + _e_row))[0]);
- }
- _newCell = $("#POS_" + _colDifference + "_" + _rowDifference)[0];
- _newCell.innerHTML = _filterCopyContent[i].innerHTML;
- var _data = {
- row: _newCell.row,
- col: _newCell.col,
- content: _newCell.innerHTML,
- innerText: _newCell.innerText
- };
- _copydata.push(_data);
- }
- U.MD.O.E.dataChange(U.MD.O.E.excelInfo("blur", _copydata));
- } else if (_arrjson) {
- var _cellColDifference = 0;
- var _cellRowDifference = 0;
- var _copydata = [];
- for (var i = 0; i < _arrjson.td; i++) {
- _leftCol = _leftCorner.col;
- _leftRow = _leftCorner.row;
- _maxcol = _leftCol + (_arrjson.age - 1);
- _maxrow = _leftRow + (_arrjson.tr - 1);
- if ((_leftCol + _cellColDifference) > _maxcol) {
- _cellColDifference = 0;
- _cellRowDifference += 1;
- }
- _newCell = $("#POS_" + (_leftCol + _cellColDifference) + "_" + (_leftRow + _cellRowDifference))[0];
- _cellColDifference += 1;
- _newCell.innerHTML = _arrcontent[i];
- var _data = {
- row: _newCell.row,
- col: _newCell.col,
- content: _newCell.innerHTML,
- innerText: _newCell.innerText
- };
- _copydata.push(_data);
- }
- }
- U.MD.O.E.dataChange(U.MD.O.E.excelInfo("blur", _copydata));
- }
- U.MD.O.E.RC.cellCut = function () {
- var _focusBox = $("#U_MD_O_E_focusBox")[0],
- _editorBox = $("#U_MD_O_E_editorBox")[0],
- _cellList = U.UF.C.toArray($(".U_MD_O_E_cellCheckd"));
- if (!_cellList.length) return;
- U.MD.O.E.RC.cellTaste.cutContent = _cellList;
- }
- U.MD.O.E.RC.clearAContent = function () {
- var _editorBox = $("#U_MD_O_E_editorBox")[0],
- _cellList = U.UF.C.toArray($(".U_MD_O_E_cellCheckd"));
- _a = $('a', _editorBox.focusEl)[0];
- $$("div", {}, _cellList[0]);
- _cellList[0].children[1].innerText = _a.innerText;
- _cellList[0].removeChild(_a);
- var _data = {
- row: _cellList[0].row,
- col: _cellList[0].col,
- content: _cellList[0].innerHTML
- }
- U.MD.O.E.dataChange(U.MD.O.E.excelInfo("clearAContent", _data));
- };
- U.MD.O.E.RC.insertLink = function (cell) {
- U.UF.E.excelAddHref();
- }
- U.MD.O.E.RC.insertImg = function (cell) {
- U.Alert("暂未开发!");
- }
- U.MD.O.E.RC.clearStyle = function (cellList) {
- var _eiditorBox = $("#U_MD_O_E_editorBox")[0],
- _cellCheckd = $(".U_MD_O_E_cellCheckd");
- for (var i = 0; i < _cellCheckd.length; i++) {
- _cellCheckd[i].style.fontWeight = "";
- _cellCheckd[i].style.fontStyle = "";
- _cellCheckd[i].style.textDecoration = "";
- _cellCheckd[i].style.textAlign = "";
- _cellCheckd[i].style.verticalAlign = "";
- _cellCheckd[i].style.display = "";
- if (_cellCheckd[i].children[0])
- _cellCheckd[i].children[0].style.verticalAlign = "";
- _cellCheckd[i].style.color = "";
- _cellCheckd[i].style.backgroundColor = "";
- _cellCheckd[i].style.fontFamily = "";
- _cellCheckd[i].style.fontSize = "";
- }
- _eiditorBox.style.fontWeight = "";
- _eiditorBox.style.fontStyle = "";
- _eiditorBox.style.textDecoration = "";
- _eiditorBox.style.textAlign = "";
- _eiditorBox.style.verticalAlign = "";
- _eiditorBox.style.color = "";
- _eiditorBox.style.fontFamily = "";
- _eiditorBox.style.fontSize = "";
- }
- U.MD.O.E.RC.clearContent = function (cellList) {
- var _cellList = U.UF.C.toArray($(".U_MD_O_E_cellCheckd")),
- _dataArr = [];
- for (var i = 0; i < _cellList.length; i++) {
- if (_cellList[i].innerText) {
- _cellList[i].innerText = "";
- var _data = {
- row: _cellList[i].row,
- col: _cellList[i].col,
- content: _cellList[i].innerHTML,
- innerText: _cellList[i].innerText
- };
- _dataArr.push(_data);
- }
- }
- U.MD.O.E.dataChange(U.MD.O.E.excelInfo("blur", _dataArr));
- }
- U.MD.O.E.RC.cBoardsetWidth = function (startCol, endCol, colWidth) {
- var _cBoardList = U.UF.C.toArray($(".U_MD_O_E_column")),
- _setcBArr = _cBoardList.filter(function (el) {
- return el.colname >= startCol && el.colname <= endCol && el.offsetWidth !== (+colWidth);
- }),
- _dataArr = [],
- _colBoard = $(".U_MD_O_E_colBoard")[0];
- _setcBArr.forEach(function (el) {
- _moveDis = colWidth - el.offsetWidth;
- var data = {
- initWidth: el.offsetWidth,
- colName: el.colname,
- moveDis: _moveDis
- }
- el.style.width = colWidth + "px";
- _colBoard.style.width = _colBoard.offsetWidth + _moveDis + "px";
- _dataArr.push(data);
- });
- U.MD.O.E.BC.colExpandingEnd(_dataArr);
- }
- U.MD.O.E.RC.cBoardHide = function (startCol, endCol) {
- U.Alert("暂未开发!");
- }
- U.MD.O.E.RC.cBoardCancelHide = function (startCol, endCol) {
- U.Alert("暂未开发!");
- }
- U.MD.O.E.RC.rBoardsetHeight = function (startRow, endRow, rowHeight) {
- var _rBoardList = U.UF.C.toArray($(".U_MD_O_E_row")),
- _setrBArr = _rBoardList.filter(function (el) {
- return el.rowname >= startRow && el.rowname <= endRow && el.offsetHeight !== (+rowHeight);
- }),
- _dataArr = [],
- _rowBoard = $(".U_MD_O_E_rowBoard")[0];
- _setrBArr.forEach(function (el) {
- _moveDis = rowHeight - el.offsetHeight;
- var data = {
- initHeight: el.offsetHeight,
- rowName: el.rowname,
- moveDis: _moveDis
- }
- el.style.height = rowHeight + "px";
- _rowBoard.style.height = _rowBoard.offsetHeight + _moveDis + "px";
- _dataArr.push(data);
- });
- U.MD.O.E.BC.rowExpandingEnd(_dataArr);
- }
- U.MD.O.E.RC.rBoardHide = function (startRow, endRow) {
- U.Alert("暂未开发!");
- }
- U.MD.O.E.RC.rBoardCancelHide = function (startRow, endRow) {
- U.Alert("暂未开发!");
- }
|