1 | # CHANGELOG
|
2 |
|
3 | This log is intended to keep track of backwards-incompatible changes, including
|
4 | but not limited to API changes and file location changes. Minor behavioral
|
5 | changes may not be included if they are not expected to break existing code.
|
6 |
|
7 | ## v0.16.2
|
8 |
|
9 | * Disabled `PRN` parsing by default (better support for CSV without delimeters)
|
10 |
|
11 | ## v0.16.1
|
12 |
|
13 | * skip empty custom property tags if data is absent (fixes DocSecurity issue)
|
14 | * HTML output add raw value, type, number format
|
15 | * DOM parse look for `v` / `t` / `z` attributes when determining value
|
16 | * double quotes in properties escaped using `_x0022_`
|
17 | * changed AMD structure for NetSuite and other RequireJS implementations
|
18 | - `encode_cell` and `decode_cell` do not rely on `encode_col` / `decode_col`
|
19 |
|
20 | ## v0.16.0
|
21 |
|
22 | * Date handling changed
|
23 | * XLML certain tag tests are now case insensitive
|
24 | * Fixed potentially vulnerable regular expressions
|
25 |
|
26 | ## v0.15.6
|
27 |
|
28 | * CFB prevent infinite loop
|
29 | * ODS empty cells marked as stub (type "z")
|
30 | * `cellStyles` option implies `sheetStubs`
|
31 |
|
32 | ## v0.15.5
|
33 |
|
34 | * `sheets` parse option to specify which sheets to parse
|
35 |
|
36 | ## v0.15.4
|
37 |
|
38 | * AOA utilities properly preserve number formats
|
39 | * Number formats captured in stub cells
|
40 |
|
41 | ## v0.15.3
|
42 |
|
43 | * Properties and Custom Properties properly XML-encoded
|
44 |
|
45 | ## v0.15.2
|
46 |
|
47 | - `sheet_get_cell` utility function
|
48 | - `sheet_to_json` explicitly support `null` as alias for default behavior
|
49 | - `encode_col` throw on negative column index
|
50 | - HTML properly handle whitespace around tags in a run
|
51 | - HTML use `id` option on write
|
52 | - Files starting with `0x09` followed by a display character are now TSV files
|
53 | - XLS parse references col/row indices mod by the correct number for BIFF ver
|
54 | - XLSX comments moved to avoid overlapping cell
|
55 | - XLSB outline level
|
56 | - AutoFilter update `_FilterDatabase` defined name on write
|
57 | - XLML skip CDATA blocks
|
58 |
|
59 | ## v0.15.1 (2019-08-14)
|
60 |
|
61 | * XLSX ignore XML artifacts
|
62 | * HTML capture and persist merges
|
63 |
|
64 | ## v0.15.0
|
65 |
|
66 | * `dist/xlsx.mini.min.js` mini build with XLSX read/write and some utilities
|
67 | * Removed legacy conversion utility functions
|
68 |
|
69 | ## v0.14.5
|
70 |
|
71 | * XLS PtgNameX lookup
|
72 | * XLS always create stub cells for blank cells with comments
|
73 |
|
74 |
|
75 | ## v0.14.4
|
76 |
|
77 | * Better treatment of `skipHidden` in CSV output
|
78 | * Ignore CLSID in XLS
|
79 | * SYLK 7-bit character encoding
|
80 | * SYLK and DBF codepage support
|
81 |
|
82 | ## v0.14.3
|
83 |
|
84 | * Proper shifting of addresses in Shared Formulae
|
85 |
|
86 | ## v0.14.2
|
87 |
|
88 | * Proper XML encoding of comments
|
89 |
|
90 | ## v0.14.1
|
91 |
|
92 | * raw cell objects can be passed to `sheet_add_aoa`
|
93 | * `_FilterDatabase` fix for AutoFilter-related crashes
|
94 | * `stream.to_json` doesn't end up accidentally scanning to max row
|
95 |
|
96 | ## 0.14.0 (2018-09-06)
|
97 |
|
98 | * `sheet_to_json` default flipped to `raw: true`
|
99 |
|
100 | ## 0.13.5 (2018-08-25)
|
101 |
|
102 | * HTML output generates `<br/>` instead of encoded newline character
|
103 |
|
104 | ## 0.13.2 (2018-07-08)
|
105 |
|
106 | * Buffer.from shim replaced, will not be defined in node `<=0.12`
|
107 |
|
108 | ## 0.13.0 (2018-06-01)
|
109 |
|
110 | * Library reshaped to support AMD out of the box
|
111 |
|
112 | ## 0.12.11 (2018-04-27)
|
113 |
|
114 | * XLS/XLSX/XLSB range truncation (errors in `WTF` mode)
|
115 |
|
116 | ## 0.12.4 (2018-03-04)
|
117 |
|
118 | * `JSZip` renamed to `JSZipSync`
|
119 |
|
120 | ## 0.12.0 (2018-02-08)
|
121 |
|
122 | * Extendscript target script in NPM package
|
123 |
|
124 | ## 0.11.19 (2018-02-03)
|
125 |
|
126 | * Error on empty workbook
|
127 |
|
128 | ## 0.11.16 (2017-12-30)
|
129 |
|
130 | * XLS ANSI/CP separation
|
131 | * 'array' write type and ArrayBuffer processing
|
132 |
|
133 | ## 0.11.6 (2017-10-16)
|
134 |
|
135 | * Semicolon-delimited files are detected
|
136 |
|
137 | ## 0.11.5 (2017-09-30)
|
138 |
|
139 | * Bower main script shifted to full version
|
140 | * 'binary' / 'string' encoding
|
141 |
|
142 | ## 0.11.3 (2017-08-19)
|
143 |
|
144 | * XLS cell ixfe/XF removed
|
145 |
|
146 | ## 0.11.0 (2017-07-31)
|
147 |
|
148 | * Strip `require` statements from minified version
|
149 | * minifier mangler enabled
|
150 |
|
151 | ## 0.10.9 (2017-07-28)
|
152 |
|
153 | * XLML/HTML resolution logic looks further into the data stream to decide type
|
154 | * Errors thrown on suspected RTF files
|
155 |
|
156 | ## 0.10.5 (2017-06-09)
|
157 |
|
158 | * HTML Table output header/footer should not include `<table>` tag
|
159 |
|
160 | ## 0.10.2 (2017-05-16)
|
161 |
|
162 | * Dates are converted to numbers by default (set `cellDates:true` to emit Dates)
|
163 | * Module does not export CFB
|
164 |
|
165 | ## 0.9.10 (2017-04-08)
|
166 |
|
167 | * `--perf` renamed to `--read-only`
|
168 |
|
169 | ## 0.9.9 (2017-04-03)
|
170 |
|
171 | * default output format changed to XLSB
|
172 | * comment text line endings are now normalized
|
173 | * errors thrown on write when worksheets have invalid names
|
174 |
|
175 | ## 0.9.7 (2017-03-28)
|
176 |
|
177 | * XLS legacy `!range` field removed
|
178 | * Hyperlink tooltip is stored in the `Tooltip` field
|
179 |
|
180 | ## 0.9.6 (2017-03-25)
|
181 |
|
182 | * `sheet_to_json` now passes `null` values when `raw` is set to `true`
|
183 | * `sheet_to_json` treats `null` stub cells as values in conjunction with `raw`
|
184 |
|
185 | ## 0.9.5 (2017-03-22)
|
186 |
|
187 | * `cellDates` affects parsing in non-XLSX formats
|
188 |
|
189 | ## 0.9.3 (2017-03-15)
|
190 |
|
191 | * XLML property names are more closely mapped to the XLSX equivalent
|
192 | * Stub cells are now cell type `z`
|
193 |
|
194 | ## 0.9.2 (2017-03-13)
|
195 |
|
196 | * Removed stale TypeScript definition files. Flowtype comments are used in the
|
197 | `xlsx.flow.js` source and stripped to produce `xlsx.js`.
|
198 | * sed usage reworked to support GNU sed in-place form. BSD sed seems to work,
|
199 | but the build script has not been tested on other sed variants:
|
200 |
|
201 | ```bash
|
202 | $ sed -i.ext [...] # GNU
|
203 | $ sed -i .ext [...] # bsd
|
204 | ```
|
205 |
|
206 | ## 0.9.0 (2017-03-09)
|
207 |
|
208 | * Removed ods.js source. The xlsx.js source absorbed the ODS logic and exposes
|
209 | the ODS variable, so projects should remove references to ods.js
|
210 |
|