forked from natergj/excel4node
-
Notifications
You must be signed in to change notification settings - Fork 0
/
changelog.txt
232 lines (176 loc) · 11.2 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
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