Lines Matching refs:ws

4388 	var ws/*:Worksheet*/ = _ws || (dense ? ([]/*:any*/) : ({}/*:any*/));
4390 if(ws && o.origin != null) {
4396 if(!ws["!ref"]) ws["!ref"] = "A1:A1";
4399 if(ws['!ref']) {
4400 var _range = safe_decode_range(ws['!ref']);
4437 if(!ws[__R]) ws[__R] = [];
4438 if(ws[__R][__C] && ws[__R][__C].z) cell.z = ws[__R][__C].z;
4439 ws[__R][__C] = cell;
4442 if(ws[cell_ref] && ws[cell_ref].z) cell.z = ws[cell_ref].z;
4443 ws[cell_ref] = cell;
4447 if(range.s.c < 10000000) ws['!ref'] = encode_range(range);
4448 return ws;
7869 var ws = aoa_to_sheet(dbf_to_aoa(buf, o), o);
7870 ws["!cols"] = o.DBF.map(function(field) { return {
7875 return ws;
7888 function sheet_to_dbf(ws/*:Worksheet*/, opts/*:WriteOpts*/) {
7894 var aoa/*:AOA*/ = sheet_to_json(ws, {header:1, raw:true, cellDates:true});
7895 var headers = aoa[0], data = aoa.slice(1), cols = ws["!cols"] || [];
7906 var range = safe_decode_range(ws['!ref']);
8204 var aoa = aoasht[0], ws = aoasht[1], wb = aoasht[2];
8207 keys(ws).forEach(function(k) { o[k] = ws[k]; });
8214 …function write_ws_cell_sylk(cell/*:Cell*/, ws/*:Worksheet*/, R/*:number*/, C/*:number*//*::, opts*…
8251 function sheet_to_sylk(ws/*:Worksheet*/, opts/*:?any*/, wb/*:?WorkBook*/)/*:string*/ {
8254 var r = safe_decode_range(ws['!ref']), cell/*:Cell*/;
8255 var dense = Array.isArray(ws);
8261 if(ws['!cols']) write_ws_cols_sylk(preamble, ws['!cols']);
8262 if(ws['!rows']) write_ws_rows_sylk(preamble, ws['!rows']);
8270 cell = dense ? (ws[R]||[])[C]: ws[coord];
8272 p.push(write_ws_cell_sylk(cell, ws, R, C, opts)); // TODO: pass date1904 info
8340 function sheet_to_dif(ws/*:Worksheet*//*::, opts:?any*/)/*:string*/ { argument
8342 var r = safe_decode_range(ws['!ref']);
8343 var dense = Array.isArray(ws);
8353 var cell/*:Cell*/ = dense ? (ws[R] && ws[R][C]) : ws[encode_cell({r:R,c:C})];
8444 function sheet_to_eth_data(ws/*:Worksheet*/)/*:string*/ { argument
8445 if(!ws || !ws['!ref']) return "";
8447 var r = decode_range(ws['!ref']);
8448 var dense = Array.isArray(ws);
8452 cell = dense ? (ws[R]||[])[C] : ws[coord];
8477 //o.push("copiedfrom:" + ws['!ref']); // clipboard only
8481 function sheet_to_eth(ws/*:Worksheet*//*::, opts:?any*/)/*:string*/ { argument
8482 return [header, sep, meta, sep, sheet_to_eth_data(ws), end].join("\n");
8483 // return ["version:1.5", sheet_to_eth_data(ws)].join("\n"); // clipboard form
8574 var ws/*:Worksheet*/ = o.dense ? ([]/*:any*/) : ({}/*:any*/);
8620 else if(o.dense) { if(!ws[R]) ws[R] = []; ws[R][C] = cell; }
8621 else ws[encode_cell({c:C,r:R})] = cell;
8638 ws['!ref'] = encode_range(range);
8639 return ws;
8673 function sheet_to_prn(ws/*:Worksheet*//*::, opts:?any*/)/*:string*/ {
8675 var r = safe_decode_range(ws['!ref']), cell/*:Cell*/;
8676 var dense = Array.isArray(ws);
8681 cell = dense ? (ws[R]||[])[C] : ws[coord];
8866 function sheet_to_wk1(ws/*:Worksheet*/, opts/*:WriteOpts*/) {
8871 var range = safe_decode_range(ws["!ref"]);
8872 var dense = Array.isArray(ws);
8883 var cell = dense ? (ws[R]||[])[C] : ws[ref];
8912 var ws = wb.Sheets[wb.SheetNames[i]];
8913 if(!ws || !ws["!ref"]) continue;
8914 var range = safe_decode_range(ws["!ref"]);
8915 var dense = Array.isArray(ws);
8923 var cell = dense ? (ws[R]||[])[C] : ws[ref];
8957 var ws = wb.Sheets[name];
8958 if(!ws || !ws["!ref"]) continue;
8960 var range = decode_range(ws["!ref"]);
10392 var ws = o.dense ? [] : {};
10398 if (Array.isArray(ws))
10399 ws[R] = [];
10425 if (Array.isArray(ws))
10426 ws[R][C] = cell;
10428 ws[encode_cell({ r: R, c: C })] = cell;
10441 ws["!ref"] = encode_range(range);
10442 return ws;
10449 function sheet_to_rtf(ws, opts) { argument
10451 if (!ws["!ref"])
10453 var r = safe_decode_range(ws["!ref"]), cell;
10454 var dense = Array.isArray(ws);
10462 cell = dense ? (ws[R] || [])[C] : ws[coord];
15235 function check_ws(ws/*:Worksheet*/, sname/*:string*/, i/*:number*/) { argument
15236 if(ws && ws['!ref']) {
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[…
15241 function parse_ws_xml_dim(ws/*:Worksheet*/, s/*:string*/) { argument
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);
15352 function write_ws_xml_sheetpr(ws, wb, idx, opts, o) { argument
15362 if(ws && ws["!outline"]) {
15364 if(ws["!outline"].above) outlineprops.summaryBelow = 0;
15365 if(ws["!outline"].left) outlineprops.summaryRight = 0;
15446 function write_ws_xml_cols(ws, cols)/*:string*/ { argument
15460 function write_ws_xml_autofilter(data, ws, wb, idx)/*:string*/ { argument
15466 if(range.s.r == range.e.r) { range.e.r = decode_range(ws["!ref"]).e.r; ref = encode_range(range); }
15492 function write_ws_xml_sheetviews(ws, opts, idx, wb)/*:string*/ { argument
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]);
15544 ws['!links'].push([ref, cell.l]);
15737 function write_ws_xml_data(ws/*:Worksheet*/, opts, idx/*:number*/, wb/*:Workbook*//*::, rels*/)/*:s… argument
15738 …/ = [], range = safe_decode_range(ws['!ref']), cell="", ref, rr = "", cols/*:Array<string>*/ = [],…
15739 var dense = Array.isArray(ws);
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);
15787 var ws = wb.Sheets[s];
15788 if(ws == null) ws = {};
15789 var ref = ws['!ref'] || 'A1';
15798 ws['!comments'] = [];
15801 write_ws_xml_sheetpr(ws, wb, idx, opts, o);
15805 o[o.length] = write_ws_xml_sheetviews(ws, opts, idx, wb);
15814 …if(ws['!cols'] != null && ws['!cols'].length > 0) o[o.length] = (write_ws_xml_cols(ws, ws['!cols']…
15817 ws['!links'] = [];
15818 if(ws['!ref'] != null) {
15819 rdata = write_ws_xml_data(ws, opts, idx, wb, rels);
15826 if(ws['!protect']) o[o.length] = write_ws_xml_protection(ws['!protect']);
15831 …if(ws['!autofilter'] != null) o[o.length] = write_ws_xml_autofilter(ws['!autofilter'], ws, wb, idx…
15837 …if(ws['!merges'] != null && ws['!merges'].length > 0) o[o.length] = (write_ws_xml_merges(ws['!merg…
15844 if(/*::(*/ws['!links']/*::||[])*/.length > 0) {
15846 /*::(*/ws['!links']/*::||[])*/.forEach(function(l) {
15860 delete ws['!links'];
15864 if(ws['!margins'] != null) o[o.length] = write_ws_xml_margins(ws['!margins']);
15880 ws['!drawing'] = _drawing;
15883 if(ws['!comments'].length > 0) {
15886 ws['!legacy'] = rId;
15916 function write_BrtRowHdr(R/*:number*/, range, ws) { argument
15918 var row = (ws['!rows']||[])[R]||{};
15948 var cell = Array.isArray(ws) ? (ws[caddr.r]||[])[caddr.c] : ws[encode_cell(caddr)];
15964 function write_row_header(ba, ws, range, R) { argument
15965 var o = write_BrtRowHdr(R, range, ws);
15966 if((o.length > 17) || (ws['!rows']||[])[R]) write_record(ba, 0x0000 /* BrtRowHdr */, o);
15976 //function write_BrtWsFmtInfo(ws, o) { }
16345 function write_BrtBeginWsView(ws, Workbook, o) { argument
16706 function write_ws_bin_cell(ba/*:BufArray*/, cell/*:Cell*/, R/*:number*/, C/*:number*/, opts, ws/*:W… argument
16708 if(cell.c) ws['!comments'].push([encode_cell(o), cell.c]);
16724 if(cell.l) ws['!links'].push([encode_cell(o), cell.l]);
16763 function write_CELLTABLE(ba, ws/*:Worksheet*/, idx/*:number*/, opts/*::, wb:Workbook*/) { argument
16764 var range = safe_decode_range(ws['!ref'] || "A1"), ref, rr = "", cols/*:Array<string>*/ = [];
16766 var dense = Array.isArray(ws);
16768 if(ws['!rows']) cap = Math.max(range.e.r, ws['!rows'].length - 1);
16773 write_row_header(ba, ws, range, R);
16779 var cell = dense ? (ws[R]||[])[C] : ws[ref];
16782 last_seen = write_ws_bin_cell(ba, cell, R, C, opts, ws, last_seen);
16788 function write_MERGECELLS(ba, ws/*:Worksheet*/) { argument
16789 if(!ws || !ws['!merges']) return;
16790 write_record(ba, 0x00B1 /* BrtBeginMergeCells */, write_BrtBeginMergeCells(ws['!merges'].length));
16791ws['!merges'].forEach(function(m) { write_record(ba, 0x00B0 /* BrtMergeCell */, write_BrtMergeCell…
16795 function write_COLINFOS(ba, ws/*:Worksheet*//*::, idx:number, opts, wb:Workbook*/) { argument
16796 if(!ws || !ws['!cols']) return;
16798ws['!cols'].forEach(function(m, i) { if(m) write_record(ba, 0x003C /* 'BrtColInfo' */, write_BrtCo…
16802 function write_IGNOREECS(ba, ws/*:Worksheet*/) { argument
16803 if(!ws || !ws['!ref']) return;
16805 …write_record(ba, 0x0289 /* BrtCellIgnoreEC */, write_BrtCellIgnoreEC(safe_decode_range(ws['!ref'])…
16809 function write_HLINKS(ba, ws/*:Worksheet*/, rels) { argument
16811 ws['!links'].forEach(function(l) {
16816 delete ws['!links'];
16818 function write_LEGACYDRAWING(ba, ws/*:Worksheet*/, idx/*:number*/, rels) { argument
16820 if(ws['!comments'].length > 0) {
16823 ws['!legacy'] = rId;
16827 function write_AUTOFILTER(ba, ws, wb, idx) { argument
16828 if(!ws['!autofilter']) return;
16829 var data = ws['!autofilter'];
16837 if(range.s.r == range.e.r) { range.e.r = decode_range(ws["!ref"]).e.r; ref = encode_range(range); }
16853 function write_WSVIEWS2(ba, ws, Workbook) { argument
16857 write_record(ba, 0x0089 /* BrtBeginWsView */, write_BrtBeginWsView(ws, Workbook));
16868 function write_WSFMTINFO(/*::ba, ws*/) {
16870 // write_record(ba, 0x01E5 /* BrtWsFmtInfo */, write_BrtWsFmtInfo(ws));
16873 function write_SHEETPROTECT(ba, ws) { argument
16874 if(!ws['!protect']) return;
16876 write_record(ba, 0x0217 /* BrtSheetProtection */, write_BrtSheetProtection(ws['!protect']));
16881 var s = wb.SheetNames[idx], ws = wb.Sheets[s] || {};
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…
16889 ws['!links'] = [];
16891 ws['!comments'] = [];
16893 …if(wb.vbaraw || ws['!outline']) write_record(ba, 0x0093 /* BrtWsProp */, write_BrtWsProp(c, ws['!o…
16895 write_WSVIEWS2(ba, ws, wb.Workbook);
16896 write_WSFMTINFO(ba, ws);
16897 write_COLINFOS(ba, ws, idx, opts, wb);
16898 write_CELLTABLE(ba, ws, idx, opts, wb);
16900 write_SHEETPROTECT(ba, ws);
16903 write_AUTOFILTER(ba, ws, wb, idx);
16907 write_MERGECELLS(ba, ws);
16911 write_HLINKS(ba, ws, rels);
16913 if(ws['!margins']) write_record(ba, 0x01DC /* BrtMargins */, write_BrtMargins(ws['!margins']));
16920 if(!opts || opts.ignoreEC || (opts.ignoreEC == (void 0))) write_IGNOREECS(ba, ws);
16923 write_LEGACYDRAWING(ba, ws, idx, rels);
17224 var ws = wb.Sheets[n];
17225 if(!ws || !ws["!autofilter"]) return;
17230 var nn = formula_quote_sheet_name(n) + "!" + fix_range(ws["!autofilter"].ref);
18871 function write_ws_xlml_names(ws/*:Worksheet*/, opts, idx/*:number*/, wb/*:Workbook*/)/*:string*/ { argument
18872 if(!ws) return "";
18889 function write_ws_xlml_wsopts(ws/*:Worksheet*/, opts, idx/*:number*/, wb/*:Workbook*/)/*:string*/ { argument
18890 if(!ws) return "";
18907 if(ws['!margins']) {
18909 if(ws['!margins'].header) o.push(writextag("Header", null, {'x:Margin':ws['!margins'].header}));
18910 if(ws['!margins'].footer) o.push(writextag("Footer", null, {'x:Margin':ws['!margins'].footer}));
18912 'x:Bottom': ws['!margins'].bottom || "0.75",
18913 'x:Left': ws['!margins'].left || "0.7",
18914 'x:Right': ws['!margins'].right || "0.7",
18915 'x:Top': ws['!margins'].top || "0.75"
18972 if(ws['!protect']) {
18974 if(ws['!protect'].objects) o.push(writetag("ProtectObjects", "True"));
18975 if(ws['!protect'].scenarios) o.push(writetag("ProtectScenarios", "True"));
18976 …if(ws['!protect'].selectLockedCells != null && !ws['!protect'].selectLockedCells) o.push(writetag(…
18977 …else if(ws['!protect'].selectUnlockedCells != null && !ws['!protect'].selectUnlockedCells) o.push(…
18990 ].forEach(function(x) { if(ws['!protect'][x[0]]) o.push("<"+x[1]+"/>"); });
19004 function write_ws_xlml_cell(cell, ref/*:string*/, ws, opts, idx/*:number*/, wb, addr)/*:string*/{ argument
19019 if(ws['!merges']) {
19020 var marr = ws['!merges'];
19058 function write_ws_xlml_table(ws/*:Worksheet*/, opts, idx/*:number*/, wb/*:Workbook*/)/*:string*/ { argument
19059 if(!ws['!ref']) return "";
19060 var range/*:Range*/ = safe_decode_range(ws['!ref']);
19061 var marr/*:Array<Range>*/ = ws['!merges'] || [], mi = 0;
19063 if(ws['!cols']) ws['!cols'].forEach(function(n, i) {
19072 var dense = Array.isArray(ws);
19074 var row = [write_ws_xlml_row(R, (ws['!rows']||[])[R])];
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));
19098 var ws = wb.Sheets[s];
19100 var t/*:string*/ = ws ? write_ws_xlml_names(ws, opts, idx, wb) : "";
19104 t = ws ? write_ws_xlml_table(ws, opts, idx, wb) : "";
19108 o.push(write_ws_xlml_wsopts(ws, opts, idx, wb));
19110 …if(ws["!autofilter"]) o.push('<AutoFilter x:Range="' + a1_to_rc(fix_range(ws["!autofilter"].ref), …
21280 function write_ws_biff2(ba/*:BufArray*/, ws/*:Worksheet*/, idx/*:number*/, opts/*::, wb:Workbook*/)… argument
21281 var dense = Array.isArray(ws);
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");
21294 var cell = dense ? (ws[R]||[])[C] : ws[ref];
21337 function write_FEAT(ba, ws) { argument
21348 write_Ref8U(safe_decode_range(ws['!ref']||"A1"), o);
21360 function write_ws_biff8_hlinks(ba/*:BufArray*/, ws) { argument
21361 for(var R=0; R<ws['!links'].length; ++R) {
21362 var HL = ws['!links'][R];
21366 delete ws['!links'];
21410 var s = wb.SheetNames[idx], ws = wb.Sheets[s] || {};
21413 var dense = Array.isArray(ws);
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");
21442 if(b8) write_ws_cols_biff8(ba, ws["!cols"]);
21447 if(b8) ws['!links'] = [];
21454 var cell = dense ? (ws[R]||[])[C] : ws[ref];
21458 if(b8 && cell.l) ws['!links'].push([ref, cell.l]);
21468 …if(b8 && (ws['!merges']||[]).length) write_biff_rec(ba, 0x00e5 /* MergeCells */, write_MergeCells(
21470 if(b8) write_ws_biff8_hlinks(ba, ws);
21474 if(b8) write_FEAT(ba, ws);
21593 var ws = wb.Sheets[wb.SheetNames[i]];
21594 if(!ws || !ws["!ref"]) continue;
21595 var range = decode_range(ws["!ref"]);
21612 var ws/*:Worksheet*/ = opts.dense ? ([]/*:any*/) : ({}/*:any*/);
21658 if(opts.dense) { if(!ws[R]) ws[R] = []; ws[R][C] = o; }
21659 else ws[encode_cell({r:R, c:C})] = o;
21663 ws['!ref'] = encode_range(range);
21664 if(merges.length) ws["!merges"] = merges;
21665 return ws;
21667 function make_html_row(ws/*:Worksheet*/, r/*:Range*/, R/*:number*/, o/*:Sheet2HTMLOpts*/)/*:string*… argument
21668 var M/*:Array<Range>*/ = (ws['!merges'] ||[]);
21681 var cell = o.dense ? (ws[R]||[])[C] : ws[coord];
21718 function make_html_preamble(ws/*:Worksheet*/, R/*:Range*/, o/*:Sheet2HTMLOpts*/)/*:string*/ { argument
21723 function sheet_to_html(ws/*:Worksheet*/, opts/*:?Sheet2HTMLOpts*//*, wb:?Workbook*/)/*:string*/ { argument
21728 var r = decode_range(ws['!ref']);
21729 o.dense = Array.isArray(ws);
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));
21736 function sheet_add_dom(ws/*:Worksheet*/, table/*:HTMLElement*/, _opts/*:?any*/)/*:Worksheet*/ { argument
21756 if(ws["!ref"]) {
21757 var _range/*:Range*/ = decode_range(ws["!ref"]);
21765 var rowinfo/*:Array<RowInfo>*/ = ws["!rows"] || (ws["!rows"] = []);
21767 if(!ws["!cols"]) ws['!cols'] = [];
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;
21816 if(merges.length) ws['!merges'] = (ws["!merges"] || []).concat(merges);
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)); /…
21820 return ws;
21825 var ws/*:Worksheet*/ = opts.dense ? ([]/*:any*/) : ({}/*:any*/);
21826 return sheet_add_dom(ws, table, _opts);
22098 var ws = opts.dense ? ([]/*:any*/) : ({}/*:any*/); variable
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);
22130 if(merges.length) ws['!merges'] = merges;
22131 if(rowinfo.length) ws["!rows"] = rowinfo;
22135 Sheets[sheetag.name] = ws;
22142 ws = opts.dense ? ([]/*:any*/) : ({}/*:any*/); merges = [];
22162 if(opts.dense) { if(!ws[R]) ws[R] = []; ws[R][C] = {t:'z'}; } class
22163 else ws[encode_cell({r:R,c:C})] = {t:'z'};
22178 if(!ws[R]) ws[R] = [];
22179 ws[R][C] = q;
22181 ws[encode_cell({r:R,c:C})] = q;
22258 if(!ws[R + rpt]) ws[R + rpt] = [];
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);
22839 var write_ws = function(ws, wb/*:Workbook*/, i/*:number*/, opts, nfs)/*:string*/ { argument
22843 var R=0,C=0, range = decode_range(ws['!ref']||"A1");
22844 var marr/*:Array<Range>*/ = ws['!merges'] || [], mi = 0;
22845 var dense = Array.isArray(ws);
22846 if(ws["!cols"]) {
22847 …nge.e.c; ++C) o.push(' <table:table-column' + (ws["!cols"][C] ? ' table:style-name="co' + w…
22849 var H = "", ROWS = ws["!rows"]||[];
22871 var ref = encode_cell({r:R, c:C}), cell = dense ? (ws[R]||[])[C]: ws[ref];
22930 wb.SheetNames.map(function(n) { return wb.Sheets[n]; }).forEach(function(ws) { argument
22931 if(!ws) return;
22932 if(ws["!cols"]) {
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";
22949 wb.SheetNames.map(function(n) { return wb.Sheets[n]; }).forEach(function(ws) { argument
22950 if(!ws) return;
22951 if(ws["!rows"]) {
22952 for(var R = 0; R < ws["!rows"].length; ++R) if(ws["!rows"][R]) {
22953 ws["!rows"][R].ods = ridx;
22954 var h = ws["!rows"][R].hpx + "px";
22979 wb.SheetNames.map(function(n) { return wb.Sheets[n]; }).forEach(function(ws) { argument
22980 if(!ws) return;
22981 var range = decode_range(ws["!ref"]);
22983 var c = Array.isArray(ws) ? (ws[R]||[])[C] : ws[encode_cell({r:R,c:C})];
24036 function parse_TST_TableModelArchive(M, root, ws) { argument
24046 ws["!ref"] = encode_range(range);
24047 var dense = Array.isArray(ws);
24072 if (!ws[_R + R])
24073 ws[_R + R] = [];
24074 ws[_R + R][C] = res;
24077 ws[addr] = res;
24089 ws["!merges"] = (_f = parse_shallow(ref.data)) == null ? void 0 : _f[1].map(function(pi) {
24751 function write_numbers_ws(cfb, deps, ws, wsname, sheetidx, rootref) { argument
24764 return write_numbers_tma(cfb, deps, ws, docroot, x, tmaref);
24768 function write_numbers_tma(cfb, deps, ws, tmaroot, tmafile, tmaref) { argument
24769 var range = decode_range(ws["!ref"]);
24782 var data = sheet_to_json(ws, { range: range, header: 1 });
24947 if (ws["!merges"]) {
24957 ws["!merges"].map(function(m) {
25426 var ws = wb.Sheets[wb.SheetNames[rId-1]];
25427 var _type = (ws || {})["!type"] || "sheet";
25438 if(ws) {
25439 var comments = ws['!comments'];
25449 if(ws['!legacy']) {
25450 …if(need_vml) zip_add_file(zip, "xl/drawings/vmlDrawing" + (rId) + ".vml", write_vml(rId, ws['!comm…
25452 delete ws['!comments'];
25453 delete ws['!legacy'];
25564 var ws = wb.Sheets[wb.SheetNames[rId-1]];
25565 var _type = (ws || {})["!type"] || "sheet";
25576 if(ws) {
25577 var comments = ws['!comments'];
25598 if(ws['!legacy']) {
25599 …if(need_vml) zip_add_file(zip, "xl/drawings/vmlDrawing" + (rId) + ".vml", write_vml(rId, ws['!comm…
25601 delete ws['!comments'];
25602 delete ws['!legacy'];
26184 var ws/*:Worksheet*/ = _ws || (dense ? ([]/*:any*/) : ({}/*:any*/));
26186 if(ws && o.origin != null) {
26194 if(ws['!ref']) {
26195 var _range = safe_decode_range(ws['!ref']);
26205 if(dense && !ws[_R + R + offset]) ws[_R + R + offset] = [];
26206 if(dense) ROW = ws[_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*/);
26240 if(dense && !ws[_R]) ws[_R] = [];
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]};
26245 ws['!ref'] = encode_range(range);
26246 return ws;
26251 function ws_get_cell_stub(ws/*:Worksheet*/, R, C/*:?number*/)/*:Cell*/ { argument
26255 if(Array.isArray(ws)) {
26257 if(!ws[RC.r]) ws[RC.r] = [];
26258 return ws[RC.r][RC.c] || (ws[RC.r][RC.c] = {t:'z'});
26260 return ws[R] || (ws[R] = {t:'z'});
26263 if(typeof R != "number") return ws_get_cell_stub(ws, encode_cell(R));
26265 return ws_get_cell_stub(ws, encode_cell({r:R,c:C||0}));
26286 function book_append_sheet(wb/*:Workbook*/, ws/*:Worksheet*/, name/*:?string*/, roll/*:?boolean*/)/… argument
26300 wb.Sheets[name] = ws;
26346 function sheet_set_array_formula(ws/*:Worksheet*/, range, formula/*:string*/, dynamic/*:boolean*/) { argument
26350 var cell = ws_get_cell_stub(ws, R, C);
26359 var wsr = decode_range(ws["!ref"]);
26364 ws["!ref"] = encode_range(wsr);
26365 return ws;
26442 function write_html_stream(ws/*:Worksheet*/, opts/*:?Sheet2HTMLOpts*/) { argument
26449 var r = decode_range(ws['!ref']);
26450 o.dense = Array.isArray(ws);
26451 stream.push(make_html_preamble(ws, r, o));
26460 stream.push(make_html_row(ws, r, R, o));