// https://github.com/looker/ssf/blob/master/ssf.js /* ssf.js (C) 2013-present SheetJS -- http://sheetjs.com */ /** * Formatting options interface * Interface for formatting options */ interface SSFOptions { /** Whether to use 1904 date system */ date1904?: boolean; /** Date number format */ dateNF?: string; /** Format table */ table?: { [key: number]: string }; } /** * Parsed date code object * Parsed date code object */ interface DateCode { /** Date */ D: number; /** Time */ T: number; /** Microseconds */ u: number; /** Year */ y: number; /** Month */ m: number; /** Day */ d: number; /** Hour */ H: number; /** Minute */ M: number; /** Second */ S: number; /** Day of week */ q: number; } /** * Formatting token object * Format token object */ interface FormatToken { /** Token type */ t: string; /** Token value */ v: string; } /** * Value type for formatting */ type FormatValue = string | number | boolean | Date | null | undefined; /** * Spreadsheet formatting utility class * Spreadsheet formatter class */ class SSF { /** * SSF version * The version of SSF */ static version: string = '0.10.3'; /** * Reference to parse_date_code function * Reference to parse_date_code function */ static parse_date_code: (v: number, opts?: SSFOptions, b2?: boolean) => DateCode | null; /** * Reference to general integer formatting function * Reference to general integer formatting function */ static _general_int: (v: number) => string; /** * Reference to general number formatting function * Reference to general number formatting function */ static _general_num: (v: number) => string; /** * Reference to general formatting function * Reference to general formatting function */ static _general: (v: FormatValue, opts?: SSFOptions) => string; /** * Reference to split format function * Reference to split format function */ static _split: (fmt: string) => string[]; /** * Reference to date format detection function * Reference to date format detection function */ static is_date: (fmt: string) => boolean; /** * Reference to format evaluation function * Reference to format evaluation function */ static _eval: (fmt: string, v: FormatValue, opts?: SSFOptions, flen?: number) => string; /** * Reference to internal format table * Reference to internal format table */ static _table: { [key: number]: string }; /** * Get the internal format table * Get the internal format table */ static get_table: () => { [key: number]: string }; /** * Load format table * Load format table */ static load_table: (tbl: { [key: number]: string }) => void; /** * Initialize format table * Initialize format table */ static init_table: (t: { [key: number]: string }) => void; /** * Load format entry * Load format entry */ static load: (fmt: string, idx?: number) => number; /** * Main formatting function * Main formatting function */ static format: (fmt: string | number, v: FormatValue, o?: SSFOptions) => string; } /** * Reverse a string * Reverse a string */ function _strrev(x: string): string { let o = "", i = x.length - 1; while (i >= 0) o += x.charAt(i--); return o; } /** * Fill with specified character to specified length * Fill with specified character to specified length */ function fill(c: string, l: number): string { let o = ""; while (o.length < l) o += c; return o; } /** * Pad number with zeros to specified length * Pad number with zeros to specified length */ function pad0(v: number | string, d: number): string { const t = "" + v; return t.length >= d ? t : fill('0', d - t.length) + t; } /** * Pad with spaces to specified length (left padding) * Pad with spaces to specified length (left padding) */ function pad_(v: number | string, d: number): string { const t = "" + v; return t.length >= d ? t : fill(' ', d - t.length) + t; } /** * Pad with spaces to specified length (right padding) * Pad with spaces to specified length (right padding) */ function rpad_(v: number | string, d: number): string { const t = "" + v; return t.length >= d ? t : t + fill(' ', d - t.length); } /** * Round and pad with zeros * Round and pad with zeros */ function pad0r1(v: number, d: number): string { const t = "" + Math.round(v); return t.length >= d ? t : fill('0', d - t.length) + t; } /** * Convert to string and pad with zeros * Convert to string and pad with zeros */ function pad0r2(v: number, d: number): string { const t = "" + v; return t.length >= d ? t : fill('0', d - t.length) + t; } const p2_32 = Math.pow(2, 32); /** * Round and pad with zeros (handles large numbers) * Round and pad with zeros (handling large numbers) */ function pad0r(v: number, d: number): string { if (v > p2_32 || v < -p2_32) return pad0r1(v, d); const i = Math.round(v); return pad0r2(i, d); } /** * Check if format is general format * Check if format is general */ function isgeneral(s: string, i?: number): boolean { i = i || 0; return s.length >= 7 + i && (s.charCodeAt(i) | 32) === 103 && (s.charCodeAt(i + 1) | 32) === 101 && (s.charCodeAt(i + 2) | 32) === 110 && (s.charCodeAt(i + 3) | 32) === 101 && (s.charCodeAt(i + 4) | 32) === 114 && (s.charCodeAt(i + 5) | 32) === 97 && (s.charCodeAt(i + 6) | 32) === 108; } /** * Day of week array * Days array */ const days: string[][] = [ ['Sun', 'Sunday'], ['Mon', 'Monday'], ['Tue', 'Tuesday'], ['Wed', 'Wednesday'], ['Thu', 'Thursday'], ['Fri', 'Friday'], ['Sat', 'Saturday'] ]; /** * Month array * Months array */ const months: string[][] = [ ['J', 'Jan', 'January'], ['F', 'Feb', 'February'], ['M', 'Mar', 'March'], ['A', 'Apr', 'April'], ['M', 'May', 'May'], ['J', 'Jun', 'June'], ['J', 'Jul', 'July'], ['A', 'Aug', 'August'], ['S', 'Sep', 'September'], ['O', 'Oct', 'October'], ['N', 'Nov', 'November'], ['D', 'Dec', 'December'] ]; /** * Initialize format table * Initialize format table */ function init_table(t: { [key: number]: string }): void { t[0] = 'General'; t[1] = '0'; t[2] = '0.00'; t[3] = '#,##0'; t[4] = '#,##0.00'; t[9] = '0%'; t[10] = '0.00%'; t[11] = '0.00E+00'; t[12] = '# ?/?'; t[13] = '# ??/??'; t[14] = 'm/d/yy'; t[15] = 'd-mmm-yy'; t[16] = 'd-mmm'; t[17] = 'mmm-yy'; t[18] = 'h:mm AM/PM'; t[19] = 'h:mm:ss AM/PM'; t[20] = 'h:mm'; t[21] = 'h:mm:ss'; t[22] = 'm/d/yy h:mm'; t[37] = '#,##0 ;(#,##0)'; t[38] = '#,##0 ;[Red](#,##0)'; t[39] = '#,##0.00;(#,##0.00)'; t[40] = '#,##0.00;[Red](#,##0.00)'; t[45] = 'mm:ss'; t[46] = '[h]:mm:ss'; t[47] = 'mmss.0'; t[48] = '##0.0E+0'; t[49] = '@'; t[56] = '"AM/PM "hh"h"mm"m"ss"s "'; t[65535] = 'General'; } /** * Format table * Format table */ const table_fmt: { [key: number]: string } = {}; init_table(table_fmt); /** * Fraction calculation * Fraction calculation */ function frac(x: number, D: number, mixed?: boolean): [number, number, number] { const sgn = x < 0 ? -1 : 1; let B = x * sgn; let P_2 = 0, P_1 = 1, P = 0; let Q_2 = 1, Q_1 = 0, Q = 0; let A = Math.floor(B); while (Q_1 < D) { A = Math.floor(B); P = A * P_1 + P_2; Q = A * Q_1 + Q_2; if ((B - A) < 0.00000005) break; B = 1 / (B - A); P_2 = P_1; P_1 = P; Q_2 = Q_1; Q_1 = Q; } if (Q > D) { if (Q_1 > D) { Q = Q_2; P = P_2; } else { Q = Q_1; P = P_1; } } if (!mixed) return [0, sgn * P, Q]; const q = Math.floor(sgn * P / Q); return [q, sgn * P - q * Q, Q]; } /** * Parse date code * Parse date code */ function parse_date_code(v: number, opts?: SSFOptions, b2?: boolean): DateCode | null { if (v > 2958465 || v < 0) return null; let date = (v | 0), time = Math.floor(86400 * (v - date)), dow = 0; let dout: number[] = []; const out: DateCode = {D: date, T: time, u: 86400 * (v - date) - time, y: 0, m: 0, d: 0, H: 0, M: 0, S: 0, q: 0}; if (Math.abs(out.u) < 1e-6) out.u = 0; if (opts && opts.date1904) date += 1462; if (out.u > 0.9999) { out.u = 0; if (++time === 86400) { out.T = time = 0; ++date; ++out.D; } } if (date === 60) { dout = b2 ? [1317, 10, 29] : [1900, 2, 29]; dow = 3; } else if (date === 0) { dout = b2 ? [1317, 8, 29] : [1900, 1, 0]; dow = 6; } else { if (date > 60) --date; /* 1 = Jan 1 1900 in Gregorian */ const d = new Date(1900, 0, 1); d.setDate(d.getDate() + date - 1); dout = [d.getFullYear(), d.getMonth() + 1, d.getDate()]; dow = d.getDay(); if (date < 60) dow = (dow + 6) % 7; if (b2) dow = fix_hijri(); } out.y = dout[0]; out.m = dout[1]; out.d = dout[2]; out.S = time % 60; time = Math.floor(time / 60); out.M = time % 60; time = Math.floor(time / 60); out.H = time; out.q = dow; return out; } SSF.parse_date_code = parse_date_code; const basedate = new Date(1899, 11, 31, 0, 0, 0); const dnthresh = basedate.getTime(); const base1904 = new Date(1900, 2, 1, 0, 0, 0); /** * Date to number (local time) * Convert date to number (local time) */ function datenum_local(v: Date, date1904?: boolean): number { let epoch = v.getTime(); if (date1904) epoch -= 1461 * 24 * 60 * 60 * 1000; else if (v >= base1904) epoch += 24 * 60 * 60 * 1000; return (epoch - (dnthresh + (v.getTimezoneOffset() - basedate.getTimezoneOffset()) * 60000)) / (24 * 60 * 60 * 1000); } /** * General integer formatting * General integer formatting */ function general_fmt_int(v: number): string { return v.toString(10); } SSF._general_int = general_fmt_int; /** * General number formatting function generator * General number formatting function generator */ const general_fmt_num = (function make_general_fmt_num() { const gnr1 = /\.(\d*[1-9])0+$/, gnr2 = /\.0*$/, gnr4 = /\.(\d*[1-9])0+/, gnr5 = /\.0*[Ee]/, gnr6 = /(E[+-])(\d)$/; function gfn2(v: number): string { const w = (v < 0 ? 12 : 11); let o = gfn5(v.toFixed(12)); if (o.length <= w) return o; o = v.toPrecision(10); if (o.length <= w) return o; return v.toExponential(5); } function gfn3(v: number): string { let o = v.toFixed(11).replace(gnr1, ".$1"); if (o.length > (v < 0 ? 12 : 11)) o = v.toPrecision(6); return o; } function gfn4(o: string): string { for (let i = 0; i !== o.length; ++i) if ((o.charCodeAt(i) | 0x20) === 101) return o.replace(gnr4, ".$1").replace(gnr5, "E").replace("e", "E").replace(gnr6, "$10$2"); return o; } function gfn5(o: string): string { return o.indexOf(".") > -1 ? o.replace(gnr2, "").replace(gnr1, ".$1") : o; } return function general_fmt_num(v: number): string { let V = Math.floor(Math.log(Math.abs(v)) * Math.LOG10E), o: string; if (V >= -4 && V <= -1) o = v.toPrecision(10 + V); else if (Math.abs(V) <= 9) o = gfn2(v); else if (V === 10) o = v.toFixed(10).substr(0, 12); else o = gfn3(v); return gfn5(gfn4(o)); }; })(); SSF._general_num = general_fmt_num; /** * General formatting * General formatting */ function general_fmt(v: FormatValue, opts?: SSFOptions): string { switch (typeof v) { case 'string': return v; case 'boolean': return v ? "TRUE" : "FALSE"; case 'number': return (v | 0) === v ? general_fmt_int(v) : general_fmt_num(v); case 'undefined': return ""; case 'object': if (v == null) return ""; if (v instanceof Date) return format(14, datenum_local(v, opts && opts.date1904), opts); } throw new Error("unsupported value in General format: " + v); } SSF._general = general_fmt; /** * Fix Hijri date (placeholder function) * Fix Hijri date (placeholder function) */ function fix_hijri(): number { return 0; } /*jshint -W086 */ /** * Write date * Write date */ function write_date(type: number, fmt: string, val: DateCode, ss0?: number): string { let o = "", ss = 0, tt = 0, y = val.y, out: number, outl = 0; switch (type) { case 98: /* 'b' buddhist year */ y = val.y + 543; // falls through case 121: /* 'y' year */ switch (fmt.length) { case 1: case 2: out = y % 100; outl = 2; break; default: out = y % 10000; outl = 4; break; } break; case 109: /* 'm' month */ switch (fmt.length) { case 1: case 2: out = val.m; outl = fmt.length; break; case 3: return months[val.m - 1][1]; case 5: return months[val.m - 1][0]; default: return months[val.m - 1][2]; } break; case 100: /* 'd' day */ switch (fmt.length) { case 1: case 2: out = val.d; outl = fmt.length; break; case 3: return days[val.q][0]; default: return days[val.q][1]; } break; case 104: /* 'h' 12-hour */ switch (fmt.length) { case 1: case 2: out = 1 + (val.H + 11) % 12; outl = fmt.length; break; default: throw 'bad hour format: ' + fmt; } break; case 72: /* 'H' 24-hour */ switch (fmt.length) { case 1: case 2: out = val.H; outl = fmt.length; break; default: throw 'bad hour format: ' + fmt; } break; case 77: /* 'M' minutes */ switch (fmt.length) { case 1: case 2: out = val.M; outl = fmt.length; break; default: throw 'bad minute format: ' + fmt; } break; case 115: /* 's' seconds */ if (fmt !== 's' && fmt !== 'ss' && fmt !== '.0' && fmt !== '.00' && fmt !== '.000') throw 'bad second format: ' + fmt; if (val.u === 0 && (fmt === "s" || fmt === "ss")) return pad0(val.S, fmt.length); if ((ss0 || 0) >= 2) tt = ss0 === 3 ? 1000 : 100; else tt = ss0 === 1 ? 10 : 1; ss = Math.round((tt) * (val.S + val.u)); if (ss >= 60 * tt) ss = 0; if (fmt === 's') return ss === 0 ? "0" : "" + ss / tt; o = pad0(ss, 2 + (ss0 || 0)); if (fmt === 'ss') return o.substr(0, 2); return "." + o.substr(2, fmt.length - 1); case 90: /* 'Z' absolute time */ switch (fmt) { case '[h]': case '[hh]': out = val.D * 24 + val.H; break; case '[m]': case '[mm]': out = (val.D * 24 + val.H) * 60 + val.M; break; case '[s]': case '[ss]': out = ((val.D * 24 + val.H) * 60 + val.M) * 60 + Math.round(val.S + val.u); break; default: throw 'bad abstime format: ' + fmt; } outl = fmt.length === 3 ? 1 : 2; break; case 101: /* 'e' era */ out = y; outl = 1; } if (outl > 0) return pad0(out!, outl); else return ""; } /*jshint +W086 */ /** * Add comma separator * Add comma separators */ function commaify(s: string): string { const w = 3; if (s.length <= w) return s; let j = (s.length % w), o = s.substr(0, j); for (; j !== s.length; j += w) o += (o.length > 0 ? "," : "") + s.substr(j, w); return o; } /** * Number writing function generator * Number writing function generator */ const write_num = (function make_write_num() { const pct1 = /%/g; function write_num_pct(type: string, fmt: string, val: number): string { const sfmt = fmt.replace(pct1, ""), mul = fmt.length - sfmt.length; return write_num(type, sfmt, val * Math.pow(10, 2 * mul)) + fill("%", mul); } function write_num_cm(type: string, fmt: string, val: number): string { let idx = fmt.length - 1; while (fmt.charCodeAt(idx - 1) === 44) --idx; return write_num(type, fmt.substr(0, idx), val / Math.pow(10, 3 * (fmt.length - idx))); } function write_num_exp(fmt: string, val: number): string { let o: string; let idx = fmt.indexOf("E") - fmt.indexOf(".") - 1; if (fmt.match(/^#+0.0E\+0$/)) { if (val === 0) return "0.0E+0"; else if (val < 0) return "-" + write_num_exp(fmt, -val); let period = fmt.indexOf("."); if (period === -1) period = fmt.indexOf('E'); let ee = Math.floor(Math.log(val) * Math.LOG10E) % period; if (ee < 0) ee += period; o = (val / Math.pow(10, ee)).toPrecision(idx + 1 + (period + ee) % period); if (o.indexOf("e") === -1) { const fakee = Math.floor(Math.log(val) * Math.LOG10E); if (o.indexOf(".") === -1) o = o.charAt(0) + "." + o.substr(1) + "E+" + (fakee - o.length + ee); else o += "E+" + (fakee - ee); while (o.substr(0, 2) === "0.") { o = o.charAt(0) + o.substr(2, period) + "." + o.substr(2 + period); o = o.replace(/^0+([1-9])/, "$1").replace(/^0+\./, "0."); } o = o.replace(/\+-/, "-"); } o = o.replace(/^([+-]?)(\d*)\.(\d*)[Ee]/, function ($$: string, $1: string, $2: string, $3: string) { return $1 + $2 + $3.substr(0, (period + ee) % period) + "." + $3.substr(ee) + "E"; }); } else o = val.toExponential(idx); if (fmt.match(/E\+00$/) && o.match(/e[+-]\d$/)) o = o.substr(0, o.length - 1) + "0" + o.charAt(o.length - 1); if (fmt.match(/E\-/) && o.match(/e\+/)) o = o.replace(/e\+/, "e"); return o.replace("e", "E"); } const frac1 = /# (\?+)( ?)\/( ?)(\d+)/; function write_num_f1(r: RegExpMatchArray, aval: number, sign: string): string { const den = parseInt(r[4], 10), rr = Math.round(aval * den), base = Math.floor(rr / den); let myn = (rr - base * den), myd = den; return sign + (base === 0 ? "" : "" + base) + " " + (myn === 0 ? fill(" ", r[1].length + 1 + r[4].length) : pad_(myn, r[1].length) + r[2] + "/" + r[3] + pad0(myd, r[4].length)); } function write_num_f2(r: RegExpMatchArray, aval: number, sign: string): string { return sign + (aval === 0 ? "" : "" + aval) + fill(" ", r[1].length + 2 + r[4].length); } const dec1 = /^#*0*\.([0#]+)/; const closeparen = /\).*[0#]/; const phone = /\(###\) ###\\?-####/; function hashq(str: string): string { let o = "", cc: number; for (let i = 0; i !== str.length; ++i) switch ((cc = str.charCodeAt(i))) { case 35: break; case 63: o += " "; break; case 48: o += "0"; break; default: o += String.fromCharCode(cc); } return o; } function rnd(val: number, d: number): string { const dd = Math.pow(10, d); return "" + (Math.round(val * dd) / dd); } function dec(val: number, d: number): number { if (d < ('' + Math.round((val - Math.floor(val)) * Math.pow(10, d))).length) { return 0; } return Math.round((val - Math.floor(val)) * Math.pow(10, d)); } function carry(val: number, d: number): number { if (d < ('' + Math.round((val - Math.floor(val)) * Math.pow(10, d))).length) { return 1; } return 0; } function flr(val: number): string { if (val < 2147483647 && val > -2147483648) return "" + (val >= 0 ? (val | 0) : (val - 1 | 0)); return "" + Math.floor(val); } function write_num_flt(type: string, fmt: string, val: number): string { if (type.charCodeAt(0) === 40 && !fmt.match(closeparen)) { const ffmt = fmt.replace(/\( */, "").replace(/ \)/, "").replace(/\)/, ""); if (val >= 0) return write_num_flt('n', ffmt, val); return '(' + write_num_flt('n', ffmt, -val) + ')'; } if (fmt.charCodeAt(fmt.length - 1) === 44) return write_num_cm(type, fmt, val); if (fmt.indexOf('%') !== -1) return write_num_pct(type, fmt, val); if (fmt.indexOf('E') !== -1) return write_num_exp(fmt, val); if (fmt.charCodeAt(0) === 36) return "$" + write_num_flt(type, fmt.substr(fmt.charAt(1) == ' ' ? 2 : 1), val); let o: string; let r: RegExpMatchArray | null, ri: number, ff: [number, number, number], aval = Math.abs(val), sign = val < 0 ? "-" : ""; if (fmt.match(/^00+$/)) return sign + pad0r(aval, fmt.length); if (fmt.match(/^[#?]+$/)) { o = pad0r(val, 0); if (o === "0") o = ""; return o.length > fmt.length ? o : hashq(fmt.substr(0, fmt.length - o.length)) + o; } if ((r = fmt.match(frac1))) return write_num_f1(r, aval, sign); if (fmt.match(/^#+0+$/)) return sign + pad0r(aval, fmt.length - fmt.indexOf("0")); if ((r = fmt.match(dec1))) { o = rnd(val, r[1].length).replace(/^([^\.]+)$/, "$1." + hashq(r[1])).replace(/\.$/, "." + hashq(r[1])).replace(/\.(\d*)$/, function ($$: string, $1: string) { return "." + $1 + fill("0", hashq(r![1]).length - $1.length); }); return fmt.indexOf("0.") !== -1 ? o : o.replace(/^0\./, "."); } fmt = fmt.replace(/^#+([0.])/, "$1"); if ((r = fmt.match(/^(0*)\.(#*)$/))) { return sign + rnd(aval, r[2].length).replace(/\.(\d*[1-9])0*$/, ".$1").replace(/^(-?\d*)$/, "$1.").replace(/^0\./, r[1].length ? "0." : "."); } if ((r = fmt.match(/^#{1,3},##0(\.?)$/))) return sign + commaify(pad0r(aval, 0)); if ((r = fmt.match(/^#,##0\.([#0]*0)$/))) { return val < 0 ? "-" + write_num_flt(type, fmt, -val) : commaify("" + (Math.floor(val) + carry(val, r[1].length))) + "." + pad0(dec(val, r[1].length), r[1].length); } if ((r = fmt.match(/^#,#*,#0/))) return write_num_flt(type, fmt.replace(/^#,#*,/, ""), val); if ((r = fmt.match(/^([0#]+)(\\?-([0#]+))+$/))) { o = _strrev(write_num_flt(type, fmt.replace(/[\\-]/g, ""), val)); ri = 0; return _strrev(_strrev(fmt.replace(/\\/g, "")).replace(/[0#]/g, function (x: string) { return ri < o.length ? o.charAt(ri++) : x === '0' ? '0' : ""; })); } if (fmt.match(phone)) { o = write_num_flt(type, "##########", val); return "(" + o.substr(0, 3) + ") " + o.substr(3, 3) + "-" + o.substr(6); } let oa = ""; if ((r = fmt.match(/^([#0?]+)( ?)\/( ?)([#0?]+)/))) { ri = Math.min(r[4].length, 7); ff = frac(aval, Math.pow(10, ri) - 1, false); o = "" + sign; oa = write_num("n", r[1], ff[1]); if (oa.charAt(oa.length - 1) === " ") oa = oa.substr(0, oa.length - 1) + "0"; o += oa + r[2] + "/" + r[3]; oa = rpad_(ff[2], ri); if (oa.length < r[4].length) oa = hashq(r[4].substr(r[4].length - oa.length)) + oa; o += oa; return o; } if ((r = fmt.match(/^# ([#0?]+)( ?)\/( ?)([#0?]+)/))) { ri = Math.min(Math.max(r[1].length, r[4].length), 7); ff = frac(aval, Math.pow(10, ri) - 1, true); return sign + (ff[0] || (ff[1] ? "" : "0")) + " " + (ff[1] ? pad_(ff[1], ri) + r[2] + "/" + r[3] + rpad_(ff[2], ri) : fill(" ", 2 * ri + 1 + r[2].length + r[3].length)); } if ((r = fmt.match(/^[#0?]+$/))) { o = pad0r(val, 0); if (fmt.length <= o.length) return o; return hashq(fmt.substr(0, fmt.length - o.length)) + o; } if ((r = fmt.match(/^([#0?]+)\.([#0]+)$/))) { o = "" + val.toFixed(Math.min(r[2].length, 10)).replace(/([^0])0+$/, "$1"); ri = o.indexOf("."); const lres = fmt.indexOf(".") - ri, rres = fmt.length - o.length - lres; return hashq(fmt.substr(0, lres) + o + fmt.substr(fmt.length - rres)); } if ((r = fmt.match(/^00,000\.([#0]*0)$/))) { ri = dec(val, r[1].length); return val < 0 ? "-" + write_num_flt(type, fmt, -val) : commaify(flr(val)).replace(/^\d,\d{3}$/, "0$&").replace(/^\d*$/, function ($$: string) { return "00," + ($$.length < 3 ? pad0(0, 3 - $$.length) : "") + $$; }) + "." + pad0(ri, r[1].length); } switch (fmt) { case "###,##0.00": return write_num_flt(type, "#,##0.00", val); case "###,###": case "##,###": case "#,###": const x = commaify(pad0r(aval, 0)); return x !== "0" ? sign + x : ""; case "###,###.00": return write_num_flt(type, "###,##0.00", val).replace(/^0\./, "."); case "#,###.00": return write_num_flt(type, "#,##0.00", val).replace(/^0\./, "."); default: } throw new Error("unsupported format |" + fmt + "|"); } function write_num_cm2(type: string, fmt: string, val: number): string { let idx = fmt.length - 1; while (fmt.charCodeAt(idx - 1) === 44) --idx; return write_num(type, fmt.substr(0, idx), val / Math.pow(10, 3 * (fmt.length - idx))); } function write_num_pct2(type: string, fmt: string, val: number): string { const sfmt = fmt.replace(pct1, ""), mul = fmt.length - sfmt.length; return write_num(type, sfmt, val * Math.pow(10, 2 * mul)) + fill("%", mul); } function write_num_exp2(fmt: string, val: number): string { let o: string; let idx = fmt.indexOf("E") - fmt.indexOf(".") - 1; if (fmt.match(/^#+0.0E\+0$/)) { if (val === 0) return "0.0E+0"; else if (val < 0) return "-" + write_num_exp2(fmt, -val); let period = fmt.indexOf("."); if (period === -1) period = fmt.indexOf('E'); let ee = Math.floor(Math.log(val) * Math.LOG10E) % period; if (ee < 0) ee += period; o = (val / Math.pow(10, ee)).toPrecision(idx + 1 + (period + ee) % period); if (!o.match(/[Ee]/)) { const fakee = Math.floor(Math.log(val) * Math.LOG10E); if (o.indexOf(".") === -1) o = o.charAt(0) + "." + o.substr(1) + "E+" + (fakee - o.length + ee); else o += "E+" + (fakee - ee); o = o.replace(/\+-/, "-"); } o = o.replace(/^([+-]?)(\d*)\.(\d*)[Ee]/, function ($$: string, $1: string, $2: string, $3: string) { return $1 + $2 + $3.substr(0, (period + ee) % period) + "." + $3.substr(ee) + "E"; }); } else o = val.toExponential(idx); if (fmt.match(/E\+00$/) && o.match(/e[+-]\d$/)) o = o.substr(0, o.length - 1) + "0" + o.charAt(o.length - 1); if (fmt.match(/E\-/) && o.match(/e\+/)) o = o.replace(/e\+/, "e"); return o.replace("e", "E"); } function write_num_int(type: string, fmt: string, val: number): string { if (type.charCodeAt(0) === 40 && !fmt.match(closeparen)) { const ffmt = fmt.replace(/\( */, "").replace(/ \)/, "").replace(/\)/, ""); if (val >= 0) return write_num_int('n', ffmt, val); return '(' + write_num_int('n', ffmt, -val) + ')'; } if (fmt.charCodeAt(fmt.length - 1) === 44) return write_num_cm2(type, fmt, val); if (fmt.indexOf('%') !== -1) return write_num_pct2(type, fmt, val); if (fmt.indexOf('E') !== -1) return write_num_exp2(fmt, val); if (fmt.charCodeAt(0) === 36) return "$" + write_num_int(type, fmt.substr(fmt.charAt(1) == ' ' ? 2 : 1), val); let o: string; let r: RegExpMatchArray | null, ri: number, ff: [number, number, number], aval = Math.abs(val), sign = val < 0 ? "-" : ""; if (fmt.match(/^00+$/)) return sign + pad0(aval, fmt.length); if (fmt.match(/^[#?]+$/)) { o = ("" + val); if (val === 0) o = ""; return o.length > fmt.length ? o : hashq(fmt.substr(0, fmt.length - o.length)) + o; } if ((r = fmt.match(frac1))) return write_num_f2(r, aval, sign); if (fmt.match(/^#+0+$/)) return sign + pad0(aval, fmt.length - fmt.indexOf("0")); if ((r = fmt.match(dec1))) { o = ("" + val).replace(/^([^\.]+)$/, "$1." + hashq(r[1])).replace(/\.$/, "." + hashq(r[1])); o = o.replace(/\.(\d*)$/, function ($$: string, $1: string) { return "." + $1 + fill("0", hashq(r![1]).length - $1.length); }); return fmt.indexOf("0.") !== -1 ? o : o.replace(/^0\./, "."); } fmt = fmt.replace(/^#+([0.])/, "$1"); if ((r = fmt.match(/^(0*)\.(#*)$/))) { return sign + ("" + aval).replace(/\.(\d*[1-9])0*$/, ".$1").replace(/^(-?\d*)$/, "$1.").replace(/^0\./, r[1].length ? "0." : "."); } if ((r = fmt.match(/^#{1,3},##0(\.?)$/))) return sign + commaify(("" + aval)); if ((r = fmt.match(/^#,##0\.([#0]*0)$/))) { return val < 0 ? "-" + write_num_int(type, fmt, -val) : commaify(("" + val)) + "." + fill('0', r[1].length); } if ((r = fmt.match(/^#,#*,#0/))) return write_num_int(type, fmt.replace(/^#,#*,/, ""), val); if ((r = fmt.match(/^([0#]+)(\\?-([0#]+))+$/))) { o = _strrev(write_num_int(type, fmt.replace(/[\\-]/g, ""), val)); ri = 0; return _strrev(_strrev(fmt.replace(/\\/g, "")).replace(/[0#]/g, function (x: string) { return ri < o.length ? o.charAt(ri++) : x === '0' ? '0' : ""; })); } if (fmt.match(phone)) { o = write_num_int(type, "##########", val); return "(" + o.substr(0, 3) + ") " + o.substr(3, 3) + "-" + o.substr(6); } let oa = ""; if ((r = fmt.match(/^([#0?]+)( ?)\/( ?)([#0?]+)/))) { ri = Math.min(r[4].length, 7); ff = frac(aval, Math.pow(10, ri) - 1, false); o = "" + sign; oa = write_num("n", r[1], ff[1]); if (oa.charAt(oa.length - 1) == " ") oa = oa.substr(0, oa.length - 1) + "0"; o += oa + r[2] + "/" + r[3]; oa = rpad_(ff[2], ri); if (oa.length < r[4].length) oa = hashq(r[4].substr(r[4].length - oa.length)) + oa; o += oa; return o; } if ((r = fmt.match(/^# ([#0?]+)( ?)\/( ?)([#0?]+)/))) { ri = Math.min(Math.max(r[1].length, r[4].length), 7); ff = frac(aval, Math.pow(10, ri) - 1, true); return sign + (ff[0] || (ff[1] ? "" : "0")) + " " + (ff[1] ? pad_(ff[1], ri) + r[2] + "/" + r[3] + rpad_(ff[2], ri) : fill(" ", 2 * ri + 1 + r[2].length + r[3].length)); } if ((r = fmt.match(/^[#0?]+$/))) { o = "" + val; if (fmt.length <= o.length) return o; return hashq(fmt.substr(0, fmt.length - o.length)) + o; } if ((r = fmt.match(/^([#0]+)\.([#0]+)$/))) { o = "" + val.toFixed(Math.min(r[2].length, 10)).replace(/([^0])0+$/, "$1"); ri = o.indexOf("."); let lres = fmt.indexOf(".") - ri, rres = fmt.length - o.length - lres; return hashq(fmt.substr(0, lres) + o + fmt.substr(fmt.length - rres)); } if ((r = fmt.match(/^00,000\.([#0]*0)$/))) { return val < 0 ? "-" + write_num_int(type, fmt, -val) : commaify("" + val).replace(/^\d,\d{3}$/, "0$&").replace(/^\d*$/, function ($$: string) { return "00," + ($$.length < 3 ? pad0(0, 3 - $$.length) : "") + $$; }) + "." + pad0(0, r[1].length); } switch (fmt) { case "###,###": case "##,###": case "#,###": const x = commaify("" + aval); return x !== "0" ? sign + x : ""; default: if (fmt.match(/\.[0#?]*$/)) return write_num_int(type, fmt.slice(0, fmt.lastIndexOf(".")), val) + hashq(fmt.slice(fmt.lastIndexOf("."))); } throw new Error("unsupported format |" + fmt + "|"); } return function write_num(type: string, fmt: string, val: number): string { return (val | 0) === val ? write_num_int(type, fmt, val) : write_num_flt(type, fmt, val); }; })(); /** * Split formatting string * Split format string */ function split_fmt(fmt: string): string[] { const out: string[] = []; let in_str = false, j = 0; for (let i = 0; i < fmt.length; ++i) switch ((/*cc=*/fmt.charCodeAt(i))) { case 34: /* '"' */ in_str = !in_str; break; case 95: case 42: case 92: /* '_' '*' '\\' */ ++i; break; case 59: /* ';' */ out[out.length] = fmt.substr(j, i - j); j = i + 1; } out[out.length] = fmt.substr(j); if (in_str === true) throw new Error("Format |" + fmt + "| unterminated string "); return out; } SSF._split = split_fmt; const abstime = /\[[HhMmSs]*\]/; /** * Check if format is a date format * Check if format is date format */ function fmt_is_date(fmt: string): boolean { let i = 0, /*cc = 0,*/ c = "", o = ""; while (i < fmt.length) { switch ((c = fmt.charAt(i))) { case 'G': if (isgeneral(fmt, i)) i += 6; i++; break; case '"': for (; (/*cc=*/fmt.charCodeAt(++i)) !== 34 && i < fmt.length;) ++i; ++i; break; case '\\': i += 2; break; case '_': i += 2; break; case '@': ++i; break; case 'B': case 'b': if (fmt.charAt(i + 1) === "1" || fmt.charAt(i + 1) === "2") return true; // falls through case 'M': case 'D': case 'Y': case 'H': case 'S': case 'E': // falls through case 'm': case 'd': case 'y': case 'h': case 's': case 'e': case 'g': return true; case 'A': case 'a': if (fmt.substr(i, 3).toUpperCase() === "A/P") return true; if (fmt.substr(i, 5).toUpperCase() === "AM/PM") return true; ++i; break; case '[': o = c; while (fmt.charAt(i++) !== ']' && i < fmt.length) o += fmt.charAt(i); if (o.match(abstime)) return true; break; case '.': // falls through case '0': case '#': while (i < fmt.length && ("0#?.,E+-%".indexOf(c = fmt.charAt(++i)) > -1 || (c == '\\' && fmt.charAt(i + 1) == "-" && "0#".indexOf(fmt.charAt(i + 2)) > -1))) {/* empty */ } break; case '?': while (fmt.charAt(++i) === c) {/* empty */ } break; case '*': ++i; if (fmt.charAt(i) === ' ' || fmt.charAt(i) === '*') ++i; break; case '(': case ')': ++i; break; case '1': case '2': case '3': case '4': case '5': case '6': case '7': case '8': case '9': while (i < fmt.length && "0123456789".indexOf(fmt.charAt(++i)) > -1) {/* empty */ } break; case ' ': ++i; break; default: ++i; break; } } return false; } SSF.is_date = fmt_is_date; /** * Format evaluation * Format evaluation */ function eval_fmt(fmt: string, v: FormatValue, opts?: SSFOptions, flen?: number): string { let out: FormatToken[] = [], o = "", i = 0, c = "", lst = 't', dt: DateCode | null = null, j: number, cc: number; let hr = 'H'; /* Tokenize */ while (i < fmt.length) { switch ((c = fmt.charAt(i))) { case 'G': /* General */ if (!isgeneral(fmt, i)) throw new Error('unrecognized character ' + c + ' in ' + fmt); out[out.length] = {t: 'G', v: 'General'}; i += 7; break; case '"': /* Literal text */ for (o = ""; (cc = fmt.charCodeAt(++i)) !== 34 && i < fmt.length;) o += String.fromCharCode(cc); out[out.length] = {t: 't', v: o}; ++i; break; case '\\': const w = fmt.charAt(++i), t = (w === "(" || w === ")") ? w : 't'; out[out.length] = {t: t, v: w}; ++i; break; case '_': out[out.length] = {t: 't', v: " "}; i += 2; break; case '@': /* Text Placeholder */ out[out.length] = {t: 'T', v: v as string}; ++i; break; case 'B': case 'b': if (fmt.charAt(i + 1) === "1" || fmt.charAt(i + 1) === "2") { if (dt == null) { dt = parse_date_code(v as number, opts, fmt.charAt(i + 1) === "2"); if (dt == null) return ""; } out[out.length] = {t: 'X', v: fmt.substr(i, 2)}; lst = c; i += 2; break; } // falls through case 'M': case 'D': case 'Y': case 'H': case 'S': case 'E': c = c.toLowerCase(); // falls through case 'm': case 'd': case 'y': case 'h': case 's': case 'e': case 'g': if ((v as number) < 0) return ""; if (dt == null) { dt = parse_date_code(v as number, opts); if (dt == null) return ""; } o = c; while (++i < fmt.length && fmt.charAt(i).toLowerCase() === c) o += c; if (c === 'm' && lst.toLowerCase() === 'h') c = 'M'; if (c === 'h') c = hr; out[out.length] = {t: c, v: o}; lst = c; break; case 'A': case 'a': const q: FormatToken = {t: c, v: c}; if (dt == null) dt = parse_date_code(v as number, opts); if (fmt.substr(i, 3).toUpperCase() === "A/P") { if (dt != null) q.v = dt.H >= 12 ? "P" : "A"; q.t = 'T'; hr = 'h'; i += 3; } else if (fmt.substr(i, 5).toUpperCase() === "AM/PM") { if (dt != null) q.v = dt.H >= 12 ? "PM" : "AM"; q.t = 'T'; i += 5; hr = 'h'; } else { q.t = "t"; ++i; } if (dt == null && q.t === 'T') return ""; out[out.length] = q; lst = c; break; case '[': o = c; while (fmt.charAt(i++) !== ']' && i < fmt.length) o += fmt.charAt(i); if (o.slice(-1) !== ']') throw 'unterminated "[" block: |' + o + '|'; if (o.match(abstime)) { if (dt == null) { dt = parse_date_code(v as number, opts); if (dt == null) return ""; } out[out.length] = {t: 'Z', v: o.toLowerCase()}; lst = o.charAt(1); } else if (o.indexOf("$") > -1) { o = (o.match(/\$([^-\[\]]*)/) || [])[1] || "$"; if (!fmt_is_date(fmt)) out[out.length] = {t: 't', v: o}; } break; /* Numbers */ case '.': if (dt != null) { o = c; while (++i < fmt.length && (c = fmt.charAt(i)) === "0") o += c; out[out.length] = {t: 's', v: o}; break; } // falls through case '0': case '#': o = c; while ((++i < fmt.length && "0#?.,E+-%".indexOf(c = fmt.charAt(i)) > -1) || (c == '\\' && fmt.charAt(i + 1) == "-" && i < fmt.length - 2 && "0#".indexOf(fmt.charAt(i + 2)) > -1)) o += c; out[out.length] = {t: 'n', v: o}; break; case '?': o = c; while (fmt.charAt(++i) === c) o += c; out[out.length] = {t: c, v: o}; lst = c; break; case '*': ++i; if (fmt.charAt(i) === ' ' || fmt.charAt(i) === '*') ++i; break; // ** case '(': case ')': out[out.length] = {t: (flen === 1 || (typeof v === 'number' && v < 0) ? 't' : c), v: c}; ++i; break; case '1': case '2': case '3': case '4': case '5': case '6': case '7': case '8': case '9': o = c; while (i < fmt.length && "0123456789".indexOf(fmt.charAt(++i)) > -1) o += fmt.charAt(i); out[out.length] = {t: 'D', v: o}; break; case ' ': out[out.length] = {t: c, v: c}; ++i; break; default: if (",$-+/():!^&'~{}<>=€acfijklopqrtuvwxzP".indexOf(c) === -1) throw new Error('unrecognized character ' + c + ' in ' + fmt); out[out.length] = {t: 't', v: c}; ++i; break; } } let bt = 0, ss0 = 0, ssm: RegExpMatchArray | null; for (i = out.length - 1, lst = 't'; i >= 0; --i) { switch (out[i].t) { case 'h': case 'H': out[i].t = hr; lst = 'h'; if (bt < 1) bt = 1; break; case 's': if ((ssm = out[i].v.match(/\.0+$/))) ss0 = Math.max(ss0, ssm[0].length - 1); if (bt < 3) bt = 3; // falls through case 'd': case 'y': case 'M': case 'e': lst = out[i].t; break; case 'm': if (lst === 's') { out[i].t = 'M'; if (bt < 2) bt = 2; } break; case 'X': /*if(out[i].v === "B2");*/ break; case 'Z': if (bt < 1 && out[i].v.match(/[Hh]/)) bt = 1; if (bt < 2 && out[i].v.match(/[Mm]/)) bt = 2; if (bt < 3 && out[i].v.match(/[Ss]/)) bt = 3; } } switch (bt) { case 0: break; case 1: if (dt!.u >= 0.5) { dt!.u = 0; ++dt!.S; } if (dt!.S >= 60) { dt!.S = 0; ++dt!.M; } if (dt!.M >= 60) { dt!.M = 0; ++dt!.H; } break; case 2: if (dt!.u >= 0.5) { dt!.u = 0; ++dt!.S; } if (dt!.S >= 60) { dt!.S = 0; ++dt!.M; } break; } /* replace fields */ let nstr = "", jj: number; for (i = 0; i < out.length; ++i) { switch (out[i].t) { case 't': case 'T': case ' ': case 'D': break; case 'X': out[i].v = ""; out[i].t = ";"; break; case 'd': case 'm': case 'y': case 'h': case 'H': case 'M': case 's': case 'e': case 'b': case 'Z': out[i].v = write_date(out[i].t.charCodeAt(0), out[i].v, dt!, ss0); out[i].t = 't'; break; case 'n': case '(': case '?': jj = i + 1; while (out[jj] != null && ( (c = out[jj].t) === "?" || c === "D" || ((c === " " || c === "t") && out[jj + 1] != null && (out[jj + 1].t === '?' || out[jj + 1].t === "t" && out[jj + 1].v === '/')) || (out[i].t === '(' && (c === ' ' || c === 'n' || c === ')')) || (c === 't' && (out[jj].v === '/' || out[jj].v === ' ' && out[jj + 1] != null && out[jj + 1].t === '?')) )) { out[i].v += out[jj].v; out[jj] = {v: "", t: ";"}; ++jj; } nstr += out[i].v; i = jj - 1; break; case 'G': out[i].t = 't'; out[i].v = general_fmt(v, opts); break; } } let vv = "", myv: number, ostr: string; if (nstr.length > 0) { if (nstr.charCodeAt(0) === 40) /* '(' */ { myv = ((v as number) < 0 && nstr.charCodeAt(0) === 45 ? -(v as number) : (v as number)); ostr = write_num('(', nstr, myv); } else { myv = ((v as number) < 0 && flen! > 1 ? -(v as number) : (v as number)); ostr = write_num('n', nstr, myv); if (myv < 0 && out[0] && out[0].t === 't') { ostr = ostr.substr(1); out[0].v = "-" + out[0].v; } } jj = ostr.length - 1; let decpt = out.length; for (i = 0; i < out.length; ++i) if (out[i] != null && out[i].t !== 't' && out[i].v.indexOf(".") > -1) { decpt = i; break; } let lasti = out.length; if (decpt === out.length && ostr.indexOf("E") === -1) { for (i = out.length - 1; i >= 0; --i) { if (out[i] == null || 'n?('.indexOf(out[i].t) === -1) continue; if (jj >= out[i].v.length - 1) { jj -= out[i].v.length; out[i].v = ostr.substr(jj + 1, out[i].v.length); } else if (jj < 0) out[i].v = ""; else { out[i].v = ostr.substr(0, jj + 1); jj = -1; } out[i].t = 't'; lasti = i; } if (jj >= 0 && lasti < out.length) out[lasti].v = ostr.substr(0, jj + 1) + out[lasti].v; } else if (decpt !== out.length && ostr.indexOf("E") === -1) { jj = ostr.indexOf(".") - 1; for (i = decpt; i >= 0; --i) { if (out[i] == null || 'n?('.indexOf(out[i].t) === -1) continue; j = out[i].v.indexOf(".") > -1 && i === decpt ? out[i].v.indexOf(".") - 1 : out[i].v.length - 1; vv = out[i].v.substr(j + 1); for (; j >= 0; --j) { if (jj >= 0 && (out[i].v.charAt(j) === "0" || out[i].v.charAt(j) === "#")) vv = ostr.charAt(jj--) + vv; } out[i].v = vv; out[i].t = 't'; lasti = i; } if (jj >= 0 && lasti < out.length) out[lasti].v = ostr.substr(0, jj + 1) + out[lasti].v; jj = ostr.indexOf(".") + 1; for (i = decpt; i < out.length; ++i) { if (out[i] == null || ('n?('.indexOf(out[i].t) === -1 && i !== decpt)) continue; j = out[i].v.indexOf(".") > -1 && i === decpt ? out[i].v.indexOf(".") + 1 : 0; vv = out[i].v.substr(0, j); for (; j < out[i].v.length; ++j) { if (jj < ostr.length) vv += ostr.charAt(jj++); } out[i].v = vv; out[i].t = 't'; lasti = i; } } } for (i = 0; i < out.length; ++i) if (out[i] != null && 'n(?'.indexOf(out[i].t) > -1) { myv = (flen! > 1 && (v as number) < 0 && i > 0 && out[i - 1].v === "-" ? -(v as number) : (v as number)); out[i].v = write_num(out[i].t, out[i].v, myv); out[i].t = 't'; } let retval = ""; for (i = 0; i !== out.length; ++i) if (out[i] != null) retval += out[i].v; return retval; } SSF._eval = eval_fmt; const cfregex = /\[[=<>]/; const cfregex2 = /\[([=<>]*)(-?\d+\.?\d*)\]/; /** * Check condition * Check condition */ function chkcond(v: number, rr: RegExpMatchArray | null): boolean { if (rr == null) return false; const thresh = parseFloat(rr[2]); switch (rr[1]) { case "=": if (v === thresh) return true; break; case ">": if (v > thresh) return true; break; case "<": if (v < thresh) return true; break; case "<>": if (v !== thresh) return true; break; case ">=": if (v >= thresh) return true; break; case "<=": if (v <= thresh) return true; break; } return false; } /** * Select format * Choose format */ function choose_fmt(f: string, v: FormatValue): [number, string] { let fmt = split_fmt(f); let l = fmt.length, lat = fmt[l - 1].indexOf("@"); if (l < 4 && lat > -1) --l; if (fmt.length > 4) throw new Error("cannot find right format for |" + fmt.join("|") + "|"); if (typeof v !== "number") return [4, fmt.length === 4 || lat > -1 ? fmt[fmt.length - 1] : "@"]; switch (fmt.length) { case 1: fmt = lat > -1 ? ["General", "General", "General", fmt[0]] : [fmt[0], fmt[0], fmt[0], "@"]; break; case 2: fmt = lat > -1 ? [fmt[0], fmt[0], fmt[0], fmt[1]] : [fmt[0], fmt[1], fmt[0], "@"]; break; case 3: fmt = lat > -1 ? [fmt[0], fmt[1], fmt[0], fmt[2]] : [fmt[0], fmt[1], fmt[2], "@"]; break; case 4: break; } const ff = v > 0 ? fmt[0] : v < 0 ? fmt[1] : fmt[2]; if (fmt[0].indexOf("[") === -1 && fmt[1].indexOf("[") === -1) return [l, ff]; if (fmt[0].match(cfregex) != null || fmt[1].match(cfregex) != null) { const m1 = fmt[0].match(cfregex2); const m2 = fmt[1].match(cfregex2); return chkcond(v, m1) ? [l, fmt[0]] : chkcond(v, m2) ? [l, fmt[1]] : [l, fmt[m1 != null && m2 != null ? 2 : 1]]; } return [l, ff]; } /** * Format function * Format function */ function format(fmt: string | number, v: FormatValue, o?: SSFOptions): string { if (o == null) o = {}; let sfmt = ""; switch (typeof fmt) { case "string": if (fmt === "m/d/yy" && o.dateNF) sfmt = o.dateNF; else sfmt = fmt; break; case "number": if (fmt === 14 && o.dateNF) sfmt = o.dateNF; else sfmt = (o.table != null ? (o.table) : table_fmt)[fmt]; break; } if (isgeneral(sfmt, 0)) return general_fmt(v, o); if (v instanceof Date) v = datenum_local(v, o.date1904); const f = choose_fmt(sfmt, v); if (isgeneral(f[1])) return general_fmt(v, o); if (v === true) v = "TRUE"; else if (v === false) v = "FALSE"; else if (v === "" || v == null) return ""; return eval_fmt(f[1], v, o, f[0]); } /** * Load format entry * Load format entry */ function load_entry(fmt: string, idx?: number | string): number { if (typeof idx !== 'number') { idx = +idx! || -1; for (let i = 0; i < 0x0188; ++i) { if (table_fmt[i] === undefined) { if (idx < 0) idx = i; continue; } if (table_fmt[i] === fmt) { idx = i; break; } } if (idx < 0) idx = 0x187; } table_fmt[idx] = fmt; return idx; } /** * Load format string * Load format string */ SSF.load = load_entry; /** * Underlying object that maps numeric keys to format strings * The underlying object, mapping numeric keys to format strings */ SSF._table = table_fmt; /** * Get internal format table (number to format mapping) * Gets the internal format table (number to format mapping) */ SSF.get_table = function get_table(): { [key: number]: string } { return table_fmt; }; /** * Load format table * Load format table */ SSF.load_table = function load_table(tbl: { [key: number]: string }): void { for (let i = 0; i !== 0x0188; ++i) if (tbl[i] !== undefined) load_entry(tbl[i], i); }; /** * Initialize format table * Initialize format table */ SSF.init_table = init_table; /** * Render value using format string or code * Render value using format string or code * * If fmt is a string, it will be parsed and evaluated. If fmt is a number, the actual format will be the corresponding entry in the internal format table. * For raw number formats like 000, the value should be passed as a string. * * Date arguments are interpreted in local time of the JS client. * * If fmt is a string, it will be parsed and evaluated. If fmt is a number, the actual format will be the * corresponding entry in the internal format table. For a raw numeric format like 000, the value should be * passed as a string. * * Date arguments are interpreted in the local time of the JS client. */ SSF.format = format; export default SSF;