forked from scottwillson/spreadsheet
/
History.txt
307 lines (207 loc) · 10.2 KB
/
History.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
=== 0.6.5 / 07.12.2010
* 2 Enhancements courtesy to ISS AG.
* Outlining (Grouping) of lines and columns is now possible. The outlining
maximum is 8. This means you can do 8 subgroups in a group.
* Hiding and Unhiding of lines and columns is now possible.
* Both of above two points is now possible by creating a new Excel File from
scratch or editing an existing XLS and adding groups or hiding lines to it.
=== 0.6.4.1 / 2009-09-17
* 3 Bugfixes
* Fixes the issue reported by Thomas Preymesser and tracked down most of the
way by Hugh McGowan in
http://rubyforge.org/tracker/index.php?func=detail&aid=26647&group_id=678&atid=2677
where reading the value of the first occurrence of a shared formula
failed.
* Fixes the issue reported by Anonymous in
http://rubyforge.org/tracker/index.php?func=detail&aid=26546&group_id=678&atid=2677
where InvalidDate was raised for some Dates.
* Fixes the issue reported by John Lee in
http://rubyforge.org/tracker/index.php?func=detail&aid=27110&group_id=678&atid=2677
which is probably a duplicate of the Bug previously reported by Kadvin XJ in
http://rubyforge.org/tracker/index.php?func=detail&aid=26182&group_id=678&atid=2677
where unchanged rows were marked as changed in the Excel-Writer while the
File was being written, triggering an Error.
* 1 minor enhancement
* Detect row offsets from Cell data if Row-Ops are missing
This fixes a bug reported by Alexander Logvinov in
http://rubyforge.org/tracker/index.php?func=detail&aid=26513&group_id=678&atid=2677
=== 0.6.4 / 2009-07-03
* 5 Bugfixes
* Fixes the issue reported by Harley Mackenzie in
http://rubyforge.org/tracker/index.php?func=detail&aid=24119&group_id=678&atid=2677
where in some edge-cases numbers were stored incorrectly
* Fixes the issue reported and fixed by someone23 in
http://rubyforge.org/tracker/index.php?func=detail&aid=25732&group_id=678&atid=2677
where using Row-updater methods with blocks caused LocalJumpErrors
* Fixes the issue reported and fixed by Corey Burrows in
http://rubyforge.org/tracker/index.php?func=detail&aid=25784&group_id=678&atid=2677
where "Setting the height of a row, either in Excel directly, or via the
Spreadsheet::Row#height= method results in a row that Excel displays with
the maximum row height (409)."
* Fixes the issue reported by Don Park in
http://rubyforge.org/tracker/index.php?func=detail&aid=25968&group_id=678&atid=2677
where some Workbooks could not be parsed due to the OLE-entry being all
uppercase
* Fixes the issue reported by Iwan Buetti in
http://rubyforge.org/tracker/index.php?func=detail&aid=24414&group_id=678&atid=2677
where parsing some Workbooks failed with an Invalid date error.
* 1 major enhancement
* Spreadsheet now runs on Ruby 1.9
=== 0.6.3.1 / 2009-02-13
* 3 Bugfixes
* Only selects the First Worksheet by default
This deals with an issue reported by Biörn Andersson in
http://rubyforge.org/tracker/?func=detail&atid=2677&aid=23736&group_id=678
where data-edits in OpenOffice were propagated through all selected
sheets.
* Honors Row, Column, Worksheet and Workbook-formats
and thus fixes a Bug introduced in
http://scm.ywesee.com/?p=spreadsheet;a=commit;h=52755ad76fdda151564b689107ca2fbb80af3b78
and reported in
http://rubyforge.org/tracker/index.php?func=detail&aid=23875&group_id=678&atid=2678
and by Joachim Schneider in
http://rubyforge.org/forum/forum.php?thread_id=31056&forum_id=2920
* Fixes a bug reported by Alexander Skwar in
http://rubyforge.org/forum/forum.php?thread_id=31403&forum_id=2920
where the user-defined formatting of Dates and Times was overwritten with
a default format, and other issues connected with writing Dates and Times
into Spreadsheets.
* 1 minor enhancements
* Spreadsheet shold now be completely warning-free,
as requested by Eric Peterson in
http://rubyforge.org/forum/forum.php?thread_id=31346&forum_id=2920
=== 0.6.3 / 2009-01-14
* 1 Bugfix
* Fixes the issue reported by Corey Martella in
http://rubyforge.org/forum/message.php?msg_id=63651
as well as other issues engendered by the decision to always shorten
Rows to the last non-nil value.
* 2 minor enhancements
* Added bin/xlsopcodes, a tool for examining Excel files
* Documents created by Spreadsheet can now be Printed in Excel and
Excel-Viewer.
This issue was reported by Spencer Turner in
http://rubyforge.org/tracker/index.php?func=detail&aid=23287&group_id=678&atid=2677
=== 0.6.2.1 / 2008-12-18
* 1 Bugfix
* Using Spreadsheet together with 'jcode' could lead to broken Excel-Files
Thanks to Eugene Mikhailov for tracking this one down in:
http://rubyforge.org/tracker/index.php?func=detail&aid=23085&group_id=678&atid=2677
=== 0.6.2 / 2008-12-11
* 14 Bugfixes
* Fixed a bug where #<boolean>! methods did not trigger a call to
#row_updated
* Corrected the Row-Format in both Reader and Writer (was Biff5 for some
reason)
* Populates Row-instances with @default_format, @height, @outline_level
and @hidden attributes
* Fixed a Bug where Workbooks deriving from a Template-Workbook without
SST could not be saved
Reported in
http://rubyforge.org/tracker/index.php?func=detail&aid=22863&group_id=678&atid=2678
* Improved handling of Numeric Values (writes a RK-Entry for a Float
only if it can be encoded with 4 leading zeroes, and a Number-Entry for an
Integer only if it cannot be encoded as an RK)
* Fixes a bug where changes to a Row were ignored if they were
outside of an existing Row-Block.
* Fixes a bug where MULRK-Entries sometimes only contained a single RK
* Fixes a bug where formatting was ignored if it was applied to empty Rows
Reported by Zomba Lumix in
http://rubyforge.org/forum/message.php?msg_id=61985
* Fixes a bug where modifying a Row in a loaded Workbook could lead to Rows
with smaller indices being set to nil.
Reported by Ivan Samsonov in
http://rubyforge.org/forum/message.php?msg_id=62816
* Deals with rounding-problems when calculating Time
Reported by Bughunter extraordinaire Bjørn Hjelle
* Correct splitting of wide characters in SST
Reported by Michel Ziegler and by Eugene Mikhailov in
http://rubyforge.org/tracker/index.php?func=detail&aid=23085&group_id=678&atid=2677
* Fix an off-by-one error in write_mulrk that caused Excel to complain that
'Data may be lost', reported by Emma in
http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/321979
and by Chris Lowis in
http://rubyforge.org/tracker/index.php?func=detail&aid=22892&group_id=678&atid=2677
* Read formats correctly in read_mulrk
Reported by Ivan Samsonov
Fixes that part of http://rubyforge.org/forum/message.php?msg_id=62821
which is a bug. Does nothing for the disappearance of Rich-Text
formatting, which will not be addressed until 0.7.0
* Fixes a (benign?) bug, where adding text to a template-file resulted in
a duplicate extsst-record.
* 2 minor enhancements
* Improved recognition of Time-Formats
* Improvement to Robustness: allow Spreadsheet::Workbook.new
Takes care of http://rubyforge.org/forum/message.php?msg_id=62941
Reported by David Chamberlain
=== 0.6.1.9 / 2008-11-07
* 1 Bugfix
* Fixes a precision-issue in Excel::Row#datetime: Excel records Time-Values
with more significant bits (but not necessarily more precise) than
DateTime can handle.
(Thanks to Bjørn Hjelle for the Bugreport)
* 1 minor enhancement
* Added support for appending Worksheets to a Workbook
(Thanks to Mohammed Rabbani for the report)
=== 0.6.1.8 / 2008-10-31
* 1 Bugfix
* Fixes a bug where out-of-sequence reading of multiple Worksheets could
lead to data from the wrong Sheet being returned.
(Thanks to Bugreporter extraordinaire Bjørn Hjelle)
=== 0.6.1.7 / 2008-10-30
* 1 Bugfix
* Fixes a bug where all Formulas were ignored.
(Thanks to Bjørn Hjelle for the report)
* 1 minor enhancement
* Allow the substitution of an IO object with a StringIO.
(Thanks to luxor for the report)
=== 0.6.1.6 / 2008-10-28
* 2 Bugfixes
* Fixed encoding and decoding of BigNums, negative and other large Numbers
http://rubyforge.org/tracker/index.php?func=detail&aid=22581&group_id=678&atid=2677
* Fix a bug where modifications to default columns weren't stored
http://rubyforge.org/forum/message.php?msg_id=61567
* 1 minor enhancement
* Row#enriched_data won't return a Bogus-Date if the data isn't a Numeric
value
(Thanks to Bjørn Hjelle for the report)
=== 0.6.1.5 / 2008-10-24
* 2 Bugfixes
* Removed obsolete code which triggered Iconv::InvalidEncoding
on Systems with non-gnu Iconv:
http://rubyforge.org/tracker/index.php?func=detail&aid=22541&group_id=678&atid=2677
* Handle empty Worksheets
(Thanks to Charles Lowe for the Patches)
=== 0.6.1.4 / 2008-10-23
* 1 Bugfix
* Biff8#wide now works properly even if $KCODE=='UTF-8'
(Thanks to Bjørn Hjelle for the Bugreport)
* 1 minor enhancement
* Read/Write functionality for Links (only URLs can be written as of now)
=== 0.6.1.3 / 2008-10-21
* 2 Bugfixes
* Renamed UTF8 to UTF-8 to support freebsd
(Thanks to Jacob Atzen for the Patch)
* Fixes a Bug where only the first Rowblock was read correctly if there were
no DBCELL records terminating the Rowblocks.
(Thanks to Bjørn Hjelle for the Bugreport)
=== 0.6.1.2 / 2008-10-20
* 2 Bugfixes
* Corrected the Font-Encoding values in Excel::Internals
(Thanks to Bjørn Hjelle for the Bugreport)
* Spreadsheet now skips Richtext-Formatting runs and Asian Phonetic
Settings when reading the SST, fixing a problem where the presence of
Richtext could lead to an incomplete SST.
=== 0.6.1.1 / 2008-10-20
* 1 Bugfix
* Corrected the Manifest - included column.rb
=== 0.6.1 / 2008-10-17
* 3 minor enhancements
* Adds Column formatting and Worksheet#format_column
* Reads and writes correct Fonts (Font-indices > 3 appear to be 1-based)
* Reads xf data
=== 0.6.0 / 2008-10-13
* 1 major enhancement
* Initial upload of the shiny new Spreadsheet Gem after three weeks of
grueling labor in the dark binary mines of Little-Endian Biff and long
hours spent polishing the surfaces of documentation.