Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.org!talisker.lacave.net!lacave.net!not-for-mail From: Will James Newsgroups: comp.lang.ruby Subject: Writing formulas to excel spreadsheet Date: Thu, 19 May 2011 11:22:23 -0500 Organization: Service de news de lacave.net Lines: 14 Message-ID: <267f0e6b73bdfa961dbda489c97c181d@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 1305822152 31566 65.111.164.187 (19 May 2011 16:22:32 GMT) X-Complaints-To: abuse@lacave.net NNTP-Posting-Date: Thu, 19 May 2011 16:22:32 +0000 (UTC) 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: 383476 X-Ml-Name: ruby-talk X-Rubymirror: Yes X-Ruby-Talk: <267f0e6b73bdfa961dbda489c97c181d@ruby-forum.com> Xref: x330-a1.tempe.blueboxinc.net comp.lang.ruby:4768 Hi, everyone. I've just started using ruby a couple of days ago, and I've been using it to read data from text files and write to excel spreadsheets. I also need to be able to write formulas to spreadsheets, but when I open the excel file, the formula is in there without having been evaluated - for example, the cell will appear as "=A1+A58+A114" instead of whatever the value of that sum happens to be. If I click on the cell and hit "enter," the formula will evaluate, but it does not do so automatically. Is there any way to get ruby to force excel to evaluate? Thanks! -- Posted via http://www.ruby-forum.com/.