=== 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 #! 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.