This FAQ is work in progress. Feel free to add more questions and answers!

• Can axlsx read existing xlsx files?
  • No, axlsx can only generates xlsx files. Have a look at rubyXL instead.

• I'm migrating from axlsx, is there anything that I should look for?

  • caxlsx started with two releases, 2.0.2 and 3.0.0. You should be able to just swap the gems and expect everything to work (*see next question)
  • The 2.0.2 only fixes a ruby dependency constrain, see diff: v2.0.1...v2.0.2
  • The 3.0.0 should be the same as axlsx's 3.0.0.pre, see diff: v3.0.0.pre...v3.0.0 (tags are a bit tangled here)

• I'm migrating from axlsx, and now my application is raising "NameError: uninitialized constant Axlsx". What's wrong?

  • Between version 2.0.1 and 3.0.1, the gem didn't have a Ruby file with the same name as the gem (i.e. caxlsx.rb) which would be loaded when the gem was required. That file was added for version 3.0.1. To make this error go away, either update to a more recent version (>= 3.0.1 should be OK) or add a :require option to your gemfile line: gem 'caxlsx', :require => 'axlsx'

• How can I create right-to-left documents?
  • Use my_worksheet.sheet_view.right_to_left = true (see #97).

• Why does my reference to a cell in a different worksheet not work?
  • Make sure to use the correct syntax (=Sheet1!A1). Eventhough some apps (most notably LibreOffice) may display such references as =Sheet1.A1 you still need to use the original syntax when creating such formulas in Caxlsx.