Clash with RubyXL

[agentydragon]

Hi. I just tried to use this gem along with RubyXL in a project, and saving an Excel document with RubyXL failed on line 140 in (rubyXL gem path)/lib/rubyXL/writer/styles_writer.rb (https://github.com/gilt/rubyXL/blob/master/lib/rubyXL/writer/styles_writer.rb#L140). I haven't investigated too deep, but it would be nice if those two gems could coexist peacefully.

[olbrich]

Please try the following:

• remove 'ruby-units' from your Gemfile and make sure it's not being required anywhere
• verify that everything works fine
• require 'mathn'
• repeat tests
• If the problem returns, then the RubyXL gem is not compatible with 'mathn'. Please file an issue with them to correct the problem.

I am also working on setting up a branch that attempts to work without 'mathn', but it will have some limitations.

[agentydragon]

OK, the tests break if I remove 'ruby-units' and require 'mathn'. However, the errors are different, so I think that 'ruby-units' and 'rubyXL' aren't incompatible just because of the 'mathn' dependency. The code in 'rubyXL' seems to accidentally call Object#u defined in 'ruby-units' - I would guess there's some missing_method magic that doesn't expect such methods to exist. Thanks, I'll report this error to rubyXL maintainers as well and see what they can do about it.

By the way, this is the error I get when I require 'mathn':

    NoMethodError: undefined method `chr' for (1691/26):Rational
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/cell.rb:390:in `block in convert_to_cell'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/cell.rb:379:in `upto'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/cell.rb:379:in `convert_to_cell'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/writer/worksheet_writer.rb:33:in `block (2 levels) in write'
    /usr/lib/ruby/gems/2.0.0/gems/nokogiri-1.6.0/lib/nokogiri/xml/builder.rb:391:in `call'
    /usr/lib/ruby/gems/2.0.0/gems/nokogiri-1.6.0/lib/nokogiri/xml/builder.rb:391:in `insert'
    /usr/lib/ruby/gems/2.0.0/gems/nokogiri-1.6.0/lib/nokogiri/xml/builder.rb:375:in `method_missing'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/writer/worksheet_writer.rb:19:in `block in write'
    /usr/lib/ruby/gems/2.0.0/gems/nokogiri-1.6.0/lib/nokogiri/xml/builder.rb:293:in `initialize'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/writer/worksheet_writer.rb:18:in `new'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/writer/worksheet_writer.rb:18:in `write'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/workbook.rb:205:in `block (3 levels) in write'
    /usr/lib/ruby/gems/2.0.0/gems/rubyzip-0.9.9/lib/zip/zip_streamable_stream.rb:12:in `get_output_stream'
    /usr/lib/ruby/gems/2.0.0/gems/rubyzip-0.9.9/lib/zip/zip_file.rb:159:in `get_output_stream'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/workbook.rb:205:in `block (2 levels) in write'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/workbook.rb:203:in `each'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/workbook.rb:203:in `each_with_index'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/workbook.rb:203:in `block in write'
    /usr/lib/ruby/gems/2.0.0/gems/rubyzip-0.9.9/lib/zip/zip_file.rb:90:in `open'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/workbook.rb:122:in `write'
    (controller code, etc.)

And this is what I get if I require 'ruby-units':

    ArgumentError: Invalid Unit Format
    /usr/lib/ruby/gems/2.0.0/gems/ruby-units-1.4.4/lib/ruby_units/unit.rb:318:in `initialize'
    /usr/lib/ruby/gems/2.0.0/gems/ruby-units-1.4.4/lib/ruby_units/unit.rb:352:in `initialize'
    /usr/lib/ruby/gems/2.0.0/gems/ruby-units-1.4.4/lib/ruby_units/array.rb:7:in `new'
    /usr/lib/ruby/gems/2.0.0/gems/ruby-units-1.4.4/lib/ruby_units/array.rb:7:in `to_unit'
    /usr/lib/ruby/gems/2.0.0/gems/ruby-units-1.4.4/lib/ruby_units/object.rb:9:in `Unit'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/writer/styles_writer.rb:140:in `block (5 levels) in write'
    /usr/lib/ruby/gems/2.0.0/gems/nokogiri-1.6.0/lib/nokogiri/xml/builder.rb:391:in `call'
    /usr/lib/ruby/gems/2.0.0/gems/nokogiri-1.6.0/lib/nokogiri/xml/builder.rb:391:in `insert'
    /usr/lib/ruby/gems/2.0.0/gems/nokogiri-1.6.0/lib/nokogiri/xml/builder.rb:375:in `method_missing'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/writer/styles_writer.rb:131:in `block (4 levels) in write'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/writer/styles_writer.rb:127:in `upto'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/writer/styles_writer.rb:127:in `block (3 levels) in write'
    /usr/lib/ruby/gems/2.0.0/gems/nokogiri-1.6.0/lib/nokogiri/xml/builder.rb:391:in `call'
    /usr/lib/ruby/gems/2.0.0/gems/nokogiri-1.6.0/lib/nokogiri/xml/builder.rb:391:in `insert'
    /usr/lib/ruby/gems/2.0.0/gems/nokogiri-1.6.0/lib/nokogiri/xml/builder.rb:375:in `method_missing'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/writer/styles_writer.rb:126:in `block (2 levels) in write'
    /usr/lib/ruby/gems/2.0.0/gems/nokogiri-1.6.0/lib/nokogiri/xml/builder.rb:391:in `call'
    /usr/lib/ruby/gems/2.0.0/gems/nokogiri-1.6.0/lib/nokogiri/xml/builder.rb:391:in `insert'
    /usr/lib/ruby/gems/2.0.0/gems/nokogiri-1.6.0/lib/nokogiri/xml/builder.rb:375:in `method_missing'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/writer/styles_writer.rb:22:in `block in write'
    /usr/lib/ruby/gems/2.0.0/gems/nokogiri-1.6.0/lib/nokogiri/xml/builder.rb:293:in `initialize'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/writer/styles_writer.rb:21:in `new'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/writer/styles_writer.rb:21:in `write'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/workbook.rb:145:in `block (2 levels) in write'
    /usr/lib/ruby/gems/2.0.0/gems/rubyzip-0.9.9/lib/zip/zip_streamable_stream.rb:12:in `get_output_stream'
    /usr/lib/ruby/gems/2.0.0/gems/rubyzip-0.9.9/lib/zip/zip_file.rb:159:in `get_output_stream'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/workbook.rb:145:in `block in write'
    /usr/lib/ruby/gems/2.0.0/gems/rubyzip-0.9.9/lib/zip/zip_file.rb:90:in `open'
    /usr/lib/ruby/gems/2.0.0/gems/rubyXL-1.2.10/lib/rubyXL/workbook.rb:122:in `write'
    (controller code, etc.)