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

[Chris Adams]

Wow, this does look promising indeed  - thanks Nic!

On 16 February 2012 16:18, nicolas alpi <nicolas.alpi at gmail.com> wrote:
> I've never used it, but it looks like the surpass gem supports formulas
>
> http://surpass.ananelson.com/surpass-manual-0-1-0.pdf
>
> http://surpass.ananelson.com/
>
> Nic
> --
> Nicolas Alpi, web developer, cookies eater
> http://www.wealsodocookies.com
>
>
> On Thu, Feb 16, 2012 at 4:12 PM, Chris Adams <mail at chrisadams.me.uk> wrote:
>>
>> 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:
>>
>> http://rubydoc.info/gems/spreadsheet-excel/0.3.5.1/frames
>> http://rubygems.org/gems/parseexcel
>> http://spreadsheet.rubyforge.org/
>> http://rubygems.org/gems/roo
>>
>> Of these, Roo looks the most promising, but still, generating formulas
>> seems to be something that isn't implemented yet.
>>
>> http://rubydoc.info/gems/roo/1.10.1/frames
>>
>> 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
>> late?
>>
>> Thanks,
>>
>> Chris
>>
>>
>> --
>> Chris Adams
>> mob: 07974 368 229
>> tel: 0207 558 8971
>> skype: chris.d.adams
>> twitter: mrchrisadams
>> _______________________________________________
>> Chat mailing list
>> Chat at lists.lrug.org
>> http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>
>
>
> _______________________________________________
> Chat mailing list
> Chat at lists.lrug.org
> http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>



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