=== 0.7.2 / 14.06.2012
* many changes by Mina Naguib <mina.git@naguib.ca>
* see git log for full details
=== 0.7.1 / 08.05.2012
* Author: Artem Ignatiev <zazubrik@gmail.com>
* remove require and rake altogether
* gem build and rake gem both work fine without those requires,
* and requiring 'rake' broke bundler
* add rake as development dependency
* Somehow it broken rake on my other project
=== 0.7.0 / 07.05.2012
* Author: Artem Ignatiev <zazubrik@gmail.com>
* use both ruby 1.8 and 1.9 compatible way of getting character code when hashing
* Fix syntax for ruby-1.9
* return gemspec so that bundler can find it
When bundler loads gemspec, it evaluates it, and if the return value is
not a gem specification built, refuses to load the gem.
* Testing worksheet protection
=== 0.6.9 / 28.04.2012
* Yield is more simple here too.
* No need to capture the block in Spreadsheet.open
* Rather than extending a core class, let's just use #rcompact from a helper module
=== 0.6.8 / 20.01.2012
* adds the fix to allow the writing of empty rows, by ClemensP.
* Test also by ClemensP.
=== 0.6.7 / 18.01.2012
* http://dev.ywesee.com/wiki.php/Gem/Spreadsheet points point 2.
* Tests by Michal
* Patches by Timon
=== 0.6.6 / 18.01.2012
* http://dev.ywesee.com/wiki.php/Gem/Spreadsheet points 8 and 9.
* Fixes byjsaak@napalm.hu
* Patches by Vitaly Klimov
=== 0.6.5.9 / 7.9.2011
* Fixed a frozen string bug thanks to dblock (Daniel Doubrovkine),
* dblock@dblock.org
* https://github.com/dblock/spreadsheet/commit/164dcfbb24097728f1a7453702c270107e725b7c
=== 0.6.5.8 / 30.8.2011
* This patch is about adding a sheet_count method to workbook so that it returns
* the total no of worksheets for easy access. Please check. By
* tamizhgeek@gmail.com
* https://gist.github.com/1180625
=== 0.6.5.7 / 20.7.2011
* Fixed the bug introduced by Roel van der Hoorn and updated the test cases.
* https://github.com/vanderhoorn/spreadsheet/commit/c79ab14dcf40dee1d6d5ad2b174f3fe31414ca28
=== 0.6.5.6 / 20.7.2011
* Added a fix from Roel van der Hoorn to sanitize_worksheets if 'sheets' is empty.
* https://github.com/vanderhoorn/spreadsheet/commit/c109f2ac5486f9a38a6d93267daf560ab4b9473e
=== 0.6.5.5 / 24.6.2011
* updated the color code for orange to 0x0034 => :orange, thanks to the hint of Jonty
* https://gist.github.com/1044700
=== 0.6.5.4 / 18.4.2011
* Updated worksheet.rb according to the Patch of Björn Andersson.
* https://gist.github.com/925007#file_test.patch
* http://url.ba/09p9
=== 0.6.5.3 / 23.3.2011
* Updated Txt lib/spreadsheet/excel/writer/biff8.rb with a Patch from Alexandre Bini
* See this for full detail: http://url.ba/6r1z
=== 0.6.5.2 / 14.2.2011
* Updated test/integration.rb to work with Ruby ruby 1.9.2p136 (2010-12-25 revision 30365) [i686-linux]
* Thanks for the hint tomiacannondale@gmail.com
=== 0.6.5.1 / 17.1.2011
* One enhancement thanks to Qiong Peng, Moo Yu, and Thierry Thelliez
* http://dev.ywesee.com/wiki.php/Gem/Spreadsheet
=== 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.