This repository has been archived by the owner on May 24, 2021. It is now read-only.
forked from roo-rb/roo
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathCHANGELOG
372 lines (305 loc) · 13.4 KB
/
CHANGELOG
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
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
== 1.12.0 (unreleased)
* 3 deprecations
* Rename Openoffice -> OpenOffice, Libreoffice -> LibreOffice, Csv -> CSV, and redirect the old names to the new constants
* Enable Roo::Excel, Excel2003XML, Excelx, OpenOffice to accept an options hash, and deprecate the old method argument based approach to supplying them options
* Roo's roo_rails_helper, aka the `spreadsheet` html-generating view method is currently deprecated with no replacement. If you find it helpful, tell http://github.com/Empact or extract it yourself.
* 3 enhancements
* Add Roo::Excelx#load_xml so that people can customize to their data, e.g. https://github.com/Empact/roo/pull/23
* Enable passing csv_options to Roo::Csv, which are passed through to the underlying CSV call.
* Enable passing options through from Roo::Spreadsheet to any Roo type.
* Enable passing an :extension option to Roo::Spreadsheet.new, which will override the extension detected on in the path https://github.com/Empact/roo/pull/15
* Switch from google-spreadsheet-ruby to google_drive for Roo::Google access https://github.com/Empact/roo/pull/40
* Make all the classes consistent in that #read_cells is only effective if the sheet has not been read.
* 1 bugfix
* Fix that Roo::Csv#parse(headers: true) would blow up. https://github.com/Empact/roo/pull/37
== 1.11.2 2013-04-10
* 4 bugfixes
* Fix that Roo::Spreadsheet.open wasn't tolerant to case differences.
* Fix that Roo::Excel2003XML loading was broken https://github.com/Empact/roo/pull/27
* Enable loading Roo::Csv files from uris, just as other file types https://github.com/Empact/roo/pull/31
* Fix that Excelx "m/d/yy h:mm" was improperly being interpreted as date rather
than datetime https://github.com/Empact/roo/pull/29
== 1.11.1 2013-03-18
* 1 bugfix
* Exclude test/log/roo.log test log file from the gemspec in order to avoid a
rubygems warning: https://github.com/Empact/roo/pull/26
== 1.11.0 2013-03-14
* 3 enhancements
* Support ruby 2.0.0 by replacing Iconv with String#encode
https://github.com/Empact/roo/pull/19
* Excelx: Loosen the format detection rules such that more are
successfully detected https://github.com/Empact/roo/pull/20
* Delete the roo binary, which was useless and not declared in the gemspec
* 1 change
* Drop support for ruby 1.8.x or lower. Required in order to easily support 2.0.0.
== 1.10.3 2013-03-03
* 1 bugfix
* Support both nokogiri 1.5.5 and 1.5.6 (Karsten Richter) https://github.com/Empact/roo/pull/18
* 1 enhancement
* Relax our nokogiri dependency back to 1.4.0, as we have no particular reason
to require a newer version.
== 1.10.2 2013-02-03
* 2 bugfixes
* Support opening URIs with query strings https://github.com/Empact/roo/commit/abf94bdb59cabc16d4f7764025e88e3661983525
* Support both http: & https: urls https://github.com/Empact/roo/commit/fc5c5899d96dd5f9fbb68125d0efc8ce9be2c7e1
== 1.10.1 2011-11-14
* 2 bugfixes
* forgot dependency 'rubyzip'
* at least one external application does create xlsx-files with different internal file names which differ from the original file names of Excel. Solution: ignore lower-/upper case in file names.
== 1.10.0 2011-10-10
* 4 enhancements
* New class Csv.
* Openoffice, Libreoffice: new method 'labels'
* Excelx: implemented all methods concerning labels
* Openoffice, Excelx: new methods concerning comments (comment, comment? and comments)
* 2 bugfixes
* XLSX: some cells were not recognized correctly from a spreadsheet file from a windows mobile phone.
* labels: Moved to a separate methode. There were problems if there was an access to a label before read_cells were called.
== 1.9.7 2011-08-27
* 1 bugfix
* Openoffice: Better way for extracting formula strings, some characters were deleted at the formula string.
== 1.9.6 2011-08-03
* 1 enhancement
* new class Libreoffice (Libreoffice should do exactly the same as the Openoffice
class. It's just another name. Technically, Libreoffice is inherited from
the Openoffice class with no new methods.
* 3 bugfixes
* Openoffice: file type check, deletion of temporary files not in ensure clause
* Cell type :datetime was not handled in the to_csv method
* Better deletion of temporary directories if something went wrong
== 1.9.5 2011-06-25
* 1 enhancement
* Method #formulas moved to generic-spreadsheet class (the Excel version is
overwritten because the spreadsheet gem currently does not support
formulas.
* 3 bugfixes
* Openoffice/Excelx/Google: #formulas of an empty sheet should not result
in an error message. Instead it should return an empty array.
* Openoffice/Excelx/Google: #to_yaml of an empty sheet should not result
in an error message. Instead it should return an empty string.
* Openoffice/Excelx/Google: #to_matrix of an empty sheet should not result
in an error message. Instead it should return an empty matrix.
== 1.9.4 2011-06-23
* 1 enhancement
* removed gem 'builder'. Functionality goes to gem 'nokogiri'.
* 3 bugfixes
* Excel: remove temporary files if spreadsheed-file is not an excel file
and an exception was raised
* Excelx: a referenced cell with a string had the content 0.0 not the
correct string
* Fixed a problem with a date cell which was not recognized as a Date
object (see 2011-05-21 in excelx.rb)
== 1.9.3 2010-02-12
* 1 enhancements
* new method 'to_matrix'
* 1 bugfix
* missing dependencies defined
== 1.9.2 2009-12-08
* 1 bugfix
* double quoting of '"' fixed
== 1.9.1 2009-11-10
* 2 bugfixes
* syntax in nokogiri methods
* missing dependency ...rubyzip
== 1.9.0 2009-10-29
* 4 enhancements
* Ruby 1.9 compatible
* oo.aa42 as a shortcut of oo.cell('aa',42)
* oo.aa42('sheet1') as a shortcut of oo.cell('aa',42,'sheet1')
* oo.anton as a reference to a cell labelled 'anton' (or any other label name)
(currently only for Openoffice spreadsheets)
== 1.2.3 2009-01-04
* bugfix
* fixed encoding in #cell at exported Google-spreadsheets (.xls)
== 1.2.2 2008-12-14
* 2 enhancements
* added celltype :datetime in Excelx
* added celltype :datetime in Google
== 1.2.1 2008-11-13
* 1 enhancement
* added celltype :datetime in Openoffice and Excel
== 1.2.0 2008-08-24
* 3 major enhancements
* Excelx: improved the detection of cell type and conversion into roo types
* All: to_csv: changed boundaries from first_row,1..last_row,last_column to 1,1..last_row,last_column
* All: Environment variable "ROO_TMP" indicate where temporary directories will be created (if not set the default is the current working directory)
* 2 bugfixes
* Excel: improved the detection of last_row/last_column (parseexcel-gem bug?)
* Excel/Excelx/Openoffice: temporary directories were not removed at opening a file of the wrong type
== 1.1.0 2008-07-26
* 2 major enhancements
* Excel: speed improvements
* Changed the behavior of reading files with the wrong type
* 3 bugfixes
* Google: added normalize in set_value method
* Excel: last_row in Excel class did not work properly under some circumstances
* all: fixed a bug in #to_xml if there is an empty sheet
== 1.0.2 2008-07-04
* 2 bugfixes
* Excelx: fixed a bug when there are .xml.rels files in the XLSX archive
* Excelx: fixed a bug with celltype recognition (see comment with "2008-07-03")
== 1.0.1 2008-06-30
* 1 bugfix
* Excel: row/column method Fixnum/Float confusion
== 1.0.0 2008-05-28
* 2 major enhancements
* support of Excel's new .xlsx file format
* method #to_xml for exporting a spreadsheet to an xml representation
* 1 bugfix
* fixed a bug with excel-spreadsheet character conversion under Macintosh Darwin
== 0.9.4 2008-04-22
* 1 bugfix
* fixed a bug with excel-spreadsheet character conversion under Solaris
== 0.9.3 2008-03-25
* 1 bugfix
* no more tmp directories if an invalid spreadsheet file was openend
== 0.9.2 2008-03-24
* 1 enhancement
* new celltype :time
* 1 bugfix
* time values like '23:15' are handled as seconds from midnight
== 0.9.1 2008-03-23
* 1 enhancement
* additional 'sheet' parameter in Google#set_value
* 1 bugfix
* fixed a bug within Google#set_value. thanks to davecahill <[email protected]> for the patch.
== 0.9.0 2008-01-24
* 1 enhancement:
* better support of roo spreadsheets in rails views
== 0.8.5 2008-01-16
* 1 bugfix
* fixed a bug within #to_cvs and explicit call of a sheet
== 0.8.4 2008-01-01
* 1 bugfix
* fixed 'find_by_condition' for excel sheets (header_line= --> GenericSpredsheet)
== 0.8.3 2007-12-31
* 2 bugfixes
* another fix for the encoding issue in excel sheet-names
* reactived the Excel#find method which has been disappeared in the last restructoring, moved to GenericSpreadsheet
== 0.8.2 2007-12-28
* 1 enhancement:
* basename() only in method #info
* 2 bugfixes
* changed logging-method to mysql-database in test code with AR, table column 'class' => 'class_name'
* reactived the Excel#to_csv method which has been disappeared in the last restructoring
== 0.8.1 2007-12-22
* 3 bugfixes
* fixed a bug with first/last-row/column in empty sheet
* #info prints now '- empty -' if a sheet within a document is empty
* tried to fix the iconv conversion problem
== 0.8.0 2007-12-15
* 2 enhancements:
* Google online spreadsheets were implemented
* some methods common to more than one class were factored out to the GenericSpreadsheet (virtual) class
== 0.7.0 2007-11-23
* 6 enhancements:
* Openoffice/Excel: the most methods can be called with an option 'sheet'
parameter which will be used instead of the default sheet
* Excel: improved the speed of CVS output
* Openoffice/Excel: new method #column
* Openoffice/Excel: new method #find
* Openoffice/Excel: new method #info
* better exception if a spreadsheet file does not exist
== 0.6.1 2007-10-06
* 2 enhancements:
* Openoffice: percentage-values are now treated as numbers (not strings)
* Openoffice: refactoring
* 1 bugfix
* Openoffice: repeating date-values in a line are now handled correctly
== 0.6.0 2007-10-06
* 1 enhancement:
* csv-output to stdout or file
== 0.5.4 2007-08-27
* 1 bugfix
* Openoffice: fixed a bug with internal representation of a spreadsheet (thanks to Ric Kamicar for the patch)
== 0.5.3 2007-08-26
* 2 enhancements:
* Openoffice: can now read zip-ed files
* Openoffice: can now read files from http://-URL over the net
== 0.5.2 2007-08-26
* 1 bugfix
* excel: removed debugging output
== 0.5.1 2007-08-26
* 4 enhancements:
* Openoffice: Exception if an illegal sheet-name is selected
* Openoffice/Excel: no need to set a default_sheet if there is only one in
the document
* Excel: can now read zip-ed files
* Excel: can now read files from http://-URL over the net
== 0.5.0 2007-07-20
* 3 enhancements:
* Excel-objects: the methods default_sheet= and sheets can now handle names instead of numbers
* changed the celltype methods to return symbols, not strings anymore (possible values are :formula, :float, :string, :date, :percentage (if you need strings you can convert it with .to_s)
* tests can now run on the client machine (not only my machine), if there are not public released files involved these tests are skipped
== 0.4.1 2007-06-27
* 1 bugfix
* there was ONE false require-statement which led to misleading error messageswhen this gem was used
== 0.4.0 2007-06-27
* 7 enhancements:
* robustness: Exception if no default_sheet was set
* new method reload() implemented
* about 15 % more method documentation
* optimization: huge increase of speed (no need to use fixed borders anymore)
* added the method 'formulas' which gives you all formulas in a spreadsheet
* added the method 'set' which can set cells to a certain value
* added the method 'to_yaml' which can produce output for importing in a (rails) database
* 4 bugfixes
* ..row_as_letter methods were nonsense - removed
* @cells_read should be reset if the default_sheet is changed
* error in excel-part: strings are now converted to utf-8 (the parsexcel-gem gave me an error with my test data, which could not converted to .to_s using latin1 encoding)
* fixed bug when default_sheet is changed
== 0.3.0 2007-06-20
* 1 enhancement:
* Openoffice: formula support
== 0.2.7 2007-06-20
* 1 bugfix:
* Excel: float-numbers were truncated to integer
== 0.2.6 2007-06-19
* 1 bugfix:
* Openoffice: two or more consecutive cells with string content failed
== 0.2.5 2007-06-17
* 2 enhancements:
* Excel: row method implemented
* more tests
* 1 bugfix:
* Openoffice: row method fixed
== 0.2.4 2007-06-16
* 1 bugfix:
* ID 11605 Two cols with same value: crash roo (openoffice version only)
== 0.2.3 2007-06-02
* 3 enhancements:
* more robust call att Excel#default_sheet= when called with a name
* new method empty?
* refactoring
* 1 bugfix:
* bugfix in Excel#celltype
* bugfix (running under windows only) in closing the temp file before removing it
== 0.2.2 2007-06-01
* 1 bugfix:
* correct pathname for running with windows
== 0.2.2 2007-06-01
* 1 bugfix:
* incorrect dependencies fixed
== 0.2.0 2007-06-01
* 1 major enhancement:
* support for MS-Excel Spreadsheets
== 0.1.2 2007-05-31
* 1 major enhancement:
* cells with more than one character, like 'AA' can now be handled
== 0.1.1 2007-05-31
* 1 Bugfix
* Bugfix in first/last methods
== 0.1.0 2007-05-31
* 1 major enhancement:
* new methods first/last row/column
* new method officeversion
== 0.0.3 2007-05-30
* 1 minor enhancement:
* new method row()
== 0.0.2 2007-05-30
* 2 major enhancement:
* fixed some bugs
* more ways to access a cell
== 0.0.1 2007-05-25
* 1 major enhancement:
* Initial release