forked from natergj/excel4node
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathchangelog.txt
310 lines (241 loc) · 16 KB
/
changelog.txt
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
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
1.6.0
Bug Fixes:
merges https://github.com/natergj/excel4node/pull/232 to fix issue where emoji were not being added to worksheets
Enhancements:
addresses https://github.com/natergj/excel4node/issues/194 by adding ability to set Print Area for worksheets
addresses https://github.com/natergj/excel4node/issues/233 by adding ability to set Page Breaks for worksheets
1.5.1
Bug Fixes:
resolves https://github.com/natergj/excel4node/issues/218 where library crashed when null or undefined value was sent to cell string method
resolves https://github.com/natergj/excel4node/issues/226 where default font would not be applied to dates when opening workbook in LibreOffice
merges https://github.com/natergj/excel4node/pull/225 which removes error when attempting to bundle application with excel4node as dependency
Enhancements:
merges https://github.com/natergj/excel4node/pull/230 which reduces library size by only installed specific lodash functions
1.5.0
Bug Fixes:
resolves https://github.com/natergj/excel4node/issues/156 where an error will be thrown if no Worksheet is specified prior to attempting to write a Workbook
Enhancements:
merge https://github.com/natergj/excel4node/pull/211 & https://github.com/natergj/excel4node/pull/212
remove default logger dependency in favor of much smaller simple logger (reduces library dependencies and size)
add ability specify custom logger
1.4.0
Bug Fixes:
resolves https://github.com/natergj/excel4node/issues/196 where unicode filenames could not be used with HTTP Response write handler
Enhancements:
merge https://github.com/natergj/excel4node/pull/201 to add ability to hide worksheets
1.3.6
Bug Fixes:
resolves https://github.com/natergj/excel4node/issues/182 to allow column widths to be set as floats
resolves https://github.com/natergj/excel4node/issues/184 to properly handle setting row autofilter with no arguments
merge https://github.com/natergj/excel4node/pull/181 to fix typo in documentation
1.3.5
Bug Fixes:
merge https://github.com/natergj/excel4node/pull/141 to properly handle unicode and emoji
merge https://github.com/natergj/excel4node/pull/172 to correct issue with row spans causing errors when opening workbooks with a large number of lines
1.3.4
Bug fixes:
resolved issue where if multiple conditional formatting rules were specified for a single sheet, only the first rule would apply
resolves https://github.com/natergj/excel4node/issues/164 to resolve issue adding multiple dataValidations that did not include a formula to a single worksheet
Enhancements:
merge https://github.com/natergj/excel4node/pull/165 to improve performance with shared strings
1.3.2
Bug fixes:
resolves https://github.com/natergj/excel4node/issues/152 after 1.3.0 re-introduced issue #84
1.3.1
Bug fixes:
resolves https://github.com/natergj/excel4node/issues/148 for uncatchable thrown errors
resolves https://github.com/natergj/excel4node/issues/106 for incorrectly generated links
resolves https://github.com/natergj/excel4node/issues/147 for missing fills in conditional formatting
1.3.0
Enhancements:
merge https://github.com/natergj/excel4node/pull/117 to add option to hide view lines
merge https://github.com/natergj/excel4node/pull/109 to add code coverage checking
merge https://github.com/natergj/excel4node/pull/138 to allow for image from buffer support
commit 1c4a7bf990160b47ad8e0f49c00a536dca7ab672 add options for workbook view
commit ff629a225335dc784933c06aabd20ddca5fcdbef fix issue where ony first data validation per sheet would take effect
Bug fixes:
merge https://github.com/natergj/excel4node/pull/99 to fix issue when adding 2nd image of same extension
merge https://github.com/natergj/excel4node/pull/115 to fix deprecated lodash function warning
merge https://github.com/natergj/excel4node/pull/125 to fix link in README
merge https://github.com/natergj/excel4node/pull/119 to remove babel-register runtime dependency
merge https://github.com/natergj/excel4node/pull/132 to fix issue with summaryBelow and summaryRight
commit 78180e6a0a1f0a50e43b588902da37fdee5be7bb use latest version of mime module
commit b96f01a2923e2823377f10c28a97a3fe2c5c5f50 update dependencies
commit b3fcb8aa6674c644838f81a9170f2b6d975803b6 fixes date translations to match published spec
commit 1c4a7bf990160b47ad8e0f49c00a536dca7ab672 fix issue where workbook would always open as smallest possible window size
1.2.1
Fix Workbook#createStyle creating duplicates and slow performance [#100]
1.2.0
merged https://github.com/natergj/excel4node/pull/91 from miguelmota to expose writeToBuffer method allowing excel zip buffer to be piped to other streams
added documentation to README
fixed some errors in README
1.1.2
dependency cleanup
updated to version 3.x.x of jszip
1.1.1
Improved effeciency when writing Workbooks to help address Issue #83. Tested with 50 columns and 30,000 rows.
1.1.0
Fixed issue where defaultRowHeight set in Workbook opts was not being properly handled.
1.0.9
Fixed issue #90 which would result in a type error being thrown if a dataValidation errorTitle was set and errorStyle was not
1.0.8
Removed debug line that had been missed prior to publish
1.0.7
Fixed issue #89 which would result in dates showing a 1 hour offset if date was in daylight savings time
1.0.6
Fixed issue #87 which would result in non-logical behaviour of showDropDown="true" for dataValidations
Fixed issue #88 which would result in fonts set as default for workbook not having all of their attributes respected for cells that had a style assigned to them that only included a subset of the font attributes.
1.0.5
Fixed issue #84 which would result in Office 2013 on Windows crashing when attempting to print a workbook.
1.0.4
Fixed issue #82 which would result in call stack size being exceeded when workbook was being written
1.0.3
Fixed issue where border.outline property was not applying border only to cells on out the outside of the cell block
Fixed issue where an excessive number of style xfs may have been added to styles.xml file
1.0.2
Fixed some inaccuracies in the README.md file
1.0.1
Removed a missed remnant of old code that wasn't removed during the merge
Excluded development tests folder from npm published code
1.0.0
Complete rewrite of library in ES2015
This is a breaking change for API. Library is much more javascripty
0.5.1
Merged pull request 76 from https://github.com/bhuvanaurora to fix issue that would arise if you tried to add an emoji to an excel document
0.5.0
Merged pull request 74 from https://github.com/pindinz to add support for specifying specific paper size
0.4.1
Fixed issue causing problems when trying to bundle
0.4.0
Merged pull requests 67, 59, 60, 64, 66, 67 from https://github.com/dgofman
Added ability to create cells with complex multiple formatting within a single cell
Added ability to include headers and footers in worksheets
Added ability to repeat specific rows or columns on every printed page (https://support.office.com/en-us/article/Repeat-specific-rows-or-columns-on-every-printed-page-0d6dac43-7ee7-4f34-8b08-ffcc8b022409)
removed allowInterrupt options. It was causing issues
Added ability to set a default font across workbook
Fixed issues with images
Fixed issue with print orientation and scaling
0.3.1
Merged https://github.com/natergj/excel4node/pull/53 from https://github.com/bugeats.
More tests added
Added support for limited number of conditional formatting rules
0.3.0
Merged https://github.com/natergj/excel4node/pull/52 from https://github.com/bugeats. Code cleanup refactor, added .eslintrc.js file and tests.
0.2.23
Merged https://github.com/natergj/excel4node/pull/50 from https://github.com/dmnorc to fix bug with setting size of font through Cell.Format methods.
0.2.22
Added the ability to reference Cells in another sheet in validations
Merged pull request https://github.com/natergj/excel4node/pull/48 from https://github.com/dteunkenstt to add ability to set Cells with Boolean values
0.2.21
Fixed issue where files with spaces in their names were not correctly downloading in Firefox.
0.2.20
Added the ability to add "Protection" to Workbooks and Worksheets
Fixed issue where Row.Filter() would not filter the correct row if workbook opened in LibreOffice or uploaded to GoogleSheets
Added the .Border() function to individual cell ranges rather than requiring borders to be defined within a Style
Added opts.allowInterrupt which will use an asynchronous forEach function in order not to block other operations if reports are being generated on the same thread as other operations.
0.2.19
Fixed issue that would cause Excel to crash when filtered columns were sorted
0.2.18
Fixed issue where page would not scroll vertically if row was frozen
Fixed issue where internal Row.cellCount() function would not return the correct number of cells if there were more than 9
Fixed issue where invalid workbooks would be generated on write if write was called multiple times on the same workbook.
0.2.17
Set string function to remove characters not compatible with XMLStringifier.
merged pull request https://github.com/natergj/excel4node/pull/38 from https://github.com/nirarazi to add support for Right to Left languages
0.2.16
merged pull request https://github.com/natergj/excel4node/pull/37 from https://github.com/pomeo to add ability to insert hyperlinks into cells
0.2.15
fixed issue where Column functions were not returning Column objects and could not be chained
fixed date issues with Cell Date function when invalid date was sent.
fixed issue where merged cells would apply values to all cells in range rather than just top left cell. This would cause issues when summing rows and columns with merged cells.
fixed issue where multiple images could not be added to a workbook
0.2.14
Added ability to Group columns
Merged pull request (https://github.com/natergj/excel4node/pull/34) from https://github.com/kylepixel which greatly optimizes conversion of numeric to and from alpha representations of columns
0.2.13
Fixed issue where default style would inherit style alignement if it was delared prior to any other font declaration
0.2.12
Added ability to Hide a Row or Column
0.2.11
Merged pull request (https://github.com/natergj/excel4node/pull/32) from https://github.com/stefanhenze to add ability to set the fit to page on print
Added the abilty to rotate text in cell
fixed validation issue that would cause an error if a cell were written to as a formula after already being written to as a number or string
0.2.10
Merged pull request (https://github.com/natergj/excel4node/pull/29) from https://github.com/atsapenko to fix issue when chaining style for date cell.
0.2.9
Merged pull request (https://github.com/natergj/excel4node/pull/29) from https://github.com/atsapenko to add ability to set dropdown validation
0.2.8
Merged pull request (https://github.com/natergj/excel4node/pull/27) from https://github.com/pookong to fix issue that would cause a numberformat to not apply to a cell
0.2.7
fixed issue that would prevent cells to be written to columns over 702 (26^2 + 26) column AAA or higher
Merged pull request (https://github.com/natergj/excel4node/pull/26) from https://github.com/RafaPolit to fixe continuing issue with merging cells
0.2.6
fixed to merge issues after the 52nd column
0.2.5
fixed the 2nd sort function needed for proper cell merging in all cases.
0.2.4
fixed issue with cells not merging if one of the cells is after the 26th column.
fixed xml validation issue if not style has been specified on the workbook.
0.2.3
fixed issue where groupings would cause an XML validation error when summaryBelow was set to true
greatly reduced memory usage when added data to worksheets
deprecated Workbook.Settings.outlineSummaryBelow() call. This will be removed in version 1 and a console log entry created when used.
0.2.2
fixed issue where incorrect string was displayed if cell had changed from a string to a number
0.2.1
fixed issue that would cause failure if no cells had been added to a worksheet prior to write function called
0.2.0
Near complete refactor. adds efficiency and speed and much more readable code.
Added ability to create workbook with options. jszip options are first. more to come. Issue #20
Added ability to create workshets with options. margins, zoom and centering on print first. more to come. Issue #19
Added ability to add a Date to worksheet and set type as Date
Fixed issue #22 where empty string would print 'undefined' in cell
Fixed issue #21 where foreign characters would cause issue.
0.1.7
Merged pull request (https://github.com/natergj/excel4node/pull/18) from https://github.com/daviesjamie
Added Asynchronous abilty to write function
0.1.6
added ability to set a row to be a Filter row
finished Grouping feature
0.1.5
fixed issue where some Excel features (sorting, grouping, etc) where not available on first sheet of workbook if more than one worksheet existed
continuing work on experimental Grouping features
0.1.4
fixed issue where sheet would not scroll properly if Freezing both a row and a column
allowed for usage of color definitions in multiple formats
0.1.3
added ability to Freeze Rows
0.1.2
fixed issue with Font Alignment when applied directly to a cell
module will no longer crash when String is passed an undefined value
fixed sample to properly identify if it is running from within the module or not
fixed issue where border would not always be applied to the correct cell range.
0.1.1
added ability to merge cells
added ability to apply styles to range of cells
added ability to apply formatting to cells and cell ranges without first creating a style
fixed issue that would cause error when applying a row height if row had populated cells
0.0.10
merged pull request https://github.com/natergj/excel4node/pull/11
0.0.9
fixed issue where if a Worksheet was added, but then no cells added, execution would stop
fixed issue where workbooks would cause MS Excel for Windows to crash on print preview
fixed issue where if undefined or 0 value was passed to cell or row function, execution would stop
added changelog
0.0.8
fixed issue where when adding a cell in a row not in sequence would cause corrupted excel data.
0.0.7
added ability to add borders to cells
0.0.6
added ability to include images in workbooks
0.0.5
added ability to Freeze columns from horizontal scrolling
fixed bug where if a Cell had been previously set to a String and is changed to a Number, the cell would reference the shared string key of the number rather than displaying the number.
0.0.4
added ability to set text alignment of cells
added ability to set text wrapping in cells
fixed issue where fill were not being applied in certain circumstances
0.0.3
fixed bug where excel data was corrupted if write function was called twice.
0.0.1
initial push