I need to generate Excel documents with Ruby (from Rails) on a Linux machine. I know of Spreadsheet::Excel, but it doesn't support formulas, and uses a pretty old format.
Is there any other option, not necessarily free or open source, that is a bit more powerful?
How about opening a spreadsheet (Spreadsheet::Excel) with the formulae already populated. Entering data into the referenced cells will cause them to display the result.