forked from awalker89/openxlsx
-
Notifications
You must be signed in to change notification settings - Fork 0
/
NEWS
297 lines (150 loc) · 8.11 KB
/
NEWS
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
openxlsx 4.0.1
----------------------------------------------------------------
NEW FEATURES
* getNamedRegions returns sheet name and cell references along with the named regions.
* borderStyle and borderColour can be vector to specify differnet values for each side
* dataValidation type "list"
* dataBar showValue, gradient and border can now be set through conditionalFormatting().
BUG FIXES
* skipEmptyRows & skipEmptyCols was being ignored by read.xlsx
* date detection basic_string error
* multiple spaces in table column names were not being maintained thus corrupting the xlsx file.
* openXL fail silently on relative paths.
* headerStyle failed when writing a list of length 1 using write.xlsx
* detectDate for read.xlsx issues.
openxlsx 4.0.0
----------------------------------------------------------------
NEW FEATURES
* Reduced RAM usage and improved performance
* maintain vbaProject, slicers, pivotTables on load
* Read and load from URL
BUG FIXES
* Fix date time conversion accuracy issues.
* Allow multibyte characters in names and comments.
* Remove tolower() over style number formats to allow uppercase cell formatting
* Stacking styles fixed.
openxlsx 3.0.2
----------------------------------------------------------------
NEW FEATURES
* "between" type for conditional formatting values in some interval.
* colWidths parameter added to write.xlsx for auto column widths.
* freezePane parameter handling added to write.xlsx.
* visible parameter to addWorksheet to hide worksheets.
* sheetVisible function to get and assign worksheet visibility state "hidden"/"visible"
* pageBreak function to add page breaks to worksheets.
BUG FIXES
* keepNA paramter added to write.xlsx. Passed to writeData/writeDataTable
openxlsx 3.0.1
----------------------------------------------------------------
NEW FEATURES
* improved performance of read.xlsx and loadWorkbook
* writeFormula funciton added to write cell formulas. Also columns
with class "formula" are written as cell formulas similar how column
classes determine cell styling
* Functionality to write comments and maintain comments with loadWorkbook
* check.names argument added read.xlsx to make syntactically valid variable names
* loadWorkbook maintains cell indents
* namedRegion parameter added to read.xlsx to read a named region.
* getNamed regions to return names of named regions in a workbook
* getSheetNames to get worksheet names within an xlsx file.
BUG FIXES
* convertToDateTime now handles NA values
* read.xlsx rows bug fixed where non-consecutive cells were skipped.
* convertToDate & convertToDateTime now handle NA values.
* out of bounds worksheet fixed for libre office xlsx files.
* loadWorkbook now maintains chartSheets
openxlsx 2.4.0
----------------------------------------------------------------
NEW FEATURES
* stackable cell styling
* getDateOrigin function to return the date origin used internally by the xlsx file to pass to
convertToDate
* Auto-detection of date cells. Cells that "look" like dates will be converted to dates when reading from file.
* read.xlsx.Workbook to read from workbook objects
* colIndex, rowIndex added to read.xlsx to only read specified rows and columns
* Excel slicers now maintained by loadWorkbook
* fill styles extended to support gradientFill
BUG FIXES
* Encoding fixed and multi-byte characters now supported.
* read.xlsx now maintains multiple consecutive spaces and newline characters.
* convertToDate & convertToDateTime now handle NA values.
* multiple selected worksheet issue whioch preventing adding of new worksheets in Excel.
* zoom parameter now limited to [10, 400] and documentation updated.
* write.xlsx colnames parameter being assigned to rownames
* Handling of NaN and Inf values in writeData
openxlsx 2.1.3
----------------------------------------------------------------
NEW FEATURES
* conditionalFormatting type "databar"
* asTable parameter to write.xlsx to writing using writeDataTable.
* extended numFmt formatting to numeric rounding also added option("openxlsx.numFmt" = ...)
for default number formatting of numeric columns
* additional numFmt "comma" to format numerics with "," thousands separator
* tableName parameter to writeDataTable to assign the table a name
* headerStyle parameter to writeDataTable for additional column names styling
* textRotation parameter to createStyle to rotate cell text
* functions addFilter & removeFilter to add filters to columns
* Headers & footers extended, can now be set with addWorksheet and setHeaderFooter.
setHeader & setFooter deprecated.
* "fitToWidth" and "fitToHeight" logicals in pageSetup.
* "zoom" parameter in addWorksheet to set worksheet zoom level.
* "withFilter"" parameter to writeDataTable and writeData to remove table filters
* keepNa parameter to writeDataTable and writeData to write NA values as #N/A
* auto column widths can now be set with width = "auto"
VIGNETTE
* section on write.xlsx in Introductory vignette
BUG FIXES
* Fix reading in of apostrophes
* Styling blank cells no longer corrupts workbooks
* read.xlsx now correctly reads sharedStrings with inline styling
* sharedStrings now exact matches true/false to determine logical values from workbooks.
* fomulas in column caused openxlsx to crash. This has been fixed.
openxlsx 2.0.15
----------------------------------------------------------------
NEW FEATURES
* writeData now style based on column class the same as writeDataTable
* Vignette "Formatting" for examples focussed on formatting
* Customizable date formatting with createStyle and also through option("openxlsx.dateFormat" = ...)
* Customizable POSIX formatting with createStyle and also through option("openxlsx.datetimeFormat" = ...)
* Generalised conditionalFormat function to complex expressions and color scales.
* writeData border type "all" to draw all borders and maintain column styling.
* Deprecated "sheets" and replaced with "names" function
* column class "scientific" to automatically style as scientific numbers
* writeData now handles additional object classes: coxph, cox.zph, summary.coxph1 from Survival package
BUG FIXES
* Invalid XML characters in hyperlinks now replaced.
* Encoding issues when writing data read in with read.xlsx
* scientific notation resulting in corrupt workbooks fix
* Multiple saves of Workbooks containing conditional formatting were corrupt.
* Latin1 characters now write correctly.
* logicals written as 0/1 instead of TRUE/FALSE
openxlsx 2.0.1
----------------------------------------------------------------
NEW FEATURES
* write.xlsx function to write data directly to file via the writeData function
with basic cell styling.
* writeDataTable now styles columns of class 'Date', 'POSIXct', 'POSIXt', 'currency', 'accounting', 'percentage'
as Excel formats Date, Date, Date, Currency, Accounting, Percentage respectively.
* Data of class 'Date', 'POSIXct', 'POSIXt', 'currency', 'accounting' are converted to integers
upon writing (as opposed to characters).
* writeDataTable converts columns of class 'hyperlink' to hyperlinks.
* logicals are converted to Excel booleans
* hyperlinks in loaded workbooks are now maintained
* borderStyle argument to createStyle to modify border line type.
* borderStyle argument to writeData to modify border line type.
* "worksheetOrder" function to shuffle order of worksheets when writing to file
* openXL function to open an excel file or Workbook object
BUG FIXES
* conversion of numeric data to integer in read.xlsx fixed.
* readWorkbook/read.xlsx should work now. Empty values are
now padded with NA. Many other bugs fixed.
* borders on single row and/or column data.frames now work.
* readWorkbook/read.xlsx check for TRUE/FALSE values is now case-insensitive.
* sheet names containing invalid xml charcters (&, <, >, ', ") now work when referencing
by name and will not result in a corrupt workbook.
* sheet names containing non-local characters can now be referenced by name.
* Invalid factor level when missing values in writeData
* saveWorkbook now accepts relative paths.
* Non-local character encoding issues.
* errors in vignette examples.
* numbers with > 8 digits were rounded in writeData