Fixes the issue reported and fixed by Corey Burrows in 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 a bug reported by Alexander Skwar in 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.
Fixes the issue reported by Corey Martella in 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
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 modifying a Row in a loaded Workbook could lead to Rows
with smaller indices being set to nil. Reported by Ivan Samsonov in rubyforge.org/forum/message.php?msg_id=62816
Deals with rounding-problems when calculating Time Reported by Bughunter
extraordinaire Bjørn Hjelle
Read formats correctly in read_mulrk Reported by Ivan Samsonov Fixes that
part of 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.
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)
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.