Lines Matching refs:cell

1748 function shift_cell_xls(cell, tgt) {  argument
1750 if(cell.cRel) cell.c += tgt.s.c;
1751 if(cell.rRel) cell.r += tgt.s.r;
1753 cell.c += tgt.c;
1754 cell.r += tgt.r;
1756 cell.cRel = cell.rRel = 0;
1757 while(cell.c >= 0x100) cell.c -= 0x100;
1758 while(cell.r >= 0x10000) cell.r -= 0x10000;
1759 return cell;
1762 function shift_range_xls(cell, range) { argument
1763 cell.s = shift_cell_xls(cell.s, range.s);
1764 cell.e = shift_cell_xls(cell.e, range.s);
1765 return cell;
1845 function write_XLSBCell(cell, o) { argument
1847 o.write_shift(-4, cell.c);
1848 o.write_shift(3, cell.iStyleRef === undefined ? cell.iStyleRef : cell.s);
1899 var cell = {s: {}, e: {}}; class in parse_UncheckedRfX
1900 cell.s.r = data.read_shift(4);
1901 cell.e.r = data.read_shift(4);
1902 cell.s.c = data.read_shift(4);
1903 cell.e.c = data.read_shift(4);
1904 return cell;
7390 function write_ws_xml_cell(cell, ref, ws, opts, idx, wb) { argument
7391 if(cell.v === undefined) return "";
7393 var oldt = cell.t, oldv = cell.v;
7394 switch(cell.t) {
7395 case 'b': vv = cell.v ? "1" : "0"; break;
7396 case 'n': vv = ''+cell.v; break;
7397 case 'e': vv = BErr[cell.v]; break;
7399 if(opts.cellDates) vv = new Date(cell.v).toISOString();
7401 cell.t = 'n';
7402 vv = ''+(cell.v = datenum(cell.v));
7403 if(typeof cell.z === 'undefined') cell.z = SSF._table[14];
7406 default: vv = cell.v; break;
7410 var os = get_cell_style(opts.cellXfs, cell, opts);
7412 switch(cell.t) {
7419 v = writetag('v', ''+get_sst_id(opts.Strings, cell.v));
7424 if(cell.t != oldt) { cell.t = oldt; cell.v = oldv; }
7527 var o = [], r = [], range = safe_decode_range(ws['!ref']), cell, ref, rr = "", cols = [], R, C;
7535 if((cell = write_ws_xml_cell(ws[ref], ref, ws, opts, idx, wb)) != null) r.push(cell);
7592 var cell = parse_XLSBCell(data);
7593 return [cell];
7595 function write_BrtCellBlank(cell, val, o) { argument
7603 var cell = parse_XLSBCell(data);
7605 return [cell, fBool, 'b'];
7610 var cell = parse_XLSBCell(data);
7612 return [cell, fBool, 'e'];
7617 var cell = parse_XLSBCell(data);
7619 return [cell, isst, 's'];
7624 var cell = parse_XLSBCell(data);
7626 return [cell, value, 'n'];
7631 var cell = parse_XLSBCell(data);
7633 return [cell, value, 'n'];
7638 var cell = parse_XLSBCell(data);
7640 return [cell, value, 'str'];
7645 var cell = parse_XLSBCell(data);
7647 var o = [cell, value, 'b'];
7658 var cell = parse_XLSBCell(data);
7660 var o = [cell, value, 'e'];
7671 var cell = parse_XLSBCell(data);
7673 var o = [cell, value, 'n'];
7685 var cell = parse_XLSBCell(data);
7687 var o = [cell, value, 'str'];
7917 function write_ws_bin_cell(ba, cell, R, C, opts) { argument
7918 if(cell.v === undefined) return "";
7920 switch(cell.t) {
7921 case 'b': vv = cell.v ? "1" : "0"; break;
7922 case 'n': case 'e': vv = ''+cell.v; break;
7923 default: vv = cell.v; break;
7927 o.s = get_cell_style(opts.cellXfs, cell, opts);
7928 switch(cell.t) {
7931 vv = get_sst_id(opts.Strings, cell.v);
7939 write_record(ba, "BrtCellBlank", write_BrtCellBlank(cell, o));
8535 function safe_format_xlml(cell, nf, o) { argument
8537 if(cell.t === 'e') { cell.w = cell.w || BErr[cell.v]; }
8539 if(cell.t === 'n') {
8540 if((cell.v|0) === cell.v) cell.w = SSF._general_int(cell.v);
8541 else cell.w = SSF._general_num(cell.v);
8543 else cell.w = SSF._general(cell.v);
8545 else cell.w = xlml_format(nf||"General", cell.v);
8546 if(o.cellNF) cell.z = XLMLFormatMap[nf]||nf||"General";
8561 function parse_xlml_data(xml, ss, data, cell, base, styles, csty, row, o) { argument
8562 var nf = "General", sid = cell.StyleID, S = {}; o = o || {};
8574 cell.t = 'b';
8575 cell.v = parsexmlbool(xml);
8578 cell.t = 's'; cell.r = xlml_fixstr(unescapexml(xml));
8579 cell.v = xml.indexOf("<") > -1 ? ss : cell.r;
8582 cell.v = (Date.parse(xml) - new Date(Date.UTC(1899, 11, 30))) / (24 * 60 * 60 * 1000);
8583 if(cell.v !== cell.v) cell.v = unescapexml(xml);
8584 else if(cell.v >= 1 && cell.v<60) cell.v = cell.v -1;
8588 if(cell.v === undefined) cell.v=+xml;
8589 if(!cell.t) cell.t = 'n';
8591 case 'Error': cell.t = 'e'; cell.v = RBErr[xml]; cell.w = xml; break;
8592 default: cell.t = 's'; cell.v = xlml_fixstr(ss); break;
8594 safe_format_xlml(cell, nf, o);
8595 if(o.cellFormula != null && cell.Formula) {
8596 cell.f = rc_to_a1(unescapexml(cell.Formula), base);
8597 cell.Formula = undefined;
8603 cell.s = S;
8605 cell.ixfe = cell.StyleID !== undefined ? cell.StyleID : 'Default';
8626 var table = {}, cell = {}, row = {}, dtag, didx; variable
8639 …ce(didx, Rn.index), ss, dtag, state[state.length-1][0]=="Comment"?comment:cell, {c:c,r:r}, styles,…
8644 if(comments.length > 0) cell.c = comments;
8645 …!opts.sheetRows || opts.sheetRows > r) && cell.v !== undefined) cursheet[encode_col(c) + encode_ro…
8646 if(cell.HRef) {
8647 cell.l = {Target:cell.HRef, tooltip:cell.HRefScreenTip};
8648 cell.HRef = cell.HRefScreenTip = undefined;
8650 if(cell.MergeAcross || cell.MergeDown) {
8651 var cc = c + (parseInt(cell.MergeAcross,10)|0);
8652 var rr = r + (parseInt(cell.MergeDown,10)|0);
8656 if(cell.MergeAcross) c += +cell.MergeAcross;
8658 cell = xlml_parsexmltagobj(Rn[0]);
8659 if(cell.Index) c = +cell.Index - 1;
9278 var process_cell_style = function pcs(cell, line) { argument
9287 var addcell = function addcell(cell, line, options) { argument
9289 if(options.cellStyles && line.XF && line.XF.data) process_cell_style(cell, line);
9290 lastcell = cell;
9291 last_cell = encode_cell(cell);
9293 if(cell.r < range.s.r) range.s.r = cell.r;
9294 if(cell.c < range.s.c) range.s.c = cell.c;
9297 if(cell.r + 1 > range.e.r) range.e.r = cell.r + 1;
9298 if(cell.c + 1 > range.e.c) range.e.c = cell.c + 1;
9476 temp_val = {v:val.val, ixfe:val.cell.ixfe, t:val.tt};
9478 …options.cellFormula) temp_val.f = "="+stringify_formula(val.formula,range,val.cell,supbooks, opts);
9480 addcell(val.cell, temp_val, options);
9487 temp_val = {v:last_formula.val, ixfe:last_formula.cell.ixfe, t:'s'};
9489 …temp_val.f = "="+stringify_formula(last_formula.formula, range, last_formula.cell, supbooks, opts);
9491 addcell(last_formula.cell, temp_val, options);
9502 shared_formulae[encode_cell(last_formula.cell)]= val[0];
11451 function encode_cell(cell) { return encode_col(cell.c) + encode_row(cell.r); } argument
11493 function safe_format_cell(cell, v) { argument
11494 if(cell.z !== undefined) try { return (cell.w = SSF.format(cell.z, v)); } catch(e) { }
11495 if(!cell.XF) return v;
11496 try { return (cell.w = SSF.format(cell.XF.ifmt||0, v)); } catch(e) { return ''+v; }
11499 function format_cell(cell, v) { argument
11500 if(cell == null || cell.t == null) return "";
11501 if(cell.w !== undefined) return cell.w;
11502 if(v === undefined) return safe_format_cell(cell, cell.v);
11503 return safe_format_cell(cell, v);