« Changelog History


Roo v2.0.0 Release Notes

Release Date: 2015-04-24 // about 9 years ago

  • ➕ 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