Lines Matching refs:range
4243 function shift_range_xls(cell, range, opts) { argument
4245 out.s = shift_cell_xls(out.s, range.s, opts);
4246 out.e = shift_cell_xls(out.e, range.s, opts);
4300 function decode_range(range/*:string*/)/*:Range*/ { argument
4301 var idx = range.indexOf(":");
4302 if(idx == -1) return { s: decode_cell(range), e: decode_cell(range) };
4303 return { s: decode_cell(range.slice(0, idx)), e: decode_cell(range.slice(idx + 1)) };
4330 function safe_decode_range(range/*:string*/)/*:Range*/ { argument
4333 var len = range.length;
4335 if((cc=range.charCodeAt(i)-64) < 1 || cc > 26) break;
4341 if((cc=range.charCodeAt(i)-48) < 0 || cc > 9) break;
4350 if((cc=range.charCodeAt(i)-64) < 1 || cc > 26) break;
4356 if((cc=range.charCodeAt(i)-48) < 0 || cc > 9) break;
4398 var range/*:Range*/ = ({s: {c:10000000, r:10000000}, e: {c:0, r:0}}/*:any*/); class in sheet_add_aoa
4401 range.s.c = _range.s.c;
4402 range.s.r = _range.s.r;
4403 range.e.c = Math.max(range.e.c, _range.e.c);
4404 range.e.r = Math.max(range.e.r, _range.e.r);
4405 if(_R == -1) range.e.r = _R = _range.e.r + 1;
4414 if(range.s.r > __R) range.s.r = __R;
4415 if(range.s.c > __C) range.s.c = __C;
4416 if(range.e.r < __R) range.e.r = __R;
4417 if(range.e.c < __C) range.e.c = __C;
4447 if(range.s.c < 10000000) ws['!ref'] = encode_range(range);
7030 function write_Dimensions(range, opts) { argument
7033 o.write_shift(w, range.s.r);
7034 o.write_shift(w, range.e.r + 1);
7035 o.write_shift(2, range.s.c);
7036 o.write_shift(2, range.e.c + 1);
7906 var range = safe_decode_range(ws['!ref']);
7910 for(i = 0; i <= range.e.c - range.s.c; ++i) {
8575 var range/*:Range*/ = ({s: {c:0, r:0}, e: {c:0, r:0}}/*:any*/); class in PRN.dsv_to_sheet_str
8623 if(range.e.c < C) range.e.c = C;
8624 if(range.e.r < R) range.e.r = R;
8638 ws['!ref'] = encode_range(range);
8871 var range = safe_decode_range(ws["!ref"]);
8876 write_biff_rec(ba, 0x06, write_RANGE(range));
8877 var max_R = Math.min(range.e.r, 8191);
8878 for(var R = range.s.r; R <= max_R; ++R) {
8880 for(var C = range.s.c; C <= range.e.c; ++C) {
8881 if(R === range.s.r) cols[C] = encode_col(C);
8914 var range = safe_decode_range(ws["!ref"]);
8917 var max_R = Math.min(range.e.r, 8191);
8918 for(var R = range.s.r; R <= max_R; ++R) {
8920 for(var C = range.s.c; C <= range.e.c; ++C) {
8921 if(R === range.s.r) cols[C] = encode_col(C);
8960 var range = decode_range(ws["!ref"]);
8961 if(rows < range.e.r) rows = range.e.r;
8962 if(cols < range.e.c) cols = range.e.c;
8997 function write_RANGE(range) {
8999 out.write_shift(2, range.s.c);
9000 out.write_shift(2, range.s.r);
9001 out.write_shift(2, range.e.c);
9002 out.write_shift(2, range.e.r);
9636 var range = {s:{r:-1,c:-1}, e:{r:-1,c:-1}};
9672 range.s.c = p.read_shift(2);
9673 range.e.c = p.read_shift(2);
9674 range.s.r = p.read_shift(4);
9675 range.e.r = p.read_shift(4);
9686 /* NOTE: QP valid range A1:IV1000000 */
9687 if(range.s.c > 0xFF || range.s.r > 999999) break;
9688 if(range.e.c < range.s.c) range.e.c = range.s.c;
9689 if(range.e.r < range.s.r) range.e.r = range.s.r;
9690 s["!ref"] = encode_range(range);
9696 if(range.e.c < C) range.e.c = C;
9697 if(range.s.c > C) range.s.c = C;
9699 if(range.s.r > R) range.s.r = R;
9701 if(range.e.r < R) range.e.r = R;
9706 if(range.s.r > R) range.s.r = R;
9707 if(range.e.r < R + cnt - 1) range.e.r = R + cnt - 1;
10396 var range = { s: { c: 0, r: 0 }, e: { c: 0, r: rows.length - 1 } }; class in rtf_to_sheet_str
10438 if (C > range.e.c)
10439 range.e.c = C;
10441 ws["!ref"] = encode_range(range);
12173 var range = safe_decode_range(sheet["!ref"]||"BDWGO1000001:A1");
12174 if(range.s.r > r.r) range.s.r = r.r;
12175 if(range.e.r < r.r) range.e.r = r.r;
12176 if(range.s.c > r.c) range.s.c = r.c;
12177 if(range.e.c < r.c) range.e.c = r.c;
12178 var encoded = encode_range(range);
12467 var range = {s:decode_cell(comment[0]),e:decode_cell(comment[0])}; class in AnonymousFunction701aad5b5900
12468 write_record(ba, 0x027B /* BrtBeginComment */, write_BrtBeginComment([range, c]));
12550 function shift_formula_xlsx(f/*:string*/, range/*:string*/, cell/*:string*/)/*:string*/ { argument
12551 var r = decode_range(range), s = r.s, c = decode_cell(cell);
13260 console.error("Cannot hydrate range", start, end);
13302 function stringify_formula(formula/*Array<any>*/, range, cell/*:any*/, supbooks, opts)/*:string*/ { argument
13304 var _range = /*range != null ? range :*/ {s:{c:0, r:0},e:{c:0, r:0}};
13842 /* Writes a single sheet range [PtgRef PtgRef PtgRange] */
13871 /* Writes a range with explicit sheet name [PtgRef3D PtgRef3D PtgRange] */
13904 /* Writes a range with explicit sheet name [PtgArea3d] */
13910 var range = decode_range(_str);
13917 out.write_shift(4, range.s.r);
13918 out.write_shift(4, range.e.r);
13919 out.write_shift(2, range.s.c);
13920 out.write_shift(2, range.e.c);
15237 var range = safe_decode_range(ws['!ref']);
15238 …if(range.e.c < range.s.c || range.e.r < range.s.r) throw new Error("Bad range (" + i + "): " + ws[…
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); }
15738 …var o/*:Array<string>*/ = [], r/*:Array<string>*/ = [], range = safe_decode_range(ws['!ref']), cel…
15741 for(C = range.s.c; C <= range.e.c; ++C) cols[C] = encode_col(C);
15742 for(R = range.s.r; R <= range.e.r; ++R) {
15745 for(C = range.s.c; C <= range.e.c; ++C) {
15790 var range = safe_decode_range(ref);
15791 if(range.e.c > 0x3FFF || range.e.r > 0xFFFFF) {
15793 range.e.c = Math.min(range.e.c, 0x3FFF);
15794 range.e.r = Math.min(range.e.c, 0xFFFFF);
15795 ref = encode_range(range);
15916 function write_BrtRowHdr(R/*:number*/, range, ws) { argument
15944 if((range.s.c > ((i+1) << 10)) || (range.e.c < (i << 10))) continue;
15964 function write_row_header(ba, ws, range, R) { argument
15965 var o = write_BrtRowHdr(R, range, ws);
16189 o[3] = stringify_formula(formula, null/*range*/, cell, opts.supbooks, opts);/* TODO */
16205 o[3] = stringify_formula(formula, null/*range*/, cell, opts.supbooks, opts);/* TODO */
16221 o[3] = stringify_formula(formula, null/*range*/, cell, opts.supbooks, opts);/* TODO */
16237 o[3] = stringify_formula(formula, null/*range*/, cell, opts.supbooks, opts);/* TODO */
16764 var range = safe_decode_range(ws['!ref'] || "A1"), ref, rr = "", cols/*:Array<string>*/ = [];
16767 var cap = range.e.r;
16768 if(ws['!rows']) cap = Math.max(range.e.r, ws['!rows'].length - 1);
16769 for(var R = range.s.r; R <= cap; ++R) {
16773 write_row_header(ba, ws, range, R);
16775 if(R <= range.e.r) for(var C = range.s.c; C <= range.e.c; ++C) {
16777 if(R === range.s.r) cols[C] = encode_col(C);
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); }
18194 case 'worksheet' /*case 'Worksheet'*/: /* TODO: read range from FullRows/FullColumns */
18708 case 'range' /*case 'Range'*/: break;
18739 case 'range' /*case 'Range'*/: break;
18769 case 'range' /*case 'Range'*/: break;
19060 var range/*:Range*/ = safe_decode_range(ws['!ref']);
19073 for(var R = range.s.r; R <= range.e.r; ++R) {
19075 for(var C = range.s.c; C <= range.e.c; ++C) {
19251 var range/*:Range*/ = ({}/*:any*/); variable
19285 if(!range || !range.s || !range.e) range = {s:{r:0,c:0},e:{r:0,c:0}};
19286 if(cell.r < range.s.r) range.s.r = cell.r;
19287 if(cell.c < range.s.c) range.s.c = cell.c;
19288 if(cell.r + 1 > range.e.r) range.e.r = cell.r + 1;
19289 if(cell.c + 1 > range.e.c) range.e.c = cell.c + 1;
19296 if(line.f) line.f = "" + stringify_formula(arrayf[afi][1], range, cell, supbooks, opts);
19422 Ref: stringify_formula(val.rgce,range,null,supbooks,opts)
19449 if(range.e) {
19450 if(range.e.r > 0 && range.e.c > 0) {
19451 range.e.r--; range.e.c--;
19452 out["!ref"] = encode_range(range);
19453 if(options.sheetRows && options.sheetRows <= range.e.r) {
19454 var tmpri = range.e.r;
19455 range.e.r = options.sheetRows - 1;
19457 out["!ref"] = encode_range(range);
19458 range.e.r = tmpri;
19460 range.e.r++; range.e.c++;
19495 range = {s:{r:0,c:0},e:{r:0,c:0}}; class
19548 … if(sharedf[_fe]) temp_val.f = ""+stringify_formula(val.formula,range,val.cell,supbooks, opts);
19550 } else temp_val.f = ""+stringify_formula(val.formula,range,val.cell,supbooks, opts);
19563 … temp_val.f = ""+stringify_formula(last_formula.formula, range, last_formula.cell, supbooks, opts);
19578 cc.f = ""+stringify_formula(val[1], range, val[0], supbooks, opts);
19585 /* TODO: capture range */
19589 (cc||{}).f = ""+stringify_formula(val[0], range, lastcell, supbooks, opts);
19625 if(file_depth === 1) range = val; /* TODO: stack */
19675 range.e.r = Math.max(range.e.r, val[0].r);
19676 range.s.r = Math.min(range.s.r, val[0].r);
19677 range.e.c = Math.max(range.e.c, val[0].c);
19678 range.s.c = Math.min(range.s.c, val[0].c);
21282 …var range = safe_decode_range(ws['!ref'] || "A1"), ref/*:string*/, rr = "", cols/*:Array<string>*/…
21283 if(range.e.c > 0xFF || range.e.r > 0x3FFF) {
21285 range.e.c = Math.min(range.e.c, 0xFF);
21286 range.e.r = Math.min(range.e.c, 0x3FFF);
21287 ref = encode_range(range);
21289 for(var R = range.s.r; R <= range.e.r; ++R) {
21291 for(var C = range.s.c; C <= range.e.c; ++C) {
21292 if(R === range.s.r) cols[C] = encode_col(C);
21416 var range = safe_decode_range(ws['!ref'] || "A1");
21418 if(range.e.c > 0xFF || range.e.r >= MAX_ROWS) {
21420 range.e.c = Math.min(range.e.c, 0xFF);
21421 range.e.r = Math.min(range.e.c, MAX_ROWS-1);
21444 write_biff_rec(ba, 0x0200 /* Dimensions */, write_Dimensions(range, opts));
21449 for(var R = range.s.r; R <= range.e.r; ++R) {
21451 for(var C = range.s.c; C <= range.e.c; ++C) {
21452 if(R === range.s.r) cols[C] = encode_col(C);
21595 var range = decode_range(ws["!ref"]);
21596 if(range.e.c > 255) { // note: 255 is IV
21620 var range/*:Range*/ = {s:{r:10000000, c:10000000},e:{r:0,c:0}}; class in html_to_sheet
21645 if(range.s.r > R) range.s.r = R; if(range.e.r < R) range.e.r = R;
21646 if(range.s.c > C) range.s.c = C; if(range.e.c < C) range.e.c = C;
21663 ws['!ref'] = encode_range(range);
21755 var range/*:Range*/ = {s:{r:0,c:0},e:{r:or_R,c:or_C}}; class in sheet_add_dom
21758 range.s.r = Math.min(range.s.r, _range.s.r);
21759 range.s.c = Math.min(range.s.c, _range.s.c);
21760 range.e.r = Math.max(range.e.r, _range.e.r);
21761 range.e.c = Math.max(range.e.c, _range.e.c);
21762 if(or_R == -1) range.e.r = or_R = _range.e.r + 1;
21811 if(range.e.c < C + or_C) range.e.c = C + or_C;
21817 range.e.r = Math.max(range.e.r, R - 1 + or_R);
21818 ws['!ref'] = encode_range(range);
21819 …if(R >= sheetRows) ws['!fullref'] = encode_range((range.e.r = rows.length-_R+R-1 + or_R,range)); /…
22103 var R = -1, C = -1, range = {s: {r:1000000,c:10000000}, e: {r:0, c:0}}; class
22123 if(range.e.c >= range.s.c && range.e.r >= range.s.r) ws['!ref'] = encode_range(range);
22125 if(opts.sheetRows > 0 && opts.sheetRows <= range.e.r) {
22127 range.e.r = opts.sheetRows - 1;
22128 ws['!ref'] = encode_range(range);
22141 range.s.r = range.s.c = 10000000; range.e.r = range.e.c = 0;
22190 if(C > range.e.c) range.e.c = C;
22191 if(C < range.s.c) range.s.c = C;
22192 if(R < range.s.r) range.s.r = R;
22193 if(rptR > range.e.r) range.e.r = rptR;
22265 if(range.e.c <= C) range.e.c = C;
22399 case 'named-range': // 9.4.12 <table:named-range>
22401 _Ref = ods_to_csf_3D(tag['cell-range-address']);
22434 case 'label-range': break; // 9.4.9 <table:label-range>
22453 case 'database-range': // 9.4.15 <table:database-range>
22456 _Ref = ods_to_csf_3D(parsexmltag(Rn[0])['target-range-address']);
22534 case 'cell-range-source': break; // 9.3.1 <table:
22537 case 'highlighted-range': break; // 9.3.4 <table:
22541 case 'source-cell-range': // 9.6.5
22820 return " " + writextag("table:named-range", null, {
22822 "table:cell-range-address": odsref,
22843 var R=0,C=0, range = decode_range(ws['!ref']||"A1");
22847 …for(C = 0; C <= range.e.c; ++C) o.push(' <table:table-column' + (ws["!cols"][C] ? ' table:s…
22850 for(R = 0; R < range.s.r; ++R) {
22854 for(; R <= range.e.r; ++R) {
22857 for(C=0; C < range.s.c; ++C) o.push(null_cell_xml);
22858 for(; C <= range.e.c; ++C) {
22981 var range = decode_range(ws["!ref"]);
22982 for(var R = 0; R <= range.e.r; ++R) for(var C = 0; C <= range.e.c; ++C) {
24039 var range = { s: { r: 0, c: 0 }, e: { r: 0, c: 0 } }; class in parse_TST_TableModelArchive
24040 range.e.r = (varint_to_i32(pb[6][0].data) >>> 0) - 1;
24041 if (range.e.r < 0)
24043 range.e.c = (varint_to_i32(pb[7][0].data) >>> 0) - 1;
24044 if (range.e.c < 0)
24046 ws["!ref"] = encode_range(range);
24769 var range = decode_range(ws["!ref"]);
24770 range.s.r = range.s.c = 0;
24772 if (range.e.c > 999) {
24774 range.e.c = 999;
24776 if (range.e.r > 999999) {
24778 range.e.r = 999999;
24781 console.error("Truncating to ".concat(encode_range(range)));
24782 var data = sheet_to_json(ws, { range: range, header: 1 });
24789 pb[6][0].data = write_varint49(range.e.r + 1);
24790 pb[7][0].data = write_varint49(range.e.c + 1);
24810 for (var C = 0; C <= range.e.c; ++C) {
24813 _bucket[4][0].data = write_varint49(range.e.r + 1);
24861 var ntiles = Math.ceil((range.e.r + 1) / tstride);
24872 [{ type: 0, data: write_varint49(Math.min(range.e.r + 1, (tidx + 1) * tstride)) }],
24874 …[{ type: 0, data: write_varint49(Math.min((tidx + 1) * tstride, range.e.r + 1) - tidx * tstride) }…
24880 for (var R = tidx * tstride; R <= Math.min(range.e.r, (tidx + 1) * tstride - 1); ++R) {
26038 var range = o.range != null ? o.range : sheet["!ref"];
26043 switch(typeof range) {
26044 case 'string': r = safe_decode_range(range); break;
26045 case 'number': r = safe_decode_range(sheet["!ref"]); r.s.r = range; break;
26046 default: r = range;
26193 var range/*:Range*/ = ({s: {c:0, r:0}, e: {c:_C, r:_R + js.length - 1 + offset}}/*:any*/); class in sheet_add_json
26196 range.e.c = Math.max(range.e.c, _range.e.c);
26197 range.e.r = Math.max(range.e.r, _range.e.r);
26198 if(_R == -1) { _R = _range.e.r + 1; range.e.r = _R + js.length - 1 + offset; }
26200 if(_R == -1) { _R = 0; range.e.r = js.length - 1 + offset; }
26238 range.e.c = Math.max(range.e.c, _C + hdr.length - 1);
26245 ws['!ref'] = encode_range(range);
26337 …_set_internal_link(cell/*:Cell*/, range/*:string*/, tooltip/*:?string*/) { return cell_set_hyperli… argument
26346 function sheet_set_array_formula(ws/*:Worksheet*/, range, formula/*:string*/, dynamic/*:boolean*/) { argument
26347 var rng = typeof range != "string" ? range : safe_decode_range(range);
26348 var rngstr = typeof range == "string" ? range : encode_range(range);
26475 var range = o.range != null ? o.range : sheet["!ref"];
26479 switch(typeof range) {
26480 case 'string': r = safe_decode_range(range); break;
26481 case 'number': r = safe_decode_range(sheet["!ref"]); r.s.r = range; break;
26482 default: r = range;