Author: Alexandre Balon-Perin [email protected] Date: Fri Aug 5 17:19:29 2016 +0900
- Fix issue with iconv on Ubuntu 12.04
- This fix is related to a bug in the iconv implementation packaged in libc6 on Ubuntu 12.04
- For some reasons, the encoding options //TRANSLIT//IGNORE are improperly applied.
- When //TRANSLIT is specified, instead of rescuing errors related to //TRANSLIT and checking if the //IGNORE is set, the code simply crashes.
Author: Aleksandr Boykov [email protected] Date: Mon Mar 28 14:07:35 2016 -0400
fixes compact! method when the excel document has dates
Author: ChouAndy [email protected] Date: Sun Jan 3 17:26:18 2016 +0800
Fixed Unknown Codepage 0x5212
Author: Matthew Boeh [email protected] Date: Mon Dec 7 11:18:55 2015 -0800
- Disregard locale indicators when determining whether a cell contains a date/time.
Author: 545ch4 [email protected] Date: Mon Nov 16 10:26:27 2015 +0100
- Add smart method compact! to worksheet
- Use compact! to reduce the number of rows and columns by striping empty one at both ends.
commit e9bd1dd34998803b63460f4951e9aa34e569bd8f Author: Pierre Laprée [email protected] Date: Tue Oct 20 03:12:22 2015 +0200
- Remove stray
puts
- A
puts
instruction pollutes the log and doesn't serve any purpose. As such, we propose its removal.
Author: Leopoldo Lee Agdeppa III [email protected] Date: Wed Sep 23 08:24:16 2015 +0800
- Update worksheet.rb
- Adding Test for Freeze panels
- Update worksheet.rb
- Added freeze (freeze panel) functionality
- Update worksheet.rb
- Freeze (freeze window) functionality added to worksheet
Author: Yann Plancqueel [email protected] Date: Sat Sep 12 15:32:49 2015 +0200
- bugfix opening a spreadsheet with missing format
Author: kunashir [email protected] Date: Tue Sep 1 13:12:49 2015 +0300
- add format for nubmer with out #
Author: Edmund Mai [email protected] Date: Fri Jul 17 15:32:47 2015 -0400
- Fixes slow Spreadsheet.open response in console
Author: Robert Eshleman [email protected] Date: Mon Mar 9 09:47:59 2015 -0400
- Update
ruby-ole
to1.2.11.8
**ruby-ole
<=1.2.11.7
throws a duplicated key warning in Ruby 2.2. ** This commit updatesruby-ole
to1.2.11.8
, which fixes this warning. ** Related discussion: [aquasync/ruby-ole#15] - [aquasync/ruby-ole#15]: aquasync/ruby-ole#15
Author: cantin [email protected] Date: Thu Mar 5 16:13:59 2015 +0800
- add Rational support
- add rational requirement
- use old rational syntax in test
Author: Sergey Konotopov [email protected] Date: Wed Jan 21 13:19:56 2015 +0300
- Fixing Excel::Worksheet#dimensions
- added spreadsheet/errors.rb to Manifest.txt
Author: PikachuEXE [email protected] Date: Wed Aug 27 09:55:41 2014 +0800
- Add custom error classes
- Raise custom error for unknown code page or unsupported encoding
Author: PikachuEXE [email protected] Date: Tue Aug 19 09:54:30 2014 +0800
- Fix Encoding for MRI 2.1.0
- Avoid exception when reading text objects
- Add test for drawings with text (currenty broken)
- Restore xlsopcodes script which had been mangled in previous commits
- Remove ruby 1.9 from roadmap, it's already working fine
- Fix excel file format documentation which had been mangled in previous commits
Author: Malcolm Blyth [email protected] Date: Mon Dec 2 11:44:25 2013 +0000
- Fixed issue whereby object author being null caused a gross failure.
- Now returns object author as an empty string
Author: Malcolm Blyth [email protected] Date: Tue Nov 19 15:14:31 2013 +0000
- Bumped revision
- Fixed author stringname error (damn this 1 based counting)
- Updating integration test to check for comments contained within the cells.
- Checking also for multiple comments in a sheet
- Updated Manifest.txt
commit e15d8b45d7587f7ab78c7b7768de720de9961341 (refs/remotes/gguerrero/master) Author: Guillermo Guerrero [email protected] Date: Tue Nov 12 11:50:30 2013 +0100
- Refactor update_format for cloning format objects
- Added lib/spreadsheet/note.rb to Manifest.txt file
- 'update_format' methods now receive a hash of key => values to update
Author: Przemysław Ciąćka [email protected] Date: Tue Nov 12 00:07:57 2013 +0100
- Added lib/spreadsheet/note.rb to Manifest.txt file
commit e70dc0dbbc966ce312b45b0d44d0c3b1dc10aad6 Author: Malcolm Blyth [email protected] Date: Mon Nov 11 15:53:58 2013 +0000
*Corrected compressed string formatting - *U (UTF-8) should have been *S (16-bit string) *Completed addition of notes hash to worksheet *Bumped revision *Updated reader and note Note class no longer extends string for simplicity and debug of class (pp now works a bit more easily) Reader has had loads of changes (still WIP) to allow objects of class Note and NoteObject to be created and combined in the postread_worksheet function *Adding noteObject to deal with the Object (and ultimately text comment field) created by excel's madness
-
Author: Matti Lehtonen [email protected] Date: Thu Oct 24 09:41:50 2013 +0300
-
Add support for worksheet visibility
-
Author: Pavel [email protected] Date: Mon Sep 16 14:02:49 2013 +0700
-
Test cases for Worksheet#margins, Worksheet#pagesetup, Workbook#delete_worksheet. Fix bugs related to it.
-
Page margins reader/writter
-
Markdownify GUIDE
-
Add page setup options (landscape or portrait and adjust_to)
Author: Doug Renn [email protected] Date: Fri Aug 23 17:10:24 2013 -0600
- Work around to handle number formats that are being mistaken time formats
Author: Nathan Colgate [email protected] Date: Thu Aug 1 15:01:57 2013 -0500
- Update excel/internals.rb to reference a valid Encoding type
- Encoding.find("MACINTOSH") was throwing an error. Encoding.find("MACROMAN") does not.
Author: Yasuhiro Asaka [email protected] Date: Wed Jul 24 11:31:12 2013 +0900
- Remove warnings for test suite
- warning: mismatched indentations at 'end' with 'class' at xxx
- warning: method redefined; discarding old xxx
- warning: assigned but unused variable xxx
- warning: previous definition of xxx was here
- The source :rubygems is deprecated because HTTP
- requests are insecure. (Gemfile)
Author: Arjun Anand and Robert Stern [email protected] Date: Wed Jul 10 13:45:30 2013 -0400
- Allow editing of an existing worksheet.
- Applied Patch by Joao Almeida: When editing an existing sheet, cells merge was not working.
- https://github.com/voraz/spreadsheet/pull/14.patch
- Applied Patch by [email protected]
- https://groups.google.com/d/msg/rubyspreadsheet/73IoEwSx69w/barE7uVnIzwJ
Author: Keith Walsh [email protected] Date: Mon Mar 11 16:48:25 2013 -0400
- Typo correction in guide example.
Author: Roque Pinel [email protected] 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)
- by https://github.com/dancaugherty/spreadsheet/compare/master...rgb
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.
- zdavatz#27
Author: Kenichi Kamiya [email protected] 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 [email protected] 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: zdavatz#24
Author: Kenichi Kamiya [email protected] 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: zdavatz#21
- Add error tolerant values for Iconv when writing spreadsheet
- by [email protected]
- Adds Spreadsheet::Excel::Row#to_a method to properly decode Date and DateTime data.
- patches by https://github.com/mdgreenfield/spreadsheet
- Fix Format borders
- see zdavatz#6 for full details.
- patches by [email protected]
- many changes by Mina Naguib [email protected]
- see git log for full details
- Author: Artem Ignatiev [email protected]
- 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 [email protected]
- 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.
- http://dev.ywesee.com/wiki.php/Gem/Spreadsheet points point 2.
- Tests by Michal
- Patches by Timon
- http://dev.ywesee.com/wiki.php/Gem/Spreadsheet points 8 and 9.
- Fixes [email protected]
- Patches by Vitaly Klimov
-
Fixed a frozen string bug thanks to dblock (Daniel Doubrovkine),
-
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
-
* 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: http://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 [email protected]
-
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 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
-
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
-
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
-
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
-
-
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
-
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
-
-
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 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)
-
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)
-
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.