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