Lines Matching refs:C
1 /*! xlsx.js (C) 2013-present SheetJS -- http://sheetjs.com */
286 /* ssf.js (C) 2013-present SheetJS -- http://sheetjs.com */
1381 /* cfb.js (C) 2013-present SheetJS -- http://sheetjs.com */
1401 /* crc32.js (C) 2014-present SheetJS -- http://sheetjs.com */
1446 var C = seed/*:: ? 0 : 0 */ ^ -1;
1447 for(var i = 0, L = bstr.length; i < L;) C = (C>>>8) ^ T0[(C^bstr.charCodeAt(i++))&0xFF];
1448 return ~C;
1452 var C = seed/*:: ? 0 : 0 */ ^ -1, L = B.length - 15, i = 0;
1453 for(; i < L;) C =
1454 Tf[B[i++] ^ (C & 255)] ^
1455 Te[B[i++] ^ ((C >> 8) & 255)] ^
1456 Td[B[i++] ^ ((C >> 16) & 255)] ^
1457 Tc[B[i++] ^ (C >>> 24)] ^
1462 while(i < L) C = (C>>>8) ^ T0[(C^B[i++])&0xFF];
1463 return ~C;
1467 var C = seed ^ -1;
1471 C = (C>>>8) ^ T0[(C^c)&0xFF];
1473 C = (C>>>8) ^ T0[(C ^ (192|((c>>6)&31)))&0xFF];
1474 C = (C>>>8) ^ T0[(C ^ (128|(c&63)))&0xFF];
1477 C = (C>>>8) ^ T0[(C ^ (240|((c>>8)&7)))&0xFF];
1478 C = (C>>>8) ^ T0[(C ^ (128|((c>>2)&63)))&0xFF];
1479 C = (C>>>8) ^ T0[(C ^ (128|((d>>6)&15)|((c&3)<<4)))&0xFF];
1480 C = (C>>>8) ^ T0[(C ^ (128|(d&63)))&0xFF];
1482 C = (C>>>8) ^ T0[(C ^ (224|((c>>12)&15)))&0xFF];
1483 C = (C>>>8) ^ T0[(C ^ (128|((c>>6)&63)))&0xFF];
1484 C = (C>>>8) ^ T0[(C ^ (128|(c&63)))&0xFF];
1487 return ~C;
1741 var i = 0, L = 0, R = 0, C = 0, j = 0, pl = Paths.length;
1748 L = FI[i].L; R = FI[i].R; C = FI[i].C;
1753 if(C !== -1 /*NOSTREAM*/) dad[C] = i;
1872 C: blob.read_shift(4, 'i'),
1945 cfb.FileIndex.push(({ name: nm, type: 2, content:p, size:4, L:69, R:69, C:69 }/*:any*/));
1961 if(isNaN(_file.R * _file.L * _file.C)) gc = true;
2008 elt.L = elt.R = elt.C = -(elt.color = 1);
2013 elt.C = data.length > 1 ? 1 : -1;
2018 elt.C = j >= data.length ? -1 : j;
2145 o.write_shift(-4, file.C);
3143 out.push('Content-Location: ' + (opts.root || 'file:///C:/SheetJS/') + fp);
4285 var R = 0, C = 0;
4289 else if(cc >= 65 && cc <= 90) C = 26 * C + (cc - 64);
4291 return { c: C - 1, r:R - 1 };
4410 for(var C = 0; C != data[R].length; ++C) {
4411 if(typeof data[R][C] === 'undefined') continue;
4412 var cell/*:Cell*/ = ({v: data[R][C] }/*:any*/);
4413 var __R = _R + R, __C = _C + C;
4418 …if(data[R][C] && typeof data[R][C] === 'object' && !Array.isArray(data[R][C]) && !(data[R][C] inst…
4420 if(Array.isArray(cell.v)) { cell.f = data[R][C][1]; cell.v = cell.v[0]; }
6566 function write_XLSCell(R/*:number*/, C/*:number*/, ixfe/*:?number*/, o) { argument
6569 o.write_shift(2, C);
6974 function write_LabelSst(R/*:number*/, C/*:number*/, v/*:number*/, os/*:number*/ /*::, opts*/) { argument
6976 write_XLSCell(R, C, os, o);
6991 function write_Label(R/*:number*/, C/*:number*/, v/*:string*/, os/*:number*/, opts) { argument
6994 write_XLSCell(R, C, os, o);
7026 var c = blob.read_shift(2), C = blob.read_shift(2);
7028 return {s: {r:r, c:c}, e: {r:R, c:C}};
7057 return {r:rw, c:col, C:lastcol, rkrec:rkrecs};
7068 return {r:rw, c:col, C:lastcol, ixfe:ixfes};
7170 function write_BoolErr(R/*:number*/, C/*:number*/, v, os/*:number*/, opts, t/*:string*/) { argument
7172 write_XLSCell(R, C, os, o);
7185 function write_Number(R/*:number*/, C/*:number*/, v, os/*:: :number, opts*/) { argument
7187 write_XLSCell(R, C, os, o);
7783 case 'C': // Character (dBASE II)
7803 var R = 0, C = 0;
7805 for(C = 0; C != fields.length; ++C) out[0][C] = fields[C].name;
7813 out[++R] = []; C = 0;
7814 for(C = 0; C != fields.length; ++C) {
7815 var dd = d.slice(d.l, d.l+fields[C].len); d.l+=fields[C].len;
7818 switch(fields[C].type) {
7819 case 'C':
7821 if(s.trim().length) out[R][C] = s.replace(/\s+$/,"");
7824 if(s.length === 8) out[R][C] = new Date(+s.slice(0,4), +s.slice(4,6)-1, +s.slice(6,8));
7825 else out[R][C] = s;
7827 case 'F': out[R][C] = parseFloat(s.trim()); break;
7828 …case '+': case 'I': out[R][C] = l7 ? dd.read_shift(-4, 'i') ^ 0x80000000 : dd.read_shift(4, 'i'); …
7830 case 'Y': case 'T': out[R][C] = true; break;
7831 case 'N': case 'F': out[R][C] = false; break;
7837 out[R][C] = "##MEMO##" + (l7 ? parseInt(s.trim(), 10): dd.read_shift(4));
7842 if(s && s != ".") out[R][C] = +s || 0; break;
7845 out[R][C] = new Date(dd.read_shift(-8, 'f') - 0x388317533400);
7847 …case 'T': out[R][C] = new Date((dd.read_shift(4) - 0x253D8C) * 0x5265C00 + dd.read_shift(4)); brea…
7848 …case 'Y': out[R][C] = dd.read_shift(4,'i')/1e4 + (dd.read_shift(4, 'i')/1e4)*Math.pow(2,32); break;
7849 case 'O': out[R][C] = -dd.read_shift(-8, 'f'); break;
7850 case 'B': if(vfp && fields[C].len == 8) { out[R][C] = dd.read_shift(8,'f'); break; }
7852 case 'G': case 'P': dd.l += fields[C].len; break;
7854 if(fields[C].name === '_NullFlags') break;
7856 default: throw new Error("DBF Unsupported data type " + fields[C].type);
7887 var _RLEN = { 'B': 8, 'C': 250, 'L': 1, 'D': 8, '?': 0, '': 0 };
7921 case 'string': _guess = 'C'; break;
7923 case 'object': _guess = col[j] instanceof Date ? 'D' : 'C'; break;
7924 default: _guess = 'C';
7928 guess = guess && guess != _guess ? 'C' : _guess;
7929 //if(guess == 'C') break;
7934 if(_guess == 'C') {
7942 colwidths[i] = guess == 'C' || _guess == 'N' ? maxlen : (_RLEN[guess] || 0);
7966 hf.write_shift(1, coltypes[i] == '?' ? 'C' : coltypes[i], "sbcs");
8002 case 'C':
8060 var records = str.split(/[\n\r]+/), R = -1, C = -1, ri = 0, rj = 0, arr/*:AOA*/ = [];
8099 case 'C': /* cell */
8103 case 'X': C = parseInt(record[rj].slice(1), 10)-1; C_seen_X = true; break;
8105 R = parseInt(record[rj].slice(1), 10)-1; if(!C_seen_X) C = 0;
8124 formula = rc_to_a1(record[rj].slice(1), {r:R,c:C});
8131 case 'C': _C = parseInt(record[rj].slice(1), 10)-1; break;
8137 if(!arr[R][C]) arr[R][C] = { t: cell_t, v: val };
8138 else { arr[R][C].t = cell_t; arr[R][C].v = val; }
8139 if(next_cell_format) arr[R][C].z = next_cell_format;
8140 …if(opts.cellText !== false && next_cell_format) arr[R][C].w = SSF_format(arr[R][C].z, arr[R][C].v,…
8147 formula = shift_formula_str(shrbase[1], {r: R - _R, c: C - _C});
8150 if(!arr[R][C]) arr[R][C] = { t: 'n', f: formula };
8151 else arr[R][C].f = formula;
8157 case 'X': C = parseInt(record[rj].slice(1), 10)-1; ++F_seen; break;
8159 R = parseInt(record[rj].slice(1), 10)-1; /*C = 0;*/
8177 case 'C': /* default column format */
8178 C = parseInt(record[rj].slice(1), 10)-1;
8179 if(!colinfo[C]) colinfo[C] = {};
8214 …function write_ws_cell_sylk(cell/*:Cell*/, ws/*:Worksheet*/, R/*:number*/, C/*:number*//*::, opts*…
8215 var o = "C;Y" + (R+1) + ";X" + (C+1) + ";K";
8219 if(cell.f && !cell.F) o += ";E" + a1_to_rc(cell.f, {r:R, c:C}); break;
8268 for(var C = r.s.c; C <= r.e.c; ++C) {
8269 var coord = encode_cell({r:R,c:C});
8270 cell = dense ? (ws[R]||[])[C]: ws[coord];
8272 p.push(write_ws_cell_sylk(cell, ws, R, C, opts)); // TODO: pass date1904 info
8296 var records = str.split('\n'), R = -1, C = -1, ri = 0, arr/*:AOA*/ = [];
8298 if (records[ri].trim() === 'BOT') { arr[++R] = []; C = 0; continue; }
8308 if (data === 'BOT') { arr[++R] = []; C = 0; continue; }
8312 if(data === 'TRUE') arr[R][C] = true;
8313 else if(data === 'FALSE') arr[R][C] = false;
8314 else if(!isNaN(fuzzynum(value))) arr[R][C] = fuzzynum(value);
8315 else if(!isNaN(fuzzydate(value).getDate())) arr[R][C] = parseDate(value);
8316 else arr[R][C] = value;
8317 ++C; break;
8322 arr[R][C++] = data !== '' ? data : null;
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})];
8398 var records = str.split('\n'), R = -1, C = -1, ri = 0, arr/*:AOA*/ = [];
8404 R = addr.r; C = addr.c;
8406 case 't': arr[R][C] = decode(record[3]); break;
8407 case 'v': arr[R][C] = +record[3]; break;
8412 case 'nl': arr[R][C] = +record[4] ? true : false; break;
8413 default: arr[R][C] = +record[4]; break;
8415 if(record[2] == 'vtf') arr[R][C] = [arr[R][C], _f];
8450 for(var C = r.s.c; C <= r.e.c; ++C) {
8451 coord = encode_cell({r:R,c:C});
8452 cell = dense ? (ws[R]||[])[C] : ws[coord];
8494 function set_text_arr(data/*:string*/, arr/*:AOA*/, R/*:number*/, C/*:number*/, o/*:any*/) { argument
8495 if(o.raw) arr[R][C] = data;
8497 else if(data === 'TRUE') arr[R][C] = true;
8498 else if(data === 'FALSE') arr[R][C] = false;
8499 else if(!isNaN(fuzzynum(data))) arr[R][C] = fuzzynum(data);
8500 else if(!isNaN(fuzzydate(data).getDate())) arr[R][C] = parseDate(data);
8501 else arr[R][C] = data;
8521 var C = 0;
8522 set_text_arr(lines[R].slice(0, start).trim(), arr, R, C, o);
8523 for(C = 1; C <= (lines[R].length - start)/10 + 1; ++C)
8524 set_text_arr(lines[R].slice(start+(C-1)*10,start+C*10).trim(),arr,R,C,o);
8590 var R = 0, C = 0, v = 0;
8620 else if(o.dense) { if(!ws[R]) ws[R] = []; ws[R][C] = cell; }
8621 else ws[encode_cell({c:C,r:R})] = cell;
8623 if(range.e.c < C) range.e.c = C;
8625 if(cc == sepcc) ++C; else { C = 0; ++R; if(o.sheetRows && o.sheetRows <= R) return true; }
8679 for(var C = r.s.c; C <= r.e.c; ++C) {
8680 var coord = encode_cell({r:R,c:C});
8681 cell = dense ? (ws[R]||[])[C] : ws[coord];
8685 oo.push(w + (C === 0 ? " " : ""));
8880 for(var C = range.s.c; C <= range.e.c; ++C) {
8881 if(R === range.s.r) cols[C] = encode_col(C);
8882 var ref = cols[C] + rr;
8883 var cell = dense ? (ws[R]||[])[C] : ws[ref];
8887 …ll.v && cell.v >= -32768 && cell.v <= 32767) write_biff_rec(ba, 0x0d, write_INTEGER(R, C, cell.v));
8888 else write_biff_rec(ba, 0x0e, write_NUMBER(R, C, cell.v));
8891 write_biff_rec(ba, 0x0F, write_LABEL(R, C, str.slice(0, 239)));
8920 for(var C = range.s.c; C <= range.e.c; ++C) {
8921 if(R === range.s.r) cols[C] = encode_col(C);
8922 var ref = cols[C] + rr;
8923 var cell = dense ? (ws[R]||[])[C] : ws[ref];
8927 write_biff_rec(ba, 0x17, write_NUMBER_17(R, C, wsidx, cell.v));
8931 write_biff_rec(ba, 0x16, write_LABEL_16(R, C, wsidx, str.slice(0, 239)));
9037 function write_LABEL(R, C, s) {
9041 o.write_shift(2, C);
9069 function write_INTEGER(R, C, v) {
9072 o.write_shift(2, C);
9083 function write_NUMBER(R, C, v) {
9086 o.write_shift(2, C);
9210 var out = [], argc = 0, R = "", C = "", argL = "", argR = "";
9216 C = wk1_parse_rc(o[0].c, blob.read_shift(2), true);
9218 out.push(C + R);
9223 C = wk1_parse_rc(o[0].c, blob.read_shift(2), true);
9225 out.push(c + r + ":" + C + R);
9284 function write_LABEL_16(R, C, wsidx, s) {
9289 o.write_shift(1, C);
9334 function write_NUMBER_17(R, C, wsidx, v) {
9338 o.write_shift(1, C);
9637 var cnt = 0, type = 0, C = 0, R = 0;
9695 C = p.read_shift(2);
9696 if(range.e.c < C) range.e.c = C;
9697 if(range.s.c > C) range.s.c = C;
9732 s[R][C] = cell;
9733 } else s[encode_cell({r:R, c:C})] = cell;
9751 s[R][C] = cell;
9752 } else s[encode_cell({r:R, c:C})] = cell;
10403 var C = -1;
10413 ++C;
10426 ws[R][C] = cell;
10428 ws[encode_cell({ r: R, c: C })] = cell;
10438 if (C > range.e.c)
10439 range.e.c = C;
10457 for (var C = r.s.c; C <= r.e.c; ++C)
10458 o.push("\\cellx" + (C + 1));
10460 for (C = r.s.c; C <= r.e.c; ++C) {
10461 var coord = encode_cell({ r: R, c: C });
10462 cell = dense ? (ws[R] || [])[C] : ws[coord];
10485 var M = Math.max(R, G, B), m = Math.min(R, G, B), C = M - m;
10486 if(C === 0) return [0, 0, R];
10489 S = C / (L2 > 1 ? 2 - L2 : L2);
10491 case R: H6 = ((G - B) / C + 6)%6; break;
10492 case G: H6 = ((B - R) / C + 2); break;
10493 case B: H6 = ((R - G) / C + 4); break;
10500 var C = S * 2 * (L < 0.5 ? L : 1 - L), m = L - C/2;
10505 case 0: case 6: X = C * h6; rgb[0] += C; rgb[1] += X; break;
10506 case 1: X = C * (2 - h6); rgb[0] += X; rgb[1] += C; break;
10507 case 2: X = C * (h6 - 2); rgb[1] += C; rgb[2] += X; break;
10508 case 3: X = C * (4 - h6); rgb[1] += X; rgb[2] += C; break;
10509 case 4: X = C * (h6 - 4); rgb[2] += C; rgb[0] += X; break;
10510 case 5: X = C * (6 - h6); rgb[2] += X; rgb[0] += C; break;
12507 var rcregex = /(^|[^A-Za-z_])R(\[?-?\d+\]|[1-9]\d*|)C(\[?-?\d+\]|[1-9]\d*|)(?![A-Za-z0-9_])/g;
12518 var R = $2.length>0?parseInt($2,10)|0:0, C = $3.length>0?parseInt($3,10)|0:0;
12520 if(cRel) C += rcbase.c; else --C;
12522 return $1 + (cRel ? "" : "$") + encode_col(C) + (rRel ? "" : "$") + encode_row(R);
12537 var C = $2 == "$" ? (c+1) : (c == 0 ? "" : "[" + c + "]");
12538 return $1 + "R" + R + "C" + C;
12582 var C=parse_ColRelU(blob, 2);
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]} };
12589 var C=blob.read_shift(1);
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]} };
12598 var C=parse_ColRelU(blob, 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]} };
13024 var C = blob.read_shift(2);
13026 return {ixti: ixti, coltype:(flags&0x3), rt:rt, idx:idx, c:c, C:C};
13695 function write_Formula(cell/*:Cell*/, R/*:number*/, C/*:number*/, opts, os/*:number*/) { argument
13697 var o1 = write_XLSCell(R, C, os);
15145 function col_obj_w(C/*:number*/, col) { argument
15146 var p = ({min:C+1,max:C+1}/*:any*/);
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});
15411 if(!s[R][C]) s[R][C] = {t:"z",v:undefined};
15412 s[R][C].l = val;
15738 …range(ws['!ref']), cell="", ref, rr = "", cols/*:Array<string>*/ = [], R=0, C=0, rows = ws['!rows'…
15741 for(C = range.s.c; C <= range.e.c; ++C) cols[C] = encode_col(C);
15745 for(C = range.s.c; C <= range.e.c; ++C) {
15746 ref = cols[C] + rr;
15747 var _cell = dense ? (ws[R]||[])[C]: ws[ref];
16310 function write_BrtColInfo(C/*:number*/, col, o) { argument
16312 var p = col_obj_w(C, col);
16313 o.write_shift(-4, C);
16314 o.write_shift(-4, C);
16419 var row, p, cf, R, C, addr, sstr, rr, cell/*:Cell*/;
16487 C = val[0].c == -1 ? C + 1 : val[0].c;
16488 if(opts.dense) { if(!s[R]) s[R] = []; s[R][C] = p; }
16489 else s[encode_col(C) + rr] = p;
16495 if(C >= aii[0].s.c && C <= aii[0].e.c) {
16503 if(refguess.s.c > C) refguess.s.c = C;
16505 if(refguess.e.c < C) refguess.e.c = C;
16520 C = val[0].c == -1 ? C + 1 : val[0].c;
16521 if(opts.dense) { if(!s[R]) s[R] = []; s[R][C] = p; }
16522 else s[encode_col(C) + rr] = p;
16524 if(refguess.s.c > C) refguess.s.c = C;
16526 if(refguess.e.c < C) refguess.e.c = C;
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) {
16553 if(!s[R][C]) s[R][C] = {t:'z',v:undefined};
16554 s[R][C].l = val;
16556 addr = encode_cell({c:C,r:R});
16566 cell = ((opts.dense ? s[R][C] : s[encode_col(C) + rr])/*:any*/);
16567 cell.f = stringify_formula(val[1], refguess, {r:row.r, c:C}, supbooks, opts);
16573 cell = (opts.dense ? s[R][C] : s[encode_col(C) + rr]);
16574 cell.f = stringify_formula(val[1], refguess, {r:row.r, c:C}, supbooks, opts);
16706 function write_ws_bin_cell(ba/*:BufArray*/, cell/*:Cell*/, R/*:number*/, C/*:number*/, opts, ws/*:W… argument
16707 var o/*:any*/ = ({r:R, c:C}/*:any*/);
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);
16778 ref = cols[C] + rr;
16779 var cell = dense ? (ws[R]||[])[C] : ws[ref];
16782 last_seen = write_ws_bin_cell(ba, cell, R, C, opts, ws, last_seen);
16960 var C = 0, R = 0, col = "A";
16967 refguess.e.c = C;
16968 col = encode_col(C);
16974 ++C;
16976 if(C > 0) cs["!ref"] = encode_range(refguess);
19011 …attr["ss:ArrayRange"] = "RC:R" + (end.r == addr.r ? "" : "[" + (end.r - addr.r) + "]") + "C" + (en…
19075 for(var C = range.s.c; C <= range.e.c; ++C) {
19078 if(marr[mi].s.c > C) continue;
19080 if(marr[mi].e.c < C) continue;
19082 if(marr[mi].s.c != C || marr[mi].s.r != R) skip = true;
19086 var addr = {r:R,c:C};
19087 var ref = encode_cell(addr), cell = dense ? (ws[R]||[])[C] : ws[ref];
19531 for(var j = val.c; j <= val.C; ++j) {
19607 for(var _j = val.c; _j <= val.C; ++_j) {
21262 function write_ws_biff2_cell(ba/*:BufArray*/, cell/*:Cell*/, R/*:number*/, C/*:number*//*::, opts*/… argument
21267 write_biff_rec(ba, 0x0002, write_BIFF2INT(R, C, v));
21269 write_biff_rec(ba, 0x0003, write_BIFF2NUM(R,C, v));
21271 case 'b': case 'e': write_biff_rec(ba, 0x0005, write_BIFF2BERR(R, C, cell.v, cell.t)); return;
21274 …write_biff_rec(ba, 0x0004, write_BIFF2LABEL(R, C, cell.v == null ? "" : String(cell.v).slice(0,255…
21277 write_biff_rec(ba, 0x0001, write_BIFF2Cell(null, R, C));
21291 for(var C = range.s.c; C <= range.e.c; ++C) {
21292 if(R === range.s.r) cols[C] = encode_col(C);
21293 ref = cols[C] + rr;
21294 var cell = dense ? (ws[R]||[])[C] : ws[ref];
21297 write_ws_biff2_cell(ba, cell, R, C, opts);
21379 function write_ws_biff8_cell(ba/*:BufArray*/, cell/*:Cell*/, R/*:number*/, C/*:number*/, opts) { argument
21382 write_biff_rec(ba, 0x0201 /* Blank */, write_XLSCell(R, C, os));
21385 if(cell.bf) write_biff_rec(ba, 0x0006 /* Formula */, write_Formula(cell, R, C, opts, os));
21390 write_biff_rec(ba, 0x0203 /* Number */, write_Number(R, C, v, os, opts));
21393 write_biff_rec(ba, 0x0205 /* BoolErr */, write_BoolErr(R, C, cell.v, os, opts, cell.t));
21399 write_biff_rec(ba, 0x00fd /* LabelSst */, write_LabelSst(R, C, isst, os, opts));
21400 …} else write_biff_rec(ba, 0x0204 /* Label */, write_Label(R, C, (cell.v == null ? "" : String(cell…
21403 write_biff_rec(ba, 0x0201 /* Blank */, write_XLSCell(R, C, os));
21451 for(var C = range.s.c; C <= range.e.c; ++C) {
21452 if(R === range.s.r) cols[C] = encode_col(C);
21453 ref = cols[C] + rr;
21454 var cell = dense ? (ws[R]||[])[C] : ws[ref];
21457 write_ws_biff8_cell(ba, cell, R, C, opts);
21531 var C = buf_array();
21533 if(b8) write_biff_rec(C, 0x008C /* Country */, write_Country());
21537 if(b8 && opts.Strings) write_biff_continue(C, 0x00FC /* SST */, write_SST(opts.Strings, opts));
21540 write_biff_rec(C, 0x000A /* EOF */);
21541 var c = C.end();
21619 var R = -1, C = 0, RS = 0, CS = 0;
21625 …if(hd == "<tr") { ++R; if(opts.sheetRows && opts.sheetRows <= R) { --R; break; } C = 0; continue; }
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}});
21643 if(!m.length) { C += CS; continue; }
21646 if(range.s.c > C) range.s.c = C; if(range.e.c < C) range.e.c = C;
21647 if(!m.length) { C += CS; continue; }
21658 if(opts.dense) { if(!ws[R]) ws[R] = []; ws[R][C] = o; }
21659 else ws[encode_cell({r:R, c:C})] = o;
21660 C += CS;
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; }
21680 var coord = encode_cell({r:R,c:C});
21681 var cell = o.dense ? (ws[R]||[])[C] : ws[coord];
21766 var _R = 0, R = 0, _C = 0, C = 0, RS = 0, CS = 0;
21775 for(_C = C = 0; _C < elts.length; ++_C) {
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 …span") || 1)))>1 || CS>1) merges.push({s:{r:R + or_R,c:C + or_C},e:{r:R + or_R + (RS||1) - 1, c:C …
21809 if(opts.dense) { if(!ws[R + or_R]) ws[R + or_R] = []; ws[R + or_R][C + or_C] = o; }
21810 else ws[encode_cell({c:C + or_C, r:R + or_R})] = o;
21811 if(range.e.c < C + or_C) range.e.c = C + or_C;
21812 C += CS;
22103 var R = -1, C = -1, range = {s: {r:1000000,c:10000000}, e: {r:0, c:0}}; variable
22140 R = C = -1;
22158 C = -1; break;
22160 if(Rn[1] !== '/') ++C;
22162 if(opts.dense) { if(!ws[R]) ws[R] = []; ws[R][C] = {t:'z'}; }
22163 else ws[encode_cell({r:R,c:C})] = {t:'z'};
22169 ++C;
22179 ws[R][C] = q;
22181 ws[encode_cell({r:R,c:C})] = q;
22184 C+= colpeat-1;
22186 ++C;
22190 if(C > range.e.c) range.e.c = C;
22191 if(C < range.s.c) range.s.c = C;
22203 mrange = {s: {r:R,c:C}, e:{r:R + mR-1,c:C + mC-1}};
22210 if(C >= arrayf[i][0].s.c && C <= arrayf[i][0].e.c)
22216 mrange = {s: {r:R,c:C}, e:{r:R + mR-1,c:C + mC-1}};
22259 ws[R + rpt][C] = rpt == 0 ? q : dup(q);
22260 while(--colpeat > 0) ws[R + rpt][C + colpeat] = dup(q);
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);
22265 if(range.e.c <= C) range.e.c = C;
22270 C += colpeat-1; colpeat = 0;
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…
22857 for(C=0; C < range.s.c; ++C) o.push(null_cell_xml);
22858 for(; C <= range.e.c; ++C) {
22861 if(marr[mi].s.c > C) continue;
22863 if(marr[mi].e.c < C) continue;
22865 if(marr[mi].s.c != C || marr[mi].s.r != R) skip = true;
22871 var ref = encode_cell({r:R, c:C}), cell = dense ? (ws[R]||[])[C]: ws[ref];
22933 for(var C = 0; C < ws["!cols"].length; ++C) if(ws["!cols"][C]) {
22934 var colobj = ws["!cols"][C];
22938 var w = ws["!cols"][C].wpx + "px";
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})];
23113 /*! sheetjs (C) 2013-present SheetJS -- http://sheetjs.com */
23995 for (var C = 0; C < used_storage_u8.length / 2; ++C) {
23996 var off = used_storage_offsets.getUint16(C * 2, true);
23998 offsets.push([C, off]);
24003 for (C = 0; C < offsets.length - 1; ++C)
24004 cells[offsets[C][0]] = used_storage[subarray](offsets[C][1] * width, offsets[C + 1][1] * width);
24027 x.cells.forEach(function(cell, C) { argument
24028 if (acc[x.R][C])
24029 throw new Error("Duplicate cell r=".concat(x.R, " c=").concat(C));
24030 acc[x.R][C] = cell;
24068 row.forEach(function(buf, C) { argument
24074 ws[_R + R][C] = res;
24076 var addr = encode_cell({ r: _R + R, c: C });
24240 for (var C = 0; C < data.length; ++C) {
24241 if (data[C] == null) {
24242 dv.setUint16(C * 2, 65535, true);
24243 _dv.setUint16(C * 2, 65535);
24246 dv.setUint16(C * 2, last_offset / width, true);
24247 _dv.setUint16(C * 2, _last_offset / width, true);
24249 switch (typeof data[C]) {
24251 celload = write_new_storage({ t: "s", v: data[C] }, SST);
24252 _celload = write_old_storage({ t: "s", v: data[C] }, SST);
24255 celload = write_new_storage({ t: "n", v: data[C] }, SST);
24256 _celload = write_old_storage({ t: "n", v: data[C] }, SST);
24259 celload = write_new_storage({ t: "b", v: data[C] }, SST);
24260 _celload = write_old_storage({ t: "b", v: data[C] }, SST);
24263 if (data[C] instanceof Date) {
24264 celload = write_new_storage({ t: "s", v: data[C].toISOString() }, SST);
24265 _celload = write_old_storage({ t: "s", v: data[C].toISOString() }, SST);
24268 throw new Error("Unsupported value " + data[C]);
24280 for (; C < tri[7][0].data.length / 2; ++C) {
24281 dv.setUint16(C * 2, 65535, true);
24282 _dv.setUint16(C * 2, 65535, true);
24810 for (var C = 0; C <= range.e.c; ++C) {
24812 _bucket[1][0].data = write_varint49(C);
24814 base_bucket[2][C] = { type: base_bucket[2][0].type, data: write_shallow(_bucket) };
26003 if(!dense || sheet[R]) for (var C = r.s.c; C <= r.e.c; ++C) {
26004 var val = dense ? sheet[R][C] : sheet[cols[C] + rr];
26007 if(hdr[C] != null) { row[hdr[C]] = defval; }
26017 if(hdr[C] != null) {
26019 if(val.t == "e" && v === null) row[hdr[C]] = null;
26020 else if(defval !== undefined) row[hdr[C]] = defval;
26021 else if(raw && v === null) row[hdr[C]] = null;
26024 …row[hdr[C]] = raw && (val.t !== "n" || (val.t === "n" && o.rawNumbers !== false)) ? v : format_cel…
26054 var R = r.s.r, C = 0;
26059 for(C = r.s.c; C <= r.e.c; ++C) {
26060 if(((colinfo[C]||{}).hidden)) continue;
26061 cols[C] = encode_col(C);
26062 val = dense ? sheet[R][C] : sheet[cols[C] + rr];
26064 case 1: hdr[C] = C - r.s.c; break;
26065 case 2: hdr[C] = cols[C]; break;
26066 case 3: hdr[C] = o.header[C - r.s.c]; break;
26076 hdr[C] = vv;
26092 for(var C = r.s.c; C <= r.e.c; ++C) {
26093 if (!cols[C]) continue;
26094 var val = o.dense ? (sheet[R]||[])[C]: sheet[cols[C] + rr];
26124 for(var C = r.s.c; C <= r.e.c; ++C) if (!((colinfo[C]||{}).hidden)) cols[C] = encode_col(C);
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);
26154 for(C = r.s.c; C <= r.e.c; ++C) {
26155 y = cols[C] + rr;
26156 x = dense ? (sheet[R]||[])[C] : sheet[y];
26202 var hdr/*:Array<string>*/ = o.header || [], C = 0; variable
26208 if((C=hdr.indexOf(k)) == -1) hdr[C=hdr.length] = k;
26212 var ref = dense ? "" : encode_cell({c:_C + C,r:_R + R + offset});
26213 var cell/*:Cell*/ = dense ? ROW[_C + C] : ws[ref];
26228 else ROW[_C + C] = cell = ({t:t, v:v}/*:any*/);
26241 if(offset) for(C = 0; C < hdr.length; ++C) {
26242 if(dense) ws[_R][C + _C] = {t:'s', v:hdr[C]};
26243 else ws[encode_col(C + _C) + __R] = {t:'s', v:hdr[C]};
26251 function ws_get_cell_stub(ws/*:Worksheet*/, R, C/*:?number*/)/*:Cell*/ { argument
26264 /* R and C are 0-based indices */
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) {
26350 var cell = ws_get_cell_stub(ws, R, C);
26354 if(R == rng.s.r && C == rng.s.c) {
26423 for(var C = r.s.c; C <= r.e.c; ++C) if (!((colinfo[C]||{}).hidden)) cols[C] = encode_col(C);
26489 var R = r.s.r, C = 0;
26494 for(C = r.s.c; C <= r.e.c; ++C) {
26495 if(((colinfo[C]||{}).hidden)) continue;
26496 cols[C] = encode_col(C);
26497 val = dense ? sheet[R][C] : sheet[cols[C] + rr];
26499 case 1: hdr[C] = C - r.s.c; break;
26500 case 2: hdr[C] = cols[C]; break;
26501 case 3: hdr[C] = o.header[C - r.s.c]; break;
26511 hdr[C] = vv;