Lines Matching refs:r
684 function write_num_f1(r/*:Array<string>*/, aval/*:number*/, sign/*:string*/)/*:string*/ { argument
685 var den = parseInt(r[4],10), rr = Math.round(aval * den), base = Math.floor(rr/den);
687 …) + " " + (myn === 0 ? fill(" ", r[1].length + 1 + r[4].length) : pad_(myn,r[1].length) + r[2] + "…
689 function write_num_f2(r/*:Array<string>*/, aval/*:number*/, sign/*:string*/)/*:string*/ { argument
690 return sign + (aval === 0 ? "" : ""+aval) + fill(" ", r[1].length + 2 + r[4].length);
732 var r/*:?Array<string>*/, ri, ff, aval = Math.abs(val), sign = val < 0 ? "-" : "";
738 if((r = fmt.match(frac1))) return write_num_f1(r, aval, sign);
740 if((r = fmt.match(dec1))) {
741 …r[1].length).replace(/^([^\.]+)$/,"$1."+hashq(r[1])).replace(/\.$/,"."+hashq(r[1])).replace(/\.(\d…
745 if((r = fmt.match(/^(0*)\.(#*)$/))) {
746 …return sign + rnd(aval, r[2].length).replace(/\.(\d*[1-9])0*$/,".$1").replace(/^(-?\d*)$/,"$1.").r…
748 if((r = fmt.match(/^#{1,3},##0(\.?)$/))) return sign + commaify(pad0r(aval,0));
749 if((r = fmt.match(/^#,##0\.([#0]*0)$/))) {
750 … -val) : commaify(""+(Math.floor(val) + carry(val, r[1].length))) + "." + pad0(dec(val, r[1].lengt…
752 if((r = fmt.match(/^#,#*,#0/))) return write_num_flt(type,fmt.replace(/^#,#*,/,""),val);
753 if((r = fmt.match(/^([0#]+)(\\?-([0#]+))+$/))) {
763 if((r = fmt.match(/^([#0?]+)( ?)\/( ?)([#0?]+)/))) {
764 ri = Math.min(/*::String(*/r[4]/*::)*/.length,7);
767 oa = write_num("n", /*::String(*/r[1]/*::)*/, ff[1]);
769 o += oa + /*::String(*/r[2]/*::)*/ + "/" + /*::String(*/r[3]/*::)*/;
771 if(oa.length < r[4].length) oa = hashq(r[4].substr(r[4].length-oa.length)) + oa;
775 if((r = fmt.match(/^# ([#0?]+)( ?)\/( ?)([#0?]+)/))) {
776 ri = Math.min(Math.max(r[1].length, r[4].length),7);
778 … "0")) + " " + (ff[1] ? pad_(ff[1],ri) + r[2] + "/" + r[3] + rpad_(ff[2],ri): fill(" ", 2*ri+1 + r…
780 if((r = fmt.match(/^[#0?]+$/))) {
785 if((r = fmt.match(/^([#0?]+)\.([#0]+)$/))) {
786 o = "" + val.toFixed(Math.min(r[2].length,10)).replace(/([^0])0+$/,"$1");
791 if((r = fmt.match(/^00,000\.([#0]*0)$/))) {
792 ri = dec(val, r[1].length);
793 … { return "00," + ($$.length < 3 ? pad0(0,3-$$.length) : "") + $$; }) + "." + pad0(ri,r[1].length);
848 var r/*:?Array<string>*/, ri, ff, aval = Math.abs(val), sign = val < 0 ? "-" : "";
854 if((r = fmt.match(frac1))) return write_num_f2(r, aval, sign);
856 if((r = fmt.match(dec1))) {
857 /*:: if(!Array.isArray(r)) throw new Error("unreachable"); */
858 o = (""+val).replace(/^([^\.]+)$/,"$1."+hashq(r[1])).replace(/\.$/,"."+hashq(r[1]));
860 /*:: if(!Array.isArray(r)) throw new Error("unreachable"); */
861 return "." + $1 + fill("0", hashq(r[1]).length-$1.length); });
865 if((r = fmt.match(/^(0*)\.(#*)$/))) {
866 …).replace(/\.(\d*[1-9])0*$/,".$1").replace(/^(-?\d*)$/,"$1.").replace(/^0\./,r[1].length?"0.":".");
868 if((r = fmt.match(/^#{1,3},##0(\.?)$/))) return sign + commaify((""+aval));
869 if((r = fmt.match(/^#,##0\.([#0]*0)$/))) {
870 …return val < 0 ? "-" + write_num_int(type, fmt, -val) : commaify((""+val)) + "." + fill('0',r[1].l…
872 if((r = fmt.match(/^#,#*,#0/))) return write_num_int(type,fmt.replace(/^#,#*,/,""),val);
873 if((r = fmt.match(/^([0#]+)(\\?-([0#]+))+$/))) {
883 if((r = fmt.match(/^([#0?]+)( ?)\/( ?)([#0?]+)/))) {
884 ri = Math.min(/*::String(*/r[4]/*::)*/.length,7);
887 oa = write_num("n", /*::String(*/r[1]/*::)*/, ff[1]);
889 o += oa + /*::String(*/r[2]/*::)*/ + "/" + /*::String(*/r[3]/*::)*/;
891 if(oa.length < r[4].length) oa = hashq(r[4].substr(r[4].length-oa.length)) + oa;
895 if((r = fmt.match(/^# ([#0?]+)( ?)\/( ?)([#0?]+)/))) {
896 ri = Math.min(Math.max(r[1].length, r[4].length),7);
898 … "0")) + " " + (ff[1] ? pad_(ff[1],ri) + r[2] + "/" + r[3] + rpad_(ff[2],ri): fill(" ", 2*ri+1 + r…
900 if((r = fmt.match(/^[#0?]+$/))) {
905 if((r = fmt.match(/^([#0]+)\.([#0]+)$/))) {
906 o = "" + val.toFixed(Math.min(r[2].length,10)).replace(/([^0])0+$/,"$1");
911 if((r = fmt.match(/^00,000\.([#0]*0)$/))) {
912 …) { return "00," + ($$.length < 3 ? pad0(0,3-$$.length) : "") + $$; }) + "." + pad0(0,r[1].length);
1500 function namecmp(l/*:string*/, r/*:string*/)/*:number*/ { argument
1501 var L = l.split("/"), R = r.split("/");
2979 return o.join("\r\n") + "\r\n";
2986 - \r\n newlines can be preserved, but bare \r and \n must be escaped
2987 - lines must not exceed 76 characters, use soft breaks =\r\n
3005 …encoded = encoded.replace(/\r(?!\n)/mg, "=0D").replace(/\n\n/mg, "\n=0A").replace(/([^\r\n])\n/mg,…
3007 var o/*:Array<string>*/ = [], split = encoded.split("\r\n");
3024 return o.join("\r\n");
3038 return s2a(o.join("\r\n"));
3069 var data = (has_buf && Buffer.isBuffer(file) ? file.toString("binary") : a2s(file)).split("\r\n");
3150 out.push(boundary + '--\r\n');
3151 return out.join("\r\n");
3300 var infile = File(path); infile.open("r"); infile.encoding = "binary";
3611 var XML_HEADER = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>\r\n';
3669 return xlsx ? out.replace(/\r\n/g, "\n") : out;
3697 function xlml_unfixstr(str/*:string*/)/*:string*/ { return str.replace(/(\r\n|[\r\n])/g,"\ "); }
3792 .replace(/^[\t\n\r ]+/, "")
3794 .replace(/[\t\n\r ]+$/,"")
3798 .replace(/[\t\n\r ]+/g, " ")
3873 'r': 'http://schemas.openxmlformats.org/officeDocument/2006/relationships', property in XMLNS
4231 if(out.rRel) out.r += tgt.s.r;
4234 if(out.rRel) out.r += tgt.r;
4238 while(out.r >= 0x10000) out.r -= 0x10000;
4252 …if(c.rRel && c.r < 0) { c = dup(c); while(c.r < 0) c.r += (biff > 8) ? 0x100000 : ((biff > 5) ? 0x…
4259 function encode_range_xls(r, opts)/*:string*/ { argument
4260 if(r.s.r == 0 && !r.s.rRel) {
4261 if(r.e.r == (opts.biff >= 12 ? 0xFFFFF : (opts.biff >= 8 ? 0x10000 : 0x4000)) && !r.e.rRel) {
4262 …return (r.s.cRel ? "" : "$") + encode_col(r.s.c) + ":" + (r.e.cRel ? "" : "$") + encode_col(r.e.c);
4265 if(r.s.c == 0 && !r.s.cRel) {
4266 if(r.e.c == (opts.biff >= 12 ? 0x3FFF : 0xFF) && !r.e.cRel) {
4267 …return (r.s.rRel ? "" : "$") + encode_row(r.s.r) + ":" + (r.e.rRel ? "" : "$") + encode_row(r.e.r);
4270 return encode_cell_xls(r.s, opts.biff) + ":" + encode_cell_xls(r.e, opts.biff);
4283 …ellAddress*/ { var splt = split_cell(cstr); return { c:decode_col(splt[0]), r:decode_row(splt[1]) …
4291 return { c: C - 1, r:R - 1 };
4293 …on encode_cell(cell/*:CellAddress*/)/*:string*/ { return encode_col(cell.c) + encode_row(cell.r); }
4298 return s + (cell.r + 1);
4320 …n "$" + encode_col(s.s.c) + "$" + encode_row(s.s.r) + ":$" + encode_col(s.e.c) + "$" + encode_row(…
4331 var o = {s:{c:0,r:0},e:{c:0,r:0}}; property in safe_decode_range.o.e
4344 o.s.r = --idx;
4346 if(i === len || cc != 10) { o.e.c=o.s.c; o.e.r=o.s.r; return o; }
4359 o.e.r = --idx;
4394 _R = _origin.r; _C = _origin.c;
4398 var range/*:Range*/ = ({s: {c:10000000, r:10000000}, e: {c:0, r:0}}/*:any*/); property in sheet_add_aoa.range.e
4402 range.s.r = _range.s.r;
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;
4416 if(range.e.r < __R) range.e.r = __R;
4441 var cell_ref = encode_cell(({c:__C,r:__R}/*:any*/));
4501 z.r = rgsStrRun;
4503 else z.r = [{ ich: 0, ifnt: 0 }];
4605 cell.s.r = data.read_shift(4);
4606 cell.e.r = data.read_shift(4);
4611 function write_RfX(r/*:Range*/, o) { argument
4613 o.write_shift(4, r.s.r);
4614 o.write_shift(4, r.e.r);
4615 o.write_shift(4, r.s.c);
4616 o.write_shift(4, r.e.c);
5594 var r = new Array(CORE_PROPS.length);
5598 r[i] = new RegExp("<" + g + "[^>]*>([\\s\\S]*?)<\/" + g + ">");
5600 return r;
6372 if(!fRichSt) { z.raw = "<t>" + z.t + "</t>"; z.r = z.t; }
6553 …ob/*::, length*/) { var r = blob.read_shift(1), g = blob.read_shift(1), b = blob.read_shift(1), a …
6564 return ({r:rw, c:col, ixfe:ixfe}/*:any*/);
6618 return {s:{c:colFirst, r:rwFirst}, e:{c:colLast,r:rwLast}};
6620 function write_Ref8U(r/*:Range*/, o) { argument
6622 o.write_shift(2, r.s.r);
6623 o.write_shift(2, r.e.r);
6624 o.write_shift(2, r.s.c);
6625 o.write_shift(2, r.e.c);
6635 return {s:{c:colFirst, r:rwFirst}, e:{c:colLast,r:rwLast}};
6850 z.r = blob.read_shift(2);
7025 var r = blob.read_shift(w), R = blob.read_shift(w);
7028 return {s: {r:r, c:c}, e: {r:R, c:C}};
7033 o.write_shift(w, range.s.r);
7034 o.write_shift(w, range.e.r + 1);
7045 return {r:rw, c:col, ixfe:rkrec[0], rknum:rkrec[1]};
7057 return {r:rw, c:col, C:lastcol, rkrec:rkrecs};
7068 return {r:rw, c:col, C:lastcol, ixfe:ixfes};
7318 return [{r:row,c:col}, stAuthor, idObj, flags];
7437 O.write_shift(2, ref.r); O.write_shift(2, ref.r);
7458 O.write_shift(2, ref.r); O.write_shift(2, ref.r);
7594 function write_BIFF2NUM(r/*:number*/, c/*:number*/, val/*:number*/) { argument
7596 write_BIFF2Cell(out, r, c);
7609 function write_BIFF2INT(r/*:number*/, c/*:number*/, val/*:number*/) { argument
7611 write_BIFF2Cell(out, r, c);
7763 …de(current_cp, d.slice(d.l, d.l+ww)) : a2s(d.slice(d.l, d.l + ww))).replace(/[\u0000\r\n].*$/g,"");
8060 var records = str.split(/[\n\r]+/), R = -1, C = -1, ri = 0, rj = 0, arr/*:AOA*/ = [];
8124 formula = rc_to_a1(record[rj].slice(1), {r:R,c:C});
8147 formula = shift_formula_str(shrbase[1], {r: R - _R, c: C - _C});
8219 if(cell.f && !cell.F) o += ";E" + a1_to_rc(cell.f, {r:R, c:C}); break;
8254 var r = safe_decode_range(ws['!ref']), cell/*:Cell*/;
8256 var RS = "\r\n";
8264 …preamble.push("B;Y" + (r.e.r - r.s.r + 1) + ";X" + (r.e.c - r.s.c + 1) + ";D" + [r.s.c,r.s.r,r.e.c…
8266 for(var R = r.s.r; R <= r.e.r; ++R) {
8268 for(var C = r.s.c; C <= r.e.c; ++C) {
8269 var coord = encode_cell({r:R,c:C});
8338 …function make_value(v/*:number*/, s/*:string*/)/*:string*/ { return "0," + String(v) + "\r\n" + s;…
8339 …function make_value_str(s/*:string*/)/*:string*/ { return "1,0\r\n\"" + s.replace(/"/g,'""') + '"'…
8342 var r = safe_decode_range(ws['!ref']);
8345 "TABLE\r\n0,1\r\n\"sheetjs\"\r\n",
8346 "VECTORS\r\n0," + (r.e.r - r.s.r + 1) + "\r\n\"\"\r\n",
8347 "TUPLES\r\n0," + (r.e.c - r.s.c + 1) + "\r\n\"\"\r\n",
8348 "DATA\r\n0,0\r\n\"\"\r\n"
8350 for(var R = r.s.r; R <= r.e.r; ++R) {
8351 var p = "-1,0\r\nBOT\r\n";
8352 for(var C = r.s.c; C <= r.e.c; ++C) {
8353 var cell/*:Cell*/ = dense ? (ws[R] && ws[R][C]) : ws[encode_cell({r:R,c:C})];
8354 if(cell == null) { p +=("1,0\r\n\"\"\r\n"); continue;}
8358 if(cell.w != null) p +=("0," + cell.w + "\r\nV");
8361 else p +=("1,0\r\n\"\"");
8363 if(cell.v == null) p +=("1,0\r\n\"\"");
8378 default: p +=("1,0\r\n\"\"");
8380 p += "\r\n";
8384 return o.join("") + "-1,0\r\nEOD";
8403 if(arr.length <= addr.r) for(R = arr.length; R <= addr.r; ++R) if(!arr[R]) arr[R] = [];
8404 R = addr.r; C = addr.c;
8447 var r = decode_range(ws['!ref']);
8449 for(var R = r.s.r; R <= r.e.r; ++R) {
8450 for(var C = r.s.c; C <= r.e.c; ++C) {
8451 coord = encode_cell({r:R,c:C});
8475 o.push("sheet:c:" + (r.e.c-r.s.c+1) + ":r:" + (r.e.r-r.s.r+1) + ":tvf:1");
8508 var lines = f.split(/[\r\n]/);
8575 var range/*:Range*/ = ({s: {c:0, r:0}, e: {c:0, r:0}}/*:any*/); property in PRN.dsv_to_sheet_str.range.e
8578 // If the line ends in \r\n
8582 // If line ends in \r OR \n
8594 var s = str.slice(start, end); if(s.slice(-1) == "\r") s = s.slice(0, -1);
8621 else ws[encode_cell({c:C,r:R})] = cell;
8624 if(range.e.r < R) range.e.r = R;
8675 var r = safe_decode_range(ws['!ref']), cell/*:Cell*/;
8677 for(var R = r.s.r; R <= r.e.r; ++R) {
8679 for(var C = r.s.c; C <= r.e.c; ++C) {
8680 var coord = encode_cell({r:R,c:C});
8746 var refguess = {s: {r:0, c:0}, e: {r:0, c:0} }; property in WK_.lotus_to_workbook_buf.refguess.s
8773 if(o.works || o.works2) val[1].v = val[1].v.replace(/\r\n/g, "\n");
8790 refguess = {s: {r:0, c:0}, e: {r:0, c:0} }; property in WK_.lotus_to_workbook_buf.AnonymousFunction701aad5b3300.refguess.e
8795 var tmpcell = o.dense ? (s[val[0].r]||[])[val[0].c] : s[encode_cell(val[0])];
8803 if(!s[val[0].r]) s[val[0].r] = [];
8804 s[val[0].r][val[0].c] = val[1];
8818 …./g, function($$) { return String.fromCharCode($$.charCodeAt(1) - 0x20); }).replace(/\r\n/g, "\n");
8831 refguess = {s: {r:0, c:0}, e: {r:0, c:0} }; property in WK_.lotus_to_workbook_buf.AnonymousFunction701aad5b3400.refguess.e
8834 if(sheetRows > 0 && val[0].r >= sheetRows) break;
8836 if(!s[val[0].r]) s[val[0].r] = [];
8837 s[val[0].r][val[0].c] = val[1];
8840 if(refguess.e.r < val[0].r) refguess.e.r = val[0].r;
8877 var max_R = Math.min(range.e.r, 8191);
8878 for(var R = range.s.r; R <= max_R; ++R) {
8881 if(R === range.s.r) cols[C] = encode_col(C);
8917 var max_R = Math.min(range.e.r, 8191);
8918 for(var R = range.s.r; R <= max_R; ++R) {
8921 if(R === range.s.r) cols[C] = encode_col(C);
8961 if(rows < range.e.r) rows = range.e.r;
8978 var o = {s:{c:0,r:0},e:{c:0,r:0}};
8982 o.s.r = blob.read_shift(2);
8985 o.e.r = blob.read_shift(2);
8989 o.s.r = blob.read_shift(2);
8992 o.e.r = blob.read_shift(2);
8994 if(o.s.c == 0xFFFF) o.s.c = o.e.c = o.s.r = o.e.r = 0;
9000 out.write_shift(2, range.s.r);
9002 out.write_shift(2, range.e.r);
9007 var o = [{c:0,r:0}, {t:'n',v:0}, 0, 0];
9011 o[0].r = blob.read_shift(2);
9014 o[0].c = blob.read_shift(2); o[0].r = blob.read_shift(2);
9018 o[0].c = blob.read_shift(2); o[0].r = blob.read_shift(2);
9217 R = wk1_parse_rc(o[0].r, blob.read_shift(2), false);
9222 var r = wk1_parse_rc(o[0].r, blob.read_shift(2), false);
9224 R = wk1_parse_rc(o[0].r, blob.read_shift(2), false);
9225 out.push(c + r + ":" + C + R);
9273 var o = [{c:0,r:0}, {t:'n',v:0}, 0];
9274 o[0].r = blob.read_shift(2); o[3] = blob[blob.l++]; o[0].c = blob[blob.l++];
9636 var range = {s:{r:-1,c:-1}, e:{r:-1,c:-1}};
9674 range.s.r = p.read_shift(4);
9675 range.e.r = p.read_shift(4);
9687 if(range.s.c > 0xFF || range.s.r > 999999) break;
9689 if(range.e.r < range.s.r) range.e.r = range.s.r;
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;
9733 } else s[encode_cell({r:R, c:C})] = cell;
9752 } else s[encode_cell({r:R, c:C})] = cell;
9882 /* 18.4.4 r CT_RElt */
9883 function parse_r(r) { argument
9885 var t = r.match(tregex)/*, cp = 65001*/;
9889 var rpr = r.match(rpregex);
9893 var rregex = /<(?:\w+:)?r>/g, rend = /<\/(?:\w+:)?r>/;
9895 return rs.replace(rregex,"").split(rend).map(parse_r).filter(function(r) { return r.v; });
9900 /* Parse a list of <r> tags */
9902 var nlregex = /(\r\n|\n)/g;
9926 /* 18.4.4 r CT_RElt */
9927 function r_to_html(r) { argument
9928 var terms/*:[Array<string>, string, Array<string>]*/ = [[],r.v,[]];
9929 if(!r.v) return "";
9931 if(r.s) parse_rpr2(r.s, terms[0], terms[2]);
9942 var sitregex = /<(?:\w+:)?t[^>]*>([^<]*)<\/(?:\w+:)?t>/g, sirregex = /<(?:\w+:)?r>/;
9953 z.r = utf8read(x);
9956 /* 18.4.4 r CT_RElt (Rich Text Run) */
9958 z.r = utf8read(x);
9960 if(html) z.h = rs_to_html(parse_rs(z.r));
9987 var straywsregex = /^\s|\s$|[\t\n\r]/;
9999 if(s.r) sitag += s.r;
10396 var range = { s: { c: 0, r: 0 }, e: { c: 0, r: rows.length - 1 } }; property in rtf_to_sheet_str.range.s
10428 ws[encode_cell({ r: R, c: C })] = cell;
10453 var r = safe_decode_range(ws["!ref"]), cell;
10455 for (var R = r.s.r; R <= r.e.r; ++R) {
10457 for (var C = r.s.c; C <= r.e.c; ++C)
10460 for (C = r.s.c; C <= r.e.c; ++C) {
10461 var coord = encode_cell({ r: R, c: C });
10467 o.push(" " + (cell.w || (format_cell(cell), cell.w) || "").replace(/[\r\n]/g, "\\par "));
10883 [[5,8],[23,26],[41,44],[/*63*/50,/*66],[164,*/392]].forEach(function(r) { argument
10884 …for(var i = r[0]; i <= r[1]; ++i) if(NF[i] != null) o[o.length] = (writextag('numFmt',null,{numFmt…
11292 [[5,8],[23,26],[41,44],[/*63*/50,/*66],[164,*/392]].forEach(function(r) { argument
11294 for(var i = r[0]; i <= r[1]; ++i) if(NF[i] != null) ++cnt;
11299 [[5,8],[23,26],[41,44],[/*63*/50,/*66],[164,*/392]].forEach(function(r) { argument
11301 …for(var i = r[0]; i <= r[1]; ++i) if(NF[i] != null) write_record(ba, 0x002C /* BrtFmt */, write_Br…
11669 …o[o.length] = '<a:path path="circle"><a:fillToRect l="50000" t="-80000" r="50000" b="180000"/…
11676 …o[o.length] = '<a:path path="circle"><a:fillToRect l="50000" t="50000" r="50000" b="50000"/><…
11843 val.forEach(function(r) { argument
11845 out.Cell.push({ type: out.Types[r[0] - 1].name, index: r[1] });
11847 out.Value.push({ type: out.Types[r[0] - 1].name, index: r[1] });
12006 cell.r = data.read_shift(4);
12008 out.r = encode_cell(cell);
12098 var id = (data.match(/<c:chart [^>]*r:id="([^"]*)"/)||["",""])[1];
12151 writetag('x:Anchor', [c.c+1, 0, c.r+1, 0, c.c+3, 20, c.r+5, 20].join(",")),
12153 writetag('x:Row', String(c.r)),
12164 var r = decode_cell(comment.ref);
12166 if(!sheet[r.r]) sheet[r.r] = [];
12167 cell = sheet[r.r][r.c];
12171 if(dense) sheet[r.r][r.c] = cell;
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;
12183 var o/*:Comment*/ = ({a: comment.author, t: comment.t, r: comment.r, T: threaded});
12218 if(opts.sheetRows && opts.sheetRows <= cell.r) return;
12220 var rt = !!textMatch && !!textMatch[1] && parse_si(textMatch[1]) || {r:"",t:"",h:""};
12221 comment.r = rt.r;
12222 if(rt.r == "<t></t>") rt.t = rt.h = "";
12223 comment.t = (rt.t||"").replace(/\r\n/g,"\n").replace(/\r/g,"\n");
12295 …case '</text>': comment.t = data.slice(tidx, idx).replace(/\r\n/g, "\n").replace(/\r/g, "\n"); bre…
12421 c.t = val.t; c.h = val.h; c.r = val.r; break;
12425 if(opts.sheetRows && c.rfx && opts.sheetRows <= c.rfx.r) break;
12508 var rcbase/*:Cell*/ = ({r:0,c:0}/*:any*/); property in rc_to_a1.rcbase
12521 if(rRel) R += rcbase.r; else --R;
12535 var r = decode_row($5) - ($4 ? 0 : base.r);
12536 var R = $4 == "$" ? (r+1) : (r == 0 ? "" : "[" + r + "]");
12546 …+$3 : encode_col(decode_col($3)+delta.c))+($4=="$" ? $4+$5 : encode_row(decode_row($5) + delta.r));
12551 var r = decode_range(range), s = r.s, c = decode_cell(cell);
12552 var delta = {r:c.r - s.r, c:c.c - s.c}; property in shift_formula_xlsx.delta
12580 var r=blob.read_shift(w), R=blob.read_shift(w);
12583 return { s:{r:r, c:c[0], cRel:c[1], rRel:c[2]}, e:{r:R, c:C[0], cRel:C[1], rRel:C[2]} };
12587 var r=parse_ColRelU(blob, 2), R=parse_ColRelU(blob, 2);
12590 return { s:{r:r[0], c:c, cRel:r[1], rRel:r[2]}, e:{r:R[0], c:C, cRel:R[1], rRel:R[2]} };
12596 var r=blob.read_shift(opts.biff == 12 ? 4 : 2), R=blob.read_shift(opts.biff == 12 ? 4 : 2);
12599 return { s:{r:r, c:c[0], cRel:c[1], rRel:c[2]}, e:{r:R, c:C[0], cRel:C[1], rRel:C[2]} };
12605 var r = blob.read_shift(opts && opts.biff == 12 ? 4 : 2);
12607 return {r:r, c:c[0], cRel:c[1], rRel:c[2]};
12610 var r = parse_ColRelU(blob, 2);
12612 return {r:r[0], c:c, cRel:r[1], rRel:r[2]};
12617 var r = blob.read_shift(2);
12619 return {r:r, c:c & 0xFF, fQuoted:!!(c & 0x4000), cRel:c>>15, rRel:c>>15 };
12626 var r = blob.read_shift(biff >= 12 ? 4 : 2);
12630 if(rRel == 1) while(r > 0x7FFFF) r -= 0x100000;
12632 return {r:r,c:cl,cRel:cRel,rRel:rRel};
12641 return {r:rl,c:c,cRel:cRel,rRel:rRel};
13223 var x = f[i], r/*:Array<string>*/ = [];
13230 r.push('"' + y[1].replace(/"/g,'""') + '"'); break;
13231 default: r.push(y[1]);
13232 } else r.push("");
13234 o.push(r.join(","));
13304 var _range = /*range != null ? range :*/ {s:{c:0, r:0},e:{c:0, r:0}}; property in stringify_formula._range.s
13305 …var stack/*:Array<string>*/ = [], e1, e2, /*::type,*/ c/*:CellAddress*/, ixti=0, nameidx=0, r, sna…
13338 sp = fill("\r", formula[0][last_sp][1][1]); break;
13412 /*::type = f[1][0]; */r = shift_range_xls(f[1][1], cell ? {s:cell} : _range, opts);
13413 stack.push(encode_range_xls((r/*:any*/), opts));
13416 /*::type = f[1][0]; */r = shift_range_xls(f[1][1], _range, opts);
13417 stack.push(encode_range_xls((r/*:any*/), opts));
13420 /*::type = f[1][0]; */ixti = /*::Number(*/f[1][1]/*::)*/; r = f[1][2];
13422 stack.push(sname + "!" + encode_range_xls((r/*:any*/), opts));
13480 case 3: lp = fill("\r", formula[0][last_sp][1][1]) + lp; break;
13484 case 5: rp = fill("\r", formula[0][last_sp][1][1]) + rp; break;
13500 c = {c:(f[1][1]/*:any*/),r:(f[1][0]/*:any*/)}; property in stringify_formula.case
13501 var q = ({c: cell.c, r:cell.r}/*:any*/); property in stringify_formula.q
13511 if(c.r < e2[0].s.r || c.r > e2[0].e.r) continue;
13597 sp = fill("\r", f[1][1]); break;
13798 out.write_shift(4, cell.r);
13817 out.write_shift(4, cell.r);
13852 out.write_shift(4, cell.r);
13859 out.write_shift(4, cell.r);
13886 out.write_shift(4, cell.r);
13893 out.write_shift(4, cell.r);
13917 out.write_shift(4, range.s.r);
13918 out.write_shift(4, range.e.r);
15101 function ods_to_csf_3D(r/*:string*/)/*:[string, string]*/ { argument
15102 r = r.replace(/\$'([^']|'')+'/g, function($$) { return $$.slice(1); });
15103 …r = r.replace(/\$([^\]\. #$]+)/g, function($$, $1) { return ($1).match(/^([A-Z]{1,2}|[A-W][A-Z]{2}…
15104 var a = r.split(":");
15109 function csf_to_ods_3D(r/*:string*/)/*:string*/ { argument
15110 return r.replace(/!/,".");
15238 …if(range.e.c < range.s.c || range.e.r < range.s.r) throw new Error("Bad range (" + i + "): " + ws[…
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);
15264 var refguess/*:Range*/ = ({s: {r:2000000, c:2000000}, e: {r:0, c:0} }/*:any*/); property in parse_ws_xml.refguess.s
15318 …if(!s["!ref"] && refguess.e.c >= refguess.s.c && refguess.e.r >= refguess.s.r) s["!ref"] = encode_…
15321 if(opts.sheetRows <= +tmpref.e.r) {
15322 tmpref.e.r = opts.sheetRows - 1;
15323 if(tmpref.e.r > refguess.e.r) tmpref.e.r = refguess.e.r;
15324 if(tmpref.e.r < tmpref.s.r) tmpref.s.r = tmpref.e.r;
15407 for(var R=rng.s.r;R<=rng.e.r;++R) for(var C=rng.s.c;C<=rng.e.c;++C) {
15408 var addr = encode_cell({c:C,r:R});
15466 if(range.s.r == range.e.r) { range.e.r = decode_range(ws["!ref"]).e.r; ref = encode_range(range); }
15482 (data.match(sviewregex)||[]).forEach(function(r/*:string*/, i/*:number*/) { argument
15483 var tag = parsexmltag(r);
15519 …var v = (cell.t == "z" || cell.v == null)? "" : writetag('v', escapexml(vv)), o = ({r:ref}/*:any*/… property in write_ws_xml_cell.o
15552 var rregex = /r=["']([^"']*)["']/, isregex = /<(?:\w+:)?is>([\S\s]*?)<\/(?:\w+:)?is>/;
15580 tagr = tag.r != null ? parseInt(tag.r, 10) : tagr+1; tagc = -1;
15593 tagr = tag.r != null ? parseInt(tag.r, 10) : tagr+1; tagc = -1;
15595 if(guess.s.r > tagr - 1) guess.s.r = tagr - 1;
15596 if(guess.e.r < tagr - 1) guess.e.r = tagr - 1;
15626 if(!tag.r) tag.r = encode_cell({r:tagr-1, c:tagc});
15644 sharedf[parseInt(ftag.si, 10)] = [ftag, ___f, tag.r];
15648 …edf[ftag.si]) p.f = shift_formula_xlsx(sharedf[ftag.si][1], sharedf[ftag.si][2]/*[0].ref*/, tag.r);
15651 var _tag = decode_cell(tag.r);
15653 if(_tag.r >= arrayf[i][0].s.r && _tag.r <= arrayf[i][0].e.r)
15682 p.r = sstr.r;
15728 var _r = decode_cell(tag.r);
15729 if(!s[_r.r]) s[_r.r] = [];
15730 s[_r.r][_r.c] = p;
15731 } else s[tag.r] = p;
15738 …var o/*:Array<string>*/ = [], r/*:Array<string>*/ = [], range = safe_decode_range(ws['!ref']), cel…
15740 var params = ({r:rr}/*:any*/), row/*:RowInfo*/, height = -1; property in write_ws_xml_data.params
15742 for(R = range.s.r; R <= range.e.r; ++R) {
15743 r = [];
15749 if((cell = write_ws_xml_cell(_cell, ref, ws, opts, idx, wb)) != null) r.push(cell);
15751 if(r.length > 0 || (rows && rows[R])) {
15752 params = ({r:rr}/*:any*/); property in write_ws_xml_data.params
15762 o[o.length] = (writextag('row', r.join(""), params));
15767 params = ({r:R+1}/*:any*/); property in params
15784 'xmlns:r': XMLNS.r
15791 if(range.e.c > 0x3FFF || range.e.r > 0xFFFFF) {
15794 range.e.r = Math.min(range.e.c, 0xFFFFF);
15851 rel["r:id"] = "rId"+rId;
15879 o[o.length] = writextag("drawing", null, {"r:id":"rId" + rId});
15885 o[o.length] = writextag("legacyDrawing", null, {"r:id":"rId" + rId});
15905 z.r = data.read_shift(4);
15942 var caddr = {r:R, c:0}; property in write_BrtRowHdr.caddr
15948 var cell = Array.isArray(ws) ? (ws[caddr.r]||[])[caddr.c] : ws[encode_cell(caddr)];
16183 cell.r = opts['!row'];
16199 cell.r = opts['!row'];
16215 cell.r = opts['!row'];
16231 cell.r = opts['!row'];
16415 var refguess = {s: {r:2000000, c:2000000}, e: {r:0, c:0} }; property in parse_ws_bin.refguess.e
16451 if(opts.sheetRows && opts.sheetRows <= row.r) end=true;
16452 rr = encode_row(R = row.r);
16453 opts['!row'] = row.r;
16456 rowinfo[val.r] = val;
16480 case 's': sstr = strs[val[1]]; p.v = sstr.t; p.r = sstr.r; break;
16494 if(row.r >= aii[0].s.r && row.r <= aii[0].e.r)
16502 if(refguess.s.r > row.r) refguess.s.r = row.r;
16504 if(refguess.e.r < row.r) refguess.e.r = row.r;
16523 if(refguess.s.r > row.r) refguess.s.r = row.r;
16525 if(refguess.e.r < row.r) refguess.e.r = row.r;
16550 for(R=val.rfx.s.r;R<=val.rfx.e.r;++R) for(C=val.rfx.s.c;C<=val.rfx.e.c;++C) {
16556 addr = encode_cell({c:C,r:R});
16567 cell.f = stringify_formula(val[1], refguess, {r:row.r, c:C}, supbooks, opts);
16574 cell.f = stringify_formula(val[1], refguess, {r:row.r, c:C}, supbooks, opts);
16686 …if(!s["!ref"] && (refguess.s.r < 2000000 || ref && (ref.e.r > 0 || ref.e.c > 0 || ref.s.r > 0 || r…
16689 if(opts.sheetRows <= +tmpref.e.r) {
16690 tmpref.e.r = opts.sheetRows - 1;
16691 if(tmpref.e.r > refguess.e.r) tmpref.e.r = refguess.e.r;
16692 if(tmpref.e.r < tmpref.s.r) tmpref.s.r = tmpref.e.r;
16707 var o/*:any*/ = ({r:R, c:C}/*:any*/); property in write_ws_bin_cell.o
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) {
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);
16837 if(range.s.r == range.e.r) { range.e.r = decode_range(ws["!ref"]).e.r; ref = encode_range(range); }
16883 var r = safe_decode_range(ws['!ref'] || "A1");
16884 if(r.e.c > 0x3FFF || r.e.r > 0xFFFFF) {
16886 r.e.c = Math.min(r.e.c, 0x3FFF);
16887 r.e.r = Math.min(r.e.c, 0xFFFFF);
16894 write_record(ba, 0x0094 /* BrtWsDim */, write_BrtWsDim(r));
16961 var refguess = {s: {r:2000000, c:2000000}, e: {r:0, c:0} }; property in parse_chart.refguess.s
16966 refguess.s.r = refguess.s.c = 0;
16973 if(refguess.e.r < R) refguess.e.r = R;
16992 if((m = data.match(/drawing r:id="(.*?)"/))) s['!rel'] = m[1];
17000 // 'xmlns:r': XMLNS.r
17002 // o[o.length] = writextag("drawing", null, {"r:id": "rId1"});
17402 'xmlns:r': XMLNS.r
17444 sht["r:id"] = "rId"+(i+1);
18005 cell.t = 's'; cell.r = xlml_fixstr(unescapexml(xml));
18006 …cell.v = (xml.indexOf("<") > -1 ? unescapexml(ss||xml).replace(/<.*?>/g, "") : cell.r); // todo: B…
18040 if(base.r >= arrayf[i][0].s.r && base.r <= arrayf[i][0].e.r)
18060 comment.t = comment.t.replace(/\r\n/g,"\n").replace(/\r/g,"\n");
18105 var c = 0, r = 0; variable
18106 var refguess/*:Range*/ = {s: {r:2000000, c:2000000}, e: {r:0, c:0} }; property in refguess.s
18127 … dtag, state[state.length-1][0]==/*"Comment"*/"comment"?comment:cell, {c:c,r:r}, styles, cstys[c],…
18133 if((!opts.sheetRows || opts.sheetRows > r) && cell.v !== void 0) {
18135 if(!cursheet[r]) cursheet[r] = [];
18136 cursheet[r][c] = cell;
18137 } else cursheet[encode_col(c) + encode_row(r)] = cell;
18146 rr = r + (parseInt(cell.MergeDown,10)|0);
18147 if(cc > c || rr > r) merges.push({s:{c:c,r:r},e:{c:cc,r:rr}});
18153 for(var cmd = r; cmd <= rr; ++cmd) {
18154 if(cma > c || cmd > r) {
18176 if(r < refguess.s.r) refguess.s.r = r;
18177 if(r > refguess.e.r) refguess.e.r = r;
18180 if(row.Index) r = +row.Index - 1;
18182 c = 0; ++r;
18185 if(row.Index) r = +row.Index - 1;
18189 rowinfo[r] = rowobj;
18191 if(row.Hidden == "1") { rowobj.hidden = true; rowinfo[r] = rowobj; }
18198 if(refguess.s.r <= refguess.e.r && refguess.s.c <= refguess.e.c) {
18200 if(opts.sheetRows && opts.sheetRows <= refguess.e.r) {
18202 refguess.e.r = opts.sheetRows - 1;
18211 refguess = {s: {r:2000000, c:2000000}, e: {r:0, c:0} }; property in refguess.e
18212 r = c = 0;
18266 Ref: rc_to_a1(_NamedRange.RefersTo.slice(1), {r:0, c:0})
18857 …ce(0,6) == "_xlnm." ? n.Name.slice(6) : n.Name, "ss:RefersTo":"=" + a1_to_rc(n.Ref, {r:0,c:0})}); }
19011 …attr["ss:ArrayRange"] = "RC:R" + (end.r == addr.r ? "" : "[" + (end.r - addr.r) + "]") + "C" + (en…
19022 if(marr[mi].s.c != addr.c || marr[mi].s.r != addr.r) continue;
19024 if(marr[mi].e.r > marr[mi].s.r) attr['ss:MergeDown'] = marr[mi].e.r - marr[mi].s.r;
19073 for(var R = range.s.r; R <= range.e.r; ++R) {
19079 if(marr[mi].s.r > R) continue;
19081 if(marr[mi].e.r < R) continue;
19082 if(marr[mi].s.c != C || marr[mi].s.r != R) skip = true;
19086 var addr = {r:R,c:C}; property in write_ws_xlml_table.addr
19110 ….push('<AutoFilter x:Range="' + a1_to_rc(fix_range(ws["!autofilter"].ref), {r:0,c:0}) + '" xmlns="…
19280 if(options.sheetRows && cell.r >= options.sheetRows) return;
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;
19288 if(cell.r + 1 > range.e.r) range.e.r = cell.r + 1;
19292 if(arrayf[afi][0].s.c > cell.c || arrayf[afi][0].s.r > cell.r) continue;
19293 if(arrayf[afi][0].e.c < cell.c || arrayf[afi][0].e.r < cell.r) continue;
19295 if(arrayf[afi][0].s.c != cell.c || arrayf[afi][0].s.r != cell.r) delete line.f;
19302 if(!out[cell.r]) out[cell.r] = [];
19303 out[cell.r][cell.c] = line;
19357 if(R.r === 2 || R.r == 12) {
19360 if(R.r == 12){
19450 if(range.e.r > 0 && range.e.c > 0) {
19451 range.e.r--; range.e.c--;
19453 if(options.sheetRows && options.sheetRows <= range.e.r) {
19454 var tmpri = range.e.r;
19455 range.e.r = options.sheetRows - 1;
19458 range.e.r = tmpri;
19460 range.e.r++; range.e.c++;
19495 range = {s:{r:0,c:0},e:{r:0,c:0}}; property in range.s
19512 …ut["!type"] == "chart") if(options.dense ? (out[val.r]||[])[val.c]: out[encode_cell({c:val.c, r:va…
19516 addcell({c:val.c, r:val.r}, temp_val, options);
19522 addcell({c:val.c, r:val.r}, temp_val, options);
19528 addcell({c:val.c, r:val.r}, temp_val, options);
19536 addcell({c:j, r:val.r}, temp_val, options);
19547 var _fe = encode_cell({r:_fr, c:_fc});
19574 cc = options.dense ? (out[val[0].s.r]||[])[val[0].s.c] : out[_arraystart];
19588 …cc = options.dense ? (out[last_formula.cell.r]||[])[last_formula.cell.c] : out[encode_cell(last_fo…
19598 addcell({c:val.c, r:val.r}, temp_val, options);
19604 addcell({c:val.c, r:val.r}, temp_val, options);
19612 addcell({c:_j, r:val.r}, temp_val, options);
19621 addcell({c:val.c, r:val.r}, temp_val, options);
19651 for(rngR = val[0].s.r; rngR <= val[0].e.r; ++rngR)
19653 cc = options.dense ? (out[rngR]||[])[rngC] : out[encode_cell({c:rngC,r:rngR})];
19658 for(rngR = val[0].s.r; rngR <= val[0].e.r; ++rngR)
19660 cc = options.dense ? (out[rngR]||[])[rngC] : out[encode_cell({c:rngC,r:rngR})];
19666 cc = options.dense ? (out[val[0].r]||[])[val[0].c] : out[encode_cell(val[0])];
19670 if(!out[val[0].r]) out[val[0].r] = [];
19671 cc = out[val[0].r][val[0].c] = ({t:"z"}/*:any*/);
19675 range.e.r = Math.max(range.e.r, val[0].r);
19676 range.s.r = Math.min(range.s.r, val[0].r);
19695 if(val.level != null) { rowinfo[val.r] = rowobj; rowobj.level = val.level; }
19696 if(val.hidden) { rowinfo[val.r] = rowobj; rowobj.hidden = true; }
19698 rowinfo[val.r] = rowobj;
19740 …if(wb.Sheets) FilterDatabases.forEach(function(r,i) { wb.Sheets[wb.SheetNames[i]]['!autofilter'] =… argument
20917 /*::[*/0x01c1/*::]*/: { /* n:"RecalcId", */ f:parse_RecalcId, r:2}, property in XLSRecordEnum.0x01c1
20968 /*::[*/0x0863/*::]*/: { /* n:"BookExt", */ r:12}, property in XLSRecordEnum.0x0863
20987 /*::[*/0x087c/*::]*/: { /* n:"XFCRC", */ f:parse_XFCRC, r:12 }, property in XLSRecordEnum.0x087c
20988 /*::[*/0x087d/*::]*/: { /* n:"XFExt", */ f:parse_XFExt, r:12 }, property in XLSRecordEnum.0x087d
20999 /*::[*/0x088c/*::]*/: { /* n:"Compat12", */ f:parsebool, r:12 }, property in XLSRecordEnum.0x088c
21001 /*::[*/0x088e/*::]*/: { /* n:"TableStyles", */ r:12 }, property in XLSRecordEnum.0x088e
21006 /*::[*/0x0894/*::]*/: { /* n:"NameCmt", */ f:parse_NameCmt, r:12 }, property in XLSRecordEnum.0x0894
21008 /*::[*/0x0896/*::]*/: { /* n:"Theme", */ f:parse_Theme, r:12 }, property in XLSRecordEnum.0x0896
21012 /*::[*/0x089a/*::]*/: { /* n:"MTRSettings", */ f:parse_MTRSettings, r:12 }, property in XLSRecordEnum.0x089a
21189 /*::[*/0x08d6/*::]*/: { /* n:"FRTArchId$", */ r:12 }, property in XLSRecordEnum.0x08d6
21237 function write_BIFF2Cell(out, r/*:number*/, c/*:number*/) { argument
21239 out.write_shift(2, r);
21246 function write_BIFF2BERR(r/*:number*/, c/*:number*/, val, t/*:?string*/) { argument
21248 write_BIFF2Cell(out, r, c);
21254 function write_BIFF2LABEL(r/*:number*/, c/*:number*/, val) { argument
21256 write_BIFF2Cell(out, r, c);
21283 if(range.e.c > 0xFF || range.e.r > 0x3FFF) {
21286 range.e.r = Math.min(range.e.c, 0x3FFF);
21289 for(var R = range.s.r; R <= range.e.r; ++R) {
21292 if(R === range.s.r) cols[C] = encode_col(C);
21331 [[5,8],[23,26],[41,44],[/*63*/50,/*66],[164,*/392]].forEach(function(r) { argument
21333 …for(var i = r[0]; i <= r[1]; ++i) if(NF[i] != null) write_biff_rec(ba, 0x041E /* Format */, write_…
21418 if(range.e.c > 0xFF || range.e.r >= MAX_ROWS) {
21421 range.e.r = Math.min(range.e.c, MAX_ROWS-1);
21449 for(var R = range.s.r; R <= range.e.r; ++R) {
21452 if(R === range.s.r) cols[C] = encode_col(C);
21620 var range/*:Range*/ = {s:{r:10000000, c:10000000},e:{r:0,c:0}}; property in html_to_sheet.range.e
21636 if(_merge.s.c == C && _merge.s.r < R && R <= _merge.e.r) { C = _merge.e.c + 1; midx = -1; }
21640 if((RS = +tag.rowspan)>1 || CS>1) merges.push({s:{r:R,c:C},e:{r:R + (RS||1) - 1, c:C + CS - 1}});
21645 if(range.s.r > R) range.s.r = R; if(range.e.r < R) range.e.r = R;
21659 else ws[encode_cell({r:R, c:C})] = o;
21667 function make_html_row(ws/*:Worksheet*/, r/*:Range*/, R/*:number*/, o/*:Sheet2HTMLOpts*/)/*:string*… argument
21671 for(var C = r.s.c; C <= r.e.c; ++C) {
21674 if(M[j].s.r > R || M[j].s.c > C) continue;
21675 if(M[j].e.r < R || M[j].e.c < C) continue;
21676 if(M[j].s.r < R || M[j].s.c < C) { RS = -1; break; }
21677 RS = M[j].e.r - M[j].s.r + 1; CS = M[j].e.c - M[j].s.c + 1; break;
21680 var coord = encode_cell({r:R,c:C});
21728 var r = decode_range(ws['!ref']);
21730 out.push(make_html_preamble(ws, r, o));
21731 for(var R = r.s.r; R <= r.e.r; ++R) out.push(make_html_row(ws, r, R, o));
21750 or_R = _origin.r; or_C = _origin.c;
21755 var range/*:Range*/ = {s:{r:0,c:0},e:{r:or_R,c:or_C}}; property in sheet_add_dom.range.e
21758 range.s.r = Math.min(range.s.r, _range.s.r);
21760 range.e.r = Math.max(range.e.r, _range.e.r);
21762 if(or_R == -1) range.e.r = or_R = _range.e.r + 1;
21782 … if(m.s.c == C + or_C && m.s.r < R + or_R && R + or_R <= m.e.r) { C = m.e.c+1 - or_C; midx = -1; }
21786 …elt.getAttribute("rowspan") || 1)))>1 || CS>1) merges.push({s:{r:R + or_R,c:C + or_C},e:{r:R + or_…
21810 else ws[encode_cell({c:C + or_C, r:R + or_R})] = o;
21817 range.e.r = Math.max(range.e.r, R - 1 + or_R);
21819 …if(R >= sheetRows) ws['!fullref'] = encode_range((range.e.r = rows.length-_R+R-1 + or_R,range)); /…
21855 .replace(/[\t\r\n]/g, " ").trim().replace(/ +/g, " ")
22103 var R = -1, C = -1, range = {s: {r:1000000,c:10000000}, e: {r:0, c:0}}; property in range.s
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;
22141 range.s.r = range.s.c = 10000000; range.e.r = range.e.c = 0;
22163 else ws[encode_cell({r:R,c:C})] = {t:'z'};
22181 ws[encode_cell({r:R,c:C})] = q;
22192 if(R < range.s.r) range.s.r = R;
22193 if(rptR > range.e.r) range.e.r = rptR;
22203 mrange = {s: {r:R,c:C}, e:{r:R + mR-1,c:C + mC-1}}; property in mrange.s
22209 if(R >= arrayf[i][0].s.r && R <= arrayf[i][0].e.r)
22216 mrange = {s: {r:R,c:C}, e:{r:R + mR-1,c:C + mC-1}}; property in mrange.e
22262 ws[encode_cell({r:R + rpt,c:C})] = q;
22263 while(--colpeat > 0) ws[encode_cell({r:R + rpt,c:C + colpeat})] = dup(q);
22850 for(R = 0; R < range.s.r; ++R) {
22854 for(; R <= range.e.r; ++R) {
22862 if(marr[mi].s.r > R) continue;
22864 if(marr[mi].e.r < R) continue;
22865 if(marr[mi].s.c != C || marr[mi].s.r != R) skip = true;
22867 ct['table:number-rows-spanned'] = (marr[mi].e.r - marr[mi].s.r + 1);
22871 var ref = encode_cell({r:R, c:C}), cell = dense ? (ws[R]||[])[C]: ws[ref];
22878 ct['table:number-matrix-rows-spanned'] = (_Fref.e.r - _Fref.s.r + 1);
22982 for(var R = 0; R <= range.e.r; ++R) for(var C = 0; C <= range.e.c; ++C) {
22983 var c = Array.isArray(ws) ? (ws[R]||[])[C] : ws[encode_cell({r:R,c:C})];
23936 iwa.messages[0].meta[5] = [{ type: 2, data: write_packed_varints(orefs.filter(function(r) {
23937 return r != ref;
24029 throw new Error("Duplicate cell r=".concat(x.R, " c=").concat(C));
24039 var range = { s: { r: 0, c: 0 }, e: { r: 0, c: 0 } }; property in parse_TST_TableModelArchive.range.s
24040 range.e.r = (varint_to_i32(pb[6][0].data) >>> 0) - 1;
24041 if (range.e.r < 0)
24076 var addr = encode_cell({ r: _R + R, c: C });
24093 s: { r: origin.getUint16(0, true), c: origin.getUint16(2, true) },
24095 r: origin.getUint16(0, true) + size.getUint16(0, true) - 1,
24770 range.s.r = range.s.c = 0;
24776 if (range.e.r > 999999) {
24778 range.e.r = 999999;
24789 pb[6][0].data = write_varint49(range.e.r + 1);
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) {
24962 [{ type: 5, data: new Uint8Array(new Uint16Array([m.s.r, m.s.c]).buffer) }]
24966 …[{ type: 5, data: new Uint8Array(new Uint16Array([m.e.r - m.s.r + 1, m.e.c - m.s.c + 1]).buffer) }]
25994 function make_json_row(sheet/*:Worksheet*/, r/*:Range*/, R/*:number*/, cols/*:Array<string>*/, head… argument
26003 if(!dense || sheet[R]) for (var C = r.s.c; C <= r.e.c; ++C) {
26036 var r = {s:{r:0,c:0},e:{r:0,c:0}}; class in sheet_to_json
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;
26049 var rr = encode_row(r.s.r);
26054 var R = r.s.r, C = 0;
26059 for(C = r.s.c; C <= r.e.c; ++C) {
26064 case 1: hdr[C] = C - r.s.c; break;
26066 case 3: hdr[C] = o.header[C - r.s.c]; break;
26079 for (R = r.s.r + offset; R <= r.e.r; ++R) {
26081 var row = make_json_row(sheet, r, R, cols, header, hdr, dense, o);
26089 function make_csv_row(sheet/*:Worksheet*/, r/*:Range*/, R/*:number*/, cols/*:Array<string>*/, fs/*:… argument
26092 for(var C = r.s.c; C <= r.e.c; ++C) {
26116 var r = safe_decode_range(sheet["!ref"]);
26124 for(var C = r.s.c; C <= r.e.c; ++C) if (!((colinfo[C]||{}).hidden)) cols[C] = encode_col(C);
26126 for(var R = r.s.r; R <= r.e.r; ++R) {
26128 row = make_csv_row(sheet, r, R, cols, fs, rs, FS, o);
26148 var r = safe_decode_range(sheet['!ref']), rr = "", cols/*:Array<string>*/ = [], C;
26151 for(C = r.s.c; C <= r.e.c; ++C) cols[C] = encode_col(C);
26152 for(var R = r.s.r; R <= r.e.r; ++R) {
26154 for(C = r.s.c; C <= r.e.c; ++C) {
26190 _R = _origin.r; _C = _origin.c;
26193 var range/*:Range*/ = ({s: {c:0, r:0}, e: {c:_C, r:_R + js.length - 1 + offset}}/*:any*/); property in sheet_add_json.range.s
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; }
26212 var ref = dense ? "" : encode_cell({c:_C + C,r:_R + R + offset});
26257 if(!ws[RC.r]) ws[RC.r] = [];
26258 return ws[RC.r][RC.c] || (ws[RC.r][RC.c] = {t:'z'});
26265 return ws_get_cell_stub(ws, encode_cell({r:R,c:C||0}));
26349 for(var R = rng.s.r; R <= rng.e.r; ++R) for(var C = rng.s.c; C <= rng.e.c; ++C) {
26354 if(R == rng.s.r && C == rng.s.c) {
26360 if(wsr.s.r > rng.s.r) wsr.s.r = rng.s.r;
26362 if(wsr.e.r < rng.e.r) wsr.e.r = rng.e.r;
26415 var r = safe_decode_range(sheet["!ref"]);
26423 for(var C = r.s.c; C <= r.e.c; ++C) if (!((colinfo[C]||{}).hidden)) cols[C] = encode_col(C);
26424 var R = r.s.r;
26428 while(R <= r.e.r) {
26431 row = make_csv_row(sheet, r, R-1, cols, fs, rs, FS, o);
26449 var r = decode_range(ws['!ref']);
26451 stream.push(make_html_preamble(ws, r, o));
26452 var R = r.s.r;
26455 if(R > r.e.r) {
26459 while(R <= r.e.r) {
26460 stream.push(make_html_row(ws, r, R, o));
26473 var r = {s:{r:0,c:0},e:{r:0,c:0}}; class in write_json_stream
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;
26485 var rr = encode_row(r.s.r);
26489 var R = r.s.r, C = 0;
26494 for(C = r.s.c; C <= r.e.c; ++C) {
26499 case 1: hdr[C] = C - r.s.c; break;
26501 case 3: hdr[C] = o.header[C - r.s.c]; break;
26514 R = r.s.r + offset;
26516 while(R <= r.e.r) {
26518 var row = make_json_row(sheet, r, R, cols, header, hdr, dense, o);