From: Mike Stephens Newsgroups: comp.lang.ruby Subject: Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Date: Wed, 25 May 2011 11:54:06 -0500 Organization: Service de news de lacave.net Lines: 32 Message-ID: <289bcc19075ef4267e45da0e64f3698c@ruby-forum.com> References: <267f0e6b73bdfa961dbda489c97c181d@ruby-forum.com> <3f9811841b309bc9010c0a84ed85bf8b@ruby-forum.com> <2429f4a7-c967-4a64-8637-ed75f4e5a313@q14g2000prh.googlegroups.com> <03bd9fccf3fedba427f3c8295203e426@ruby-forum.com> NNTP-Posting-Host: bristol.highgroove.com Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Trace: talisker.lacave.net 1306342468 90910 65.111.164.187 (25 May 2011 16:54:28 GMT) X-Complaints-To: abuse@lacave.net NNTP-Posting-Date: Wed, 25 May 2011 16:54:28 +0000 (UTC) In-Reply-To: X-Received-From: This message has been automatically forwarded from the ruby-talk mailing list by a gateway at comp.lang.ruby. If it is SPAM, it did not originate at comp.lang.ruby. Please report the original sender, and not us. Thanks! For more details about this gateway, please visit: http://blog.grayproductions.net/categories/the_gateway X-Mail-Count: 383749 X-Ml-Name: ruby-talk X-Rubymirror: Yes X-Ruby-Talk: <289bcc19075ef4267e45da0e64f3698c@ruby-forum.com> Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!feeder.news-service.com!proxad.net!feeder1-2.proxad.net!feed.ac-versailles.fr!talisker.lacave.net!lacave.net!not-for-mail Xref: x330-a1.tempe.blueboxinc.net comp.lang.ruby:5039 Colin Bartlett wrote in post #1000942: > So I make > some calculations using Ruby (or whatever), and then display the > results on a worksheet page, using formulas to generate some of the > displayed results for the same reasons you give in a later post "it's > good to have the formulas in there, in part so that whoever is viewing > the formulas can follow the process of > how something is derived (without too much effort)". You are using formulae. Will wanted to change the formulae. (Apologies, Will, if I came across as criticising you - that wasn't intended. I fully understand your problem constraints, which were not evident to start with). I'm curious to know why Will would change formulae. If parameters are changing then he could factor those out as values passed in ( a bit like your text file approach). If the data structures are changing (eg variable range sizes) he could let Excel sort that out at run time. Maybe you could tell us more, Will? As regards to VBA, personally - for purity - I would aim to avoid it as it shouldn't add any functionality you couldn't achieve by using a combination of Ruby and Excel. To avoid being flamed yet again, I do appreciate that this assumes you are running Ruby in the presence of Windows and Excel. If you want to create an Excel sheet on a non-Windows platform, your options are reduced. -- Posted via http://www.ruby-forum.com/.