All Versions
81
Latest Version
Avg Release Cycle
92 days
Latest Release
317 days ago

Changelog History
Page 2

  • v2.3.1

    January 08, 2016

    🛠 Fixed

    • 📜 Properly parse scientific-notation number like 1E-3 #288
    • ✅ Include all tests in default rake run #283
    • 🛠 Fix zero-padded numbers for Excelx #282

    🔄 Changed

    • 🚚 Moved ERROR_VALUES from Excelx::Cell::Number ~> Excelx. #280
  • v2.3.0

    December 10, 2015

    🔄 Changed

    • Excelx::Cell::Number will return a String instead of an Integer or Float if the cell has an error like #DIV/0, etc. #273

    🛠 Fixed

    • Excelx::Cell::Number now handles cell errors. #273
  • v2.2.0

    October 31, 2015

    ➕ Added

    • ➕ Added support for returning Integers values to Roo::OpenOffice #258
    • A missing Header Raises Roo::HeaderRowNotFoundError #247
    • Roo::Excelx::Shared class to pass shared data to Roo::Excelx sheets #220
    • 👍 Proper Type support to Roo::Excelx #240
    • ➕ Added Roo::HeaderRowNotFoundError #247

    🔄 Changed

    • Made spelling/grammar corrections in the README260
    • 🚚 Moved Roo::Excelx::Format module #259
    • Updated README with details about Roo::Excelx#each_with_streaming method #250

    🛠 Fixed

    • 🛠 Fixed Base64 not found issue in Open Office #267
    • 🛠 Fixed Regexp to allow method access to cells with multiple digits #255, #268
  • v2.1.1

    August 02, 2015

    Fixed invalid new lines with x000D character#231

    🛠 Fixed missing URI issue. #245

  • v2.1.0

    July 18, 2015

    ➕ Added

    • ➕ Added support for Excel 2007 xlsm files. #232
    • Roo::Excelx returns an enumerator when calling each_row_streaming without a block. #224
    • Returns an enumerator when calling each without a block. #219

    🛠 Fixed

    • ✂ Removed tabs and windows CRLF. #235, #234
    • 🛠 Fixed Regexp to only check for valid URI's when opening a spreadsheet. #229
    • Open streams in Roo:Excelx correctly. #222
  • v2.0.1

    June 01, 2015

    ➕ Added

    • Return an enumerator when calling '#each' without a block #219
    • ➕ Added Roo::Base#close to delete any temp directories#211
    • Offset option for excelx #each_row. #214
    • 👍 Allow Roo::Excelx to open streams #209

    🛠 Fixed

    • 👉 Use gsub instead of tr for double quote escaping #212, #212-patch
    • 🛠 Fixed Changelog links and release data. #204, #206
    • 👍 Allow Pathnames to be used when opening files. #207

    ✂ Removed

    • ✂ Removed the scripts folder. #213
  • v2.0.0

    April 24, 2015

    ➕ Added

    • ➕ Added optional support for hidden sheets in Excelx and LibreOffice files #177
    • Roo::OpenOffice can be used to open encrypted workbooks. #157
    • ➕ Added streaming for parsing of large Excelx Sheets. #69
    • Added Roo::Base#first_last_row_col_for_sheet a0dd800
    • Added Roo::Base#collect_last_row_col_for_sheet a0dd800
    • Added Roo::Base::MAX_ROW_COL, Roo::Base::MIN_ROW_COL a0dd800
    • Extract Roo::Font to replace equivalent uses in Excelx and OpenOffice. 23e19de
    • Roo::Utils 3169a0e
    • Roo::ExcelxComments 0a43341 0a43341
    • Roo::Excelx::Relationships 0a43341
    • Roo::Excelx::SheetDoc 0a43341 c2bb7b8 +- 💅 Roo::Excelx::Styles c2bb7b8 +- Roo::Excelx::Workbook c2bb7b8
    • Switch from Spreadsheet::Link to Roo::Link ee67321
    • 0️⃣ Roo::Base#to_csv: Added separator parameter (defaults to ",") #102
    • ➕ Added development development gems #104

    🔄 Changed

    • ⬇️ Reduced size of published gem. #194
    • Stream the reading of the dimensions #192
    • Return nil when a querying a cell that doesn't exist (instead of a NoMethodError) #192, #165
    • Roo::OpenOffice#formula? now returns a Boolean instead of a String or nil #191
    • ➕ Added a less verbose Roo::Base#inspect. It no longer returns the entire object. #188, #186
    • 📝 Memoize Roo::Utils.split_coordinate #180
    • Roo::Base: use regular expressions for extracting headers #173
    • Roo::Base: memoized first_row/last_row first_column/last_column and changed the default value of the sheet argument from nil to default_sheet a0dd800
    • 0️⃣ Roo::Base: changed the order of arguments for to_csv to (filename = nil, separator = ',', sheet = default_sheet) from (filename=nil,sheet=nil) 1e82a21
    • In OpenOffice / LibreOffice, load the content xml lazily. Leave the tmpdir open so that reading may take place after initialize. The OS will be responsible for cleaning it up. adb204b
    • 0️⃣ Lazily initialize @default_sheet, to avoid reading the sheets earlier than necessary. Use the #default_sheet accessor instead. 704e3dc
    • Roo::Base#default_sheet is no longer an attr_reader 704e3dc
    • 💅 In Excelx, load styles, shared strings and the workbook lazily. Leave the tmpdir open so that reading may take place after initialize. The OS will be responsible for cleaning it up. a973237, 4834e20c, e49a1da
    • Change the tmpdir prefix from oo_ to roo_ 102d5fc
    • Accept the tmpdir_root option in Roo::Excelx 0e325b6
    • ♻️ Refactored Excelx#comment? 0fb90ec
    • Refactored Roo::Base#find, #find_by_row, #find_by_conditions. 1ccedab
    • Extended Roo::Spreadsheet.open so that it accepts Tempfiles and other arguments responding to path. Note they require an :extension option to be declared, as the tempfile mangles the extension. #84.

    🛠 Fixed

    • 🖨 Process sheets from Numbers 3.1 xlsx files in the right order. #196, #181, #114
    • 🛠 Fixed comments for xlsx files exported from Google #197
    • 🛠 Fixed Roo::Excelx#celltype to return :link when appropriate.
    • 🛠 Fixed type coercion of ids. #192
    • 🚚 Clean option only removes spaces and control characters instead of removing all characters outside of the ASCII range. #176
    • 🛠 Fixed parse method with clean option #184
    • 🛠 Fixed some memory issues.
    • Fixed Roo::Utils.number_to_letter #180
    • 🛠 Fixed merged cells return value. Instead of only the top-left cell returning a value, all merged cells return that value instead of returning nil. #171
    • 🖐 Handle headers with brackets #162
    • Roo::Base#sheet method was not returning the sheet specified when using either an index or name #160
    • Properly process paths with spaces. #142, #121, #94, 4e7d7d1
    • Disambiguate #open call in Excelx#extract_file. #125
    • 🛠 Fixed that #parse-ing with a hash of columns not in the document would fail mysteriously. #129
    • 🛠 Fixed Excelx issue when reading hyperlinks #123
    • 🛠 Fixed invalid test case #124
    • 🛠 Fixed error in test helper file_diff 56e2e61
    • Stopped inspect from being called recursively. #115
    • 🛠 Fixes for Excelx Datetime cells. #104, #120
    • Prevent ArgumentError when using find #100
    • Export to_csv converts link cells to url #93, #108

    ✂ Removed

    • Roo::Excel - Extracted to roo-xls gem. a7edbec
    • Roo::Excel2003XML - Extracted to roo-xls gem. a7edbec
    • Roo::Google - Extracted to roo-google gem. a7edbec
    • ♻️ Roo::OpenOffice::Font - Refactored into Roo::Font
    • ✂ Removed Roo::OpenOffice.extract_content a74157a
    • ✂ Removed OpenOffice.process_zipfile 835368e
    • Roo::OpenOffice#comment?
    • 🚚 Roo::ZipFile - Removed the Roo::ZipFile abstraction. Roo now depends on rubyzip 1.0.0+ d466950
    • SpreadSheet::Worksheet - Extracted to roo-xls gem. a7edbec
    • Spreadsheet - Extracted to roo-xls gem. a7edbec
  • v1.13.2

    December 23, 2013

    🛠 Fixed

    • 🛠 Fix that Excelx link-cells would blow up if the value wasn't a string. Due to the way Spreadsheet::Link is implemented the link text must be treated as a string. #92
  • v1.13.1

    December 23, 2013

    🛠 Fixed

    • 🛠 Fix that Excelx creation could blow up due to nil rels files. #90
  • v1.13.0

    December 05, 2013

    🔄 Changed / Added

    • 👌 Support extracting link data from Excel and Excelx spreadsheets, via Excel#read_cell() and Excelx#hyperlink(?). #47
    • 👌 Support setting the Excel Spreadsheet mode via the :mode option. #88
    • 👌 Support Spreadsheet.open with a declared :extension that includes a leading '.'. #73
    • Enable file type detection for URI's with parameters / anchors. #51

    🛠 Fixed

    • 🛠 Fix that CSV#each_row could overwrite the filename when run against a uri. #77
    • 🛠 Fix that #to_matrix wasn't respecting the sheet argument. #87