Applied Patch by Joao Almeida: When editing an existing sheet, cells merge was not working.
Applied Patch by boss@airbladesoftware.com
groups.google.com/d/msg/rubyspreadsheet/73IoEwSx69w/barE7uVnIzwJ
uthor: Keith Walsh <keith.walsh@adtegrity.com> Date: Mon Mar 11 16:48:25 2013 -0400
Typo correction in guide example.
Author: Roque Pinel <roque.pinel@infotechfl.com> Date: Wed Feb 27 12:10:29 2013 -0500
Requiring BigDecimal for checking.
Made API friendly to BigDecimal precision.
Changes introduced by the user 'valeriusjames'.
Updated Manifest.txt to include lib/spreadsheet/excel/rgb.rb
Adding support for converting color palette values to RGB values (not vice-versa..yet)
Author: Eugeniy Belyaev (zhekanax)
You can merge if you are interested in perl-like Workbook.set_custom_color implementation. I know it is not really a proper way to deal with custom colors, but nevertheless it makes it possible.
Author: Kenichi Kamiya <kachick1@gmail.com> Date: Wed Feb 6 11:23:35 2013 +0900
Link to Travis CI on README
Remove warnings "assigned but unused variable" in test
Remove warnings "assigned but unused variable"
Enable $VERBOSE flag when running test
Author: DeTeam <timur.deteam@gmail.com> Date: Tue Jan 22 19:11:52 2013 +0400
Make tests pass
Readme updated
RuntimeError when file is empty
Hoe in dev deps
Finish with bundler
Add a Gemfile
also see: github.com/zdavatz/spreadsheet/pull/24
Author: Kenichi Kamiya <kachick1@gmail.com> Date: Tue Jan 15 15:52:58 2013 +0900
Remove warnings "method redefined; discarding old default_format"
Remove warnings "`*' interpreted as argument prefix"
Remove warnings "instance variable @{ivar} not initialized"
Remove warnings "assigned but unused variable"
also see: github.com/zdavatz/spreadsheet/pull/21
Add error tolerant values for Iconv when writing spreadsheet
by andrea@spaghetticode.it
Adds Spreadsheet::Excel::Row#to_a method to properly decode Date and DateTime data.
patches by github.com/mdgreenfield/spreadsheet
Fix Format borders
see github.com/zdavatz/spreadsheet/pull/6 for full details.
patches by uraki66@gmail.com
many changes by Mina Naguib <mina.git@naguib.ca>
see git log for full details
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
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
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
adds the fix to allow the writing of empty rows, by ClemensP.
Test also by ClemensP.
dev.ywesee.com/wiki.php/Gem/Spreadsheet points point 2.
Tests by Michal
Patches by Timon
dev.ywesee.com/wiki.php/Gem/Spreadsheet points 8 and 9.
Fixes byjsaak@napalm.hu
Patches by Vitaly Klimov
Fixed a frozen string bug thanks to dblock (Daniel Doubrovkine),
dblock@dblock.org
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
Fixed the bug introduced by Roel van der Hoorn and updated the test cases.
Added a fix from Roel van der Hoorn to sanitize_worksheets if 'sheets' is empty.
updated the color code for orange to 0x0034 => :orange, thanks to the hint of Jonty
Updated worksheet.rb according to the Patch of Björn Andersson.
Updated Txt lib/spreadsheet/excel/writer/biff8.rb with a Patch from Alexandre Bini
See this for full detail: url.ba/6r1z
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
One enhancement thanks to Qiong Peng, Moo Yu, and Thierry Thelliez
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.
3 Bugfixes
Fixes the issue reported by Thomas Preymesser and tracked down most of the way by Hugh McGowan in 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 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 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 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 rubyforge.org/tracker/index.php?func=detail&aid=26513&group_id=678&atid=2677
5 Bugfixes
Fixes the issue reported by Harley Mackenzie in 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 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 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 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 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
3 Bugfixes
Only selects the First Worksheet by default This deals with an issue reported by Biörn Andersson in 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 scm.ywesee.com/?p=spreadsheet;a=commit;h=52755ad76fdda151564b689107ca2fbb80af3b78 and reported in rubyforge.org/tracker/index.php?func=detail&aid=23875&group_id=678&atid=2678 and by Joachim Schneider in rubyforge.org/forum/forum.php?thread_id=31056&forum_id=2920
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.
1 minor enhancements
Spreadsheet shold now be completely warning-free, as requested by Eric Peterson in rubyforge.org/forum/forum.php?thread_id=31346&forum_id=2920
1 Bugfix
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
Documents created by Spreadsheet can now be Printed in Excel and Excel-Viewer. This issue was reported by Spencer Turner in rubyforge.org/tracker/index.php?func=detail&aid=23287&group_id=678&atid=2677
1 Bugfix
Using Spreadsheet together with 'jcode' could lead to broken Excel-Files Thanks to Eugene Mikhailov for tracking this one down in: rubyforge.org/tracker/index.php?func=detail&aid=23085&group_id=678&atid=2677
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 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 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 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 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 blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/321979 and by Chris Lowis in 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 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 rubyforge.org/forum/message.php?msg_id=62941 Reported by David Chamberlain
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)
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)
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)
2 Bugfixes
Fixed encoding and decoding of BigNums, negative and other large Numbers 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 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)
2 Bugfixes
Removed obsolete code which triggered Iconv::InvalidEncoding on Systems with non-gnu Iconv: rubyforge.org/tracker/index.php?func=detail&aid=22541&group_id=678&atid=2677
Handle empty Worksheets (Thanks to Charles Lowe for the Patches)
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)
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)
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.
1 Bugfix
Corrected the Manifest - included column.rb
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
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.
Generated with the Darkfish Rdoc Generator 2.