From: mortee <mortee.lists@...>
Date: 2007-10-17T00:30:38+09:00
Subject: Re: Excel Parsing : extract values of cells with formulae

Geeta Sachdeva wrote:
> Does 'roo' gem also evaluate formulas? Because as I mentioned earlier, I 
> also need values of cells which have formulae, aslo some of the cells In 
> the excel refer to different excel files or different sheets in same 
> file.

Roo's home page describes what it can do and what not.

Basically, it states that for cells with formulae in OpenOffice files,
it can return whatever value is saved in the document, without
reevaluating anything. It also says that it doesn't handle formulas in
Excel docs, without explaining whether it means that it can't
recalculate the values just like with OOo, or it is unable to return any
value at all.

mortee