1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
/*! sheetjs (C) 2013-present SheetJS -- http://sheetjs.com */import { CellObject } from '../../';import { u8_to_dataview, popcnt, readDecimal128LE } from './util';
function parse_old_storage(buf: Uint8Array, sst: string[], rsst: string[]): CellObject {  var dv = u8_to_dataview(buf);  var ctype = buf[buf[0] == 4 ? 1 : 2];
  /* TODO: find the correct field position of number formats, formulae, etc */  var flags = dv.getUint32(4, true);  var data_offset = 12 + popcnt(flags & 0x0D8E) * 4;
  var ridx = -1, sidx = -1, ieee = NaN, dt = new Date(2001, 0, 1);  if(flags & 0x0200) { ridx = dv.getUint32(data_offset,  true); data_offset += 4; }  data_offset += popcnt(flags & 0x3000) * 4;  if(flags & 0x0010) { sidx = dv.getUint32(data_offset,  true); data_offset += 4; }  if(flags & 0x0020) { ieee = dv.getFloat64(data_offset, true); data_offset += 8; }  if(flags & 0x0040) { dt.setTime(dt.getTime() +  dv.getFloat64(data_offset, true) * 1000); data_offset += 8; }
  var ret: CellObject;  switch(ctype) {    case 0: break; // return { t: "z" }; // blank?    case 2: ret = { t: "n", v: ieee }; break; // number    case 3: ret = { t: "s", v: sst[sidx] }; break; // string    case 5: ret = { t: "d", v: dt }; break; // date-time    case 6: ret = { t: "b", v: ieee > 0 }; break; // boolean    case 7: ret = { t: "n", v: ieee }; break; // duration in seconds TODO: emit [hh]:[mm] style format with adjusted value    case 8: ret = { t: "e", v: 0}; break; // "formula error" TODO: enumerate and map errors to csf equivalents    case 9: { // "automatic"?      if(ridx > -1) ret = { t: "s", v: rsst[ridx] };      else if(sidx > -1) ret = { t: "s", v: sst[sidx] };      else if(!isNaN(ieee)) ret = { t: "n", v: ieee };      else throw new Error(`Unsupported cell type ${buf.slice(0,4)}`);    } break;    default: throw new Error(`Unsupported cell type ${buf.slice(0,4)}`);  }  /* TODO: Some fields appear after the cell data */
  return ret;}
function parse_storage(buf: Uint8Array, sst: string[], rsst: string[]): CellObject {  var dv = u8_to_dataview(buf);  var ctype = buf[1];
  /* TODO: find the correct field position of number formats, formulae, etc */  var flags = dv.getUint32(8, true);  var data_offset = 12;
  var ridx = -1, sidx = -1, d128 = NaN, ieee = NaN, dt = new Date(2001, 0, 1);
  if(flags & 0x0001) { d128 = readDecimal128LE(buf, data_offset); data_offset += 16; }  if(flags & 0x0002) { ieee = dv.getFloat64(data_offset, true); data_offset += 8; }  if(flags & 0x0004) { dt.setTime(dt.getTime() +  dv.getFloat64(data_offset, true) * 1000); data_offset += 8; }  if(flags & 0x0008) { sidx = dv.getUint32(data_offset,  true); data_offset += 4; }  if(flags & 0x0010) { ridx = dv.getUint32(data_offset,  true); data_offset += 4; }
  var ret: CellObject;  switch(ctype) {    case 0: break; // return { t: "z" }; // blank?    case 2: ret = { t: "n", v: d128 }; break; // number    case 3: ret = { t: "s", v: sst[sidx] }; break; // string    case 5: ret = { t: "d", v: dt }; break; // date-time    case 6: ret = { t: "b", v: ieee > 0 }; break; // boolean    case 7: ret = { t: "n", v: ieee }; break;  // duration in seconds TODO: emit [hh]:[mm] style format with adjusted value    case 8: ret = { t: "e", v: 0}; break; // "formula error" TODO: enumerate and map errors to csf equivalents    case 9: { // "automatic"?      if(ridx > -1) ret = { t: "s", v: rsst[ridx] };      else throw new Error(`Unsupported cell type ${ctype} : ${flags & 0x1F} : ${buf.slice(0,4)}`);    } break;    case 10: ret = { t: "n", v: d128 }; break; // currency    default: throw new Error(`Unsupported cell type ${ctype} : ${flags & 0x1F} : ${buf.slice(0,4)}`);  }  /* TODO: All styling fields appear after the cell data */
  return ret;}
function parse(buf: Uint8Array, sst: string[], rsst: string[]): CellObject {  switch(buf[0]) {    /* TODO: 0-2? */    case 3: case 4: return parse_old_storage(buf, sst, rsst);    case 5: return parse_storage(buf, sst, rsst);    default: throw new Error(`Unsupported payload version ${buf[0]}`);  }}
export { parse };