Lines Matching refs:ref
4396 if(!ws["!ref"]) ws["!ref"] = "A1:A1";
4399 if(ws['!ref']) {
4400 var _range = safe_decode_range(ws['!ref']);
4447 if(range.s.c < 10000000) ws['!ref'] = encode_range(range);
7284 var ref = parse_RefU(blob, 6);
7288 return [parse_SharedParsedFormula(blob, length, opts), cUse, ref];
7293 var ref = parse_Ref(blob, 6);
7300 return [ref, parse_ArrayParsedFormula(blob, length, opts, ref)];
7429 var ref = parse_Ref8U(blob, 8);
7432 return [ref, hlink];
7436 var ref = decode_cell(hl[0]);
7437 O.write_shift(2, ref.r); O.write_shift(2, ref.r);
7438 O.write_shift(2, ref.c); O.write_shift(2, ref.c);
7448 var ref = parse_Ref8U(blob, 8);
7451 return [ref, wzTooltip];
7457 var ref = decode_cell(hl[0]);
7458 O.write_shift(2, ref.r); O.write_shift(2, ref.r);
7459 O.write_shift(2, ref.c); O.write_shift(2, ref.c);
7906 var range = safe_decode_range(ws['!ref']);
8254 var r = safe_decode_range(ws['!ref']), cell/*:Cell*/;
8342 var r = safe_decode_range(ws['!ref']);
8445 if(!ws || !ws['!ref']) return "";
8447 var r = decode_range(ws['!ref']);
8477 //o.push("copiedfrom:" + ws['!ref']); // clipboard only
8638 ws['!ref'] = encode_range(range);
8675 var r = safe_decode_range(ws['!ref']), cell/*:Cell*/;
8786 s["!ref"] = encode_range(refguess);
8827 s["!ref"] = encode_range(refguess);
8850 s["!ref"] = encode_range(refguess);
8861 osheets[realnames[i]] = ({ "!ref": "A1" });
8871 var range = safe_decode_range(ws["!ref"]);
8882 var ref = cols[C] + rr;
8883 var cell = dense ? (ws[R]||[])[C] : ws[ref];
8908 …0; i < wb.SheetNames.length; ++i) if((wb.Sheets[wb.SheetNames[i]] || {})["!ref"]) write_biff_rec(b…
8913 if(!ws || !ws["!ref"]) continue;
8914 var range = safe_decode_range(ws["!ref"]);
8922 var ref = cols[C] + rr;
8923 var cell = dense ? (ws[R]||[])[C] : ws[ref];
8958 if(!ws || !ws["!ref"]) continue;
8960 var range = decode_range(ws["!ref"]);
9690 s["!ref"] = encode_range(range);
10441 ws["!ref"] = encode_range(range);
10451 if (!ws["!ref"])
10453 var r = safe_decode_range(ws["!ref"]), cell;
12164 var r = decode_cell(comment.ref);
12168 } else cell = sheet[comment.ref];
12172 else sheet[comment.ref] = cell;
12173 var range = safe_decode_range(sheet["!ref"]||"BDWGO1000001:A1");
12179 if (encoded !== sheet["!ref"]) sheet["!ref"] = encoded;
12216 …nt*/ = ({ author: y.authorId && authors[y.authorId] || "sheetjsghost", ref: y.ref, guid: y.guid }/… property in parse_comments_xml.AnonymousFunction701aad5b4d00.comment
12217 var cell = decode_cell(y.ref);
12259 o.push('<comment ref="' + d[0] + '" authorId="' + iauthor.indexOf(escapexml(c.a)) + '"><text>');
12265 o.push('<comment ref="' + d[0] + '" authorId="' + lastauthor + '"><text>');
12291 case '<threadedComment': comment = {author: y.personId, guid: y.id, ref: y.ref, T: 1}; break; property in xml_tcmnt.case
12324 ref: carr[0], property in AnonymousFunction701aad5b5400.tcopts
12389 out.ref = encode_cell(rfx.s);
13613 function parse_ArrayParsedFormula(blob, length, opts/*::, ref*/) {
15236 if(ws && ws['!ref']) {
15237 var range = safe_decode_range(ws['!ref']);
15238 ….e.c < range.s.c || range.e.r < range.s.r) throw new Error("Bad range (" + i + "): " + ws['!ref']);
15243 if(d.s.r<=d.e.r && d.s.c<=d.e.c && d.s.r>=0 && d.s.c>=0) ws["!ref"] = encode_range(d);
15245 var mergecregex = /<(?:\w:)?mergeCell ref="[A-Z0-9:]+"\s*[\/]?>/g;
15281 var ref = data1.slice(ridx,ridx+50).match(dimregex); variable
15282 if(ref) parse_ws_xml_dim(s, ref[1]);
15318 …if(!s["!ref"] && refguess.e.c >= refguess.s.c && refguess.e.r >= refguess.s.r) s["!ref"] = encode_…
15319 if(opts.sheetRows > 0 && s["!ref"]) {
15320 var tmpref = safe_decode_range(s["!ref"]);
15327 s["!fullref"] = s["!ref"];
15328 s["!ref"] = encode_range(tmpref);
15339 for(var i = 0; i != merges.length; ++i) o += '<mergeCell ref="' + encode_range(merges[i]) + '"/>';
15395 if(!val.ref) return;
15406 var rng = safe_decode_range(val.ref);
15457 var o = { ref: (data.match(/ref="([^"]*)"/)||[])[1]}; property in parse_ws_xml_autofilter.o
15461 var ref = typeof data.ref == "string" ? data.ref : encode_range(data.ref);
15465 var range = decode_range(ref);
15466 if(range.s.r == range.e.r) { range.e.r = decode_range(ws["!ref"]).e.r; ref = encode_range(range); }
15471 name.Ref = formula_quote_sheet_name(wb.SheetNames[idx]) + "!" + fix_range(ref); break;
15473 …s.push({ Name: '_xlnm._FilterDatabase', Sheet: idx, Ref: "'" + wb.SheetNames[idx] + "'!" + ref });
15474 return writextag("autoFilter", null, {ref:ref});
15499 function write_ws_xml_cell(cell/*:Cell*/, ref, ws, opts/*::, idx, wb*/)/*:string*/ { argument
15500 if(cell.c) ws['!comments'].push([ref, cell.c]);
15519 …var v = (cell.t == "z" || cell.v == null)? "" : writetag('v', escapexml(vv)), o = ({r:ref}/*:any*/…
15539 var ff = cell.F && cell.F.slice(0, ref.length) == ref ? {t:"array", ref:cell.F} : null;
15544 ws['!links'].push([ref, cell.l]);
15553 var refregex = /ref=["']([^"']*)["']/;
15648 …edf[ftag.si]) p.f = shift_formula_xlsx(sharedf[ftag.si][1], sharedf[ftag.si][2]/*[0].ref*/, tag.r);
15738 …*/ = [], r/*:Array<string>*/ = [], range = safe_decode_range(ws['!ref']), cell="", ref, rr = "", c…
15746 ref = cols[C] + rr;
15747 var _cell = dense ? (ws[R]||[])[C]: ws[ref];
15749 if((cell = write_ws_xml_cell(_cell, ref, ws, opts, idx, wb)) != null) r.push(cell);
15789 var ref = ws['!ref'] || 'A1';
15790 var range = safe_decode_range(ref);
15792 if(opts.WTF) throw new Error("Range " + ref + " exceeds format limit A1:XFD1048576");
15795 ref = encode_range(range);
15803 o[o.length] = (writextag('dimension', null, {'ref': ref}));
15818 if(ws['!ref'] != null) {
15848 rel = ({"ref":l[0]}/*:any*/); property in AnonymousFunction701aad5b6d00.rel
15873 …h] = writetag("ignoredErrors", writextag("ignoredError", null, {numberStoredAsText:1, sqref:ref}));
16365 function write_BrtCellIgnoreEC(ref) { argument
16369 write_UncheckedRfX(ref, o);
16414 var ref;
16448 ref = val; break;
16588 s['!autofilter'] = { ref:encode_range(val) };
16686 …if(!s["!ref"] && (refguess.s.r < 2000000 || ref && (ref.e.r > 0 || ref.e.c > 0 || ref.s.r > 0 || r…
16687 if(opts.sheetRows && s["!ref"]) {
16688 var tmpref = safe_decode_range(s["!ref"]);
16695 s["!fullref"] = s["!ref"];
16696 s["!ref"] = encode_range(tmpref);
16764 var range = safe_decode_range(ws['!ref'] || "A1"), ref, rr = "", cols/*:Array<string>*/ = [];
16778 ref = cols[C] + rr;
16779 var cell = dense ? (ws[R]||[])[C] : ws[ref];
16803 if(!ws || !ws['!ref']) return;
16805 …write_record(ba, 0x0289 /* BrtCellIgnoreEC */, write_BrtCellIgnoreEC(safe_decode_range(ws['!ref'])…
16830 var ref = typeof data.ref === "string" ? data.ref : encode_range(data.ref);
16836 var range = decode_range(ref);
16837 if(range.s.r == range.e.r) { range.e.r = decode_range(ws["!ref"]).e.r; ref = encode_range(range); }
16842 name.Ref = formula_quote_sheet_name(wb.SheetNames[idx]) + "!" + fix_range(ref); break;
16844 …atabase', Sheet: idx, Ref: formula_quote_sheet_name(wb.SheetNames[idx]) + "!" + fix_range(ref) });
16846 write_record(ba, 0x00A1 /* BrtBeginAFilter */, write_UncheckedRfX(safe_decode_range(ref)));
16883 var r = safe_decode_range(ws['!ref'] || "A1");
16885 …if(opts.WTF) throw new Error("Range " + (ws['!ref'] || "A1") + " exceeds format limit A1:XFD104857…
16976 if(C > 0) cs["!ref"] = encode_range(refguess);
17230 var nn = formula_quote_sheet_name(n) + "!" + fix_range(ws["!autofilter"].ref);
17338 /* 18.2.16 oleSize CT_OleSize ? (ref required) */
18199 cursheet["!ref"] = encode_range(refguess);
18201 cursheet["!fullref"] = cursheet["!ref"];
18203 cursheet["!ref"] = encode_range(refguess);
18346 cursheet['!autofilter'] = { ref:rc_to_a1(AutoFilter.Range).replace(/\$/g,"") }; property in cursheet
19004 function write_ws_xlml_cell(cell, ref/*:string*/, ws, opts, idx/*:number*/, wb, addr)/*:string*/{ argument
19009 if(cell.F && cell.F.slice(0, ref.length) == ref) {
19010 var end = decode_cell(cell.F.slice(ref.length + 1));
19059 if(!ws['!ref']) return "";
19060 var range/*:Range*/ = safe_decode_range(ws['!ref']);
19087 var ref = encode_cell(addr), cell = dense ? (ws[R]||[])[C] : ws[ref];
19088 row.push(write_ws_xlml_cell(cell, ref, ws, opts, idx, wb, addr));
19110 …if(ws["!autofilter"]) o.push('<AutoFilter x:Range="' + a1_to_rc(fix_range(ws["!autofilter"].ref), …
19430 FilterDatabases[val.itab - 1] = { ref: encode_range(val.rgce[0][0][1][2]) }; property in FilterDatabases
19452 out["!ref"] = encode_range(range);
19456 out["!fullref"] = out["!ref"];
19457 out["!ref"] = encode_range(range);
19734 if(!wb.SheetNames.length && Preamble["!ref"]) {
21282 …var range = safe_decode_range(ws['!ref'] || "A1"), ref/*:string*/, rr = "", cols/*:Array<string>*/…
21284 …if(opts.WTF) throw new Error("Range " + (ws['!ref'] || "A1") + " exceeds format limit A1:IV16384");
21287 ref = encode_range(range);
21293 ref = cols[C] + rr;
21294 var cell = dense ? (ws[R]||[])[C] : ws[ref];
21348 write_Ref8U(safe_decode_range(ws['!ref']||"A1"), o);
21415 var ref/*:string*/, rr = "", cols/*:Array<string>*/ = [];
21416 var range = safe_decode_range(ws['!ref'] || "A1");
21419 …if(opts.WTF) throw new Error("Range " + (ws['!ref'] || "A1") + " exceeds format limit A1:IV16384");
21453 ref = cols[C] + rr;
21454 var cell = dense ? (ws[R]||[])[C] : ws[ref];
21458 if(b8 && cell.l) ws['!links'].push([ref, cell.l]);
21459 if(b8 && cell.c) comments.push([ref, cell.c]);
21594 if(!ws || !ws["!ref"]) continue;
21595 var range = decode_range(ws["!ref"]);
21663 ws['!ref'] = encode_range(range);
21728 var r = decode_range(ws['!ref']);
21756 if(ws["!ref"]) {
21757 var _range/*:Range*/ = decode_range(ws["!ref"]);
21818 ws['!ref'] = encode_range(range);
22123 if(range.e.c >= range.s.c && range.e.r >= range.s.r) ws['!ref'] = encode_range(range);
22124 else ws['!ref'] = "A1:A1";
22126 ws['!fullref'] = ws['!ref'];
22128 ws['!ref'] = encode_range(range);
22457 Sheets[_Ref[0]]['!autofilter'] = { ref:_Ref[1] }; property in Sheets
22843 var R=0,C=0, range = decode_range(ws['!ref']||"A1");
22871 var ref = encode_cell({r:R, c:C}), cell = dense ? (ws[R]||[])[C]: ws[ref];
22875 if(cell.F.slice(0, ref.length) == ref) {
22981 var range = decode_range(ws["!ref"]);
23924 function numbers_add_oref(iwa, ref) { argument
23927 var orefidx = orefs.indexOf(ref);
23929 orefs.push(ref);
23933 function numbers_del_oref(iwa, ref) { argument
23937 return r != ref;
24046 ws["!ref"] = encode_range(range);
24085 var ref = M[parse_TSP_Reference(store[13][0].data)][0];
24086 var mtype = varint_to_i32(ref.meta[1][0].data);
24089 ws["!merges"] = (_f = parse_shallow(ref.data)) == null ? void 0 : _f[1].map(function(pi) {
24106 out = { "!ref": "A1" };
24109 out["!ref"] = "A1";
24503 var ref = parse_TSP_Reference(srrta[1][0].data);
24504 numbers_del_oref(tmaroot, ref);
24769 var range = decode_range(ws["!ref"]);
26034 if(sheet == null || sheet["!ref"] == null) return [];
26038 var range = o.range != null ? o.range : sheet["!ref"];
26045 case 'number': r = safe_decode_range(sheet["!ref"]); r.s.r = range; break;
26115 if(sheet == null || sheet["!ref"] == null) return "";
26116 var r = safe_decode_range(sheet["!ref"]);
26147 if(sheet == null || sheet["!ref"] == null) return [];
26148 var r = safe_decode_range(sheet['!ref']), rr = "", cols/*:Array<string>*/ = [], C;
26194 if(ws['!ref']) {
26195 var _range = safe_decode_range(ws['!ref']);
26212 var ref = dense ? "" : encode_cell({c:_C + C,r:_R + R + offset});
26213 var cell/*:Cell*/ = dense ? ROW[_C + C] : ws[ref];
26215 ws[ref] = v;
26227 if(!dense) ws[ref] = cell = ({t:t, v:v}/*:any*/);
26245 ws['!ref'] = encode_range(range);
26359 var wsr = decode_range(ws["!ref"]);
26364 ws["!ref"] = encode_range(wsr);
26414 if(sheet == null || sheet["!ref"] == null) { stream.push(null); return stream; }
26415 var r = safe_decode_range(sheet["!ref"]);
26449 var r = decode_range(ws['!ref']);
26471 if(sheet == null || sheet["!ref"] == null) { stream.push(null); return stream; }
26475 var range = o.range != null ? o.range : sheet["!ref"];
26481 case 'number': r = safe_decode_range(sheet["!ref"]); r.s.r = range; break;