[LRUG] Creating spreadsheets with programmatically formulas baked into them - already done in Ruby?

Chris Adams mail at chrisadams.me.uk
Thu Feb 16 08:12:00 PST 2012

Hi all,

I'm curious about how one might go about generating a downloadable
spreadsheet for Excel or Openoffice, where formulae inside it are
generated server side, depending on what a user has requested
beforehand in a Rails 3 app.

Yeah, it *is* a bit of an oddball request, but I figured I can't be
the first person to want to do this, and I already see a few related
gems on rubyforge:


Of these, Roo looks the most promising, but still, generating formulas
seems to be something that isn't implemented yet.


Has anyone else on the list forayed into this territory before? Any
pointers? Or should I run screaming from this problem before it's too



Chris Adams
mob: 07974 368 229
tel: 0207 558 8971
skype: chris.d.adams
twitter: mrchrisadams

More information about the Chat mailing list