Re: gnumeric XML doesn't show result of formula

["Andreas J. Guelzow" <aguelzow pyrshep ca>]

On Mon, 2008-02-04 at 18:32 -0500, Allin Cottrell wrote:
> On Sun, 3 Feb 2008, John Machin wrote:
>
> (about printing the evaluated result of a formula into 
> a spreadsheet file, as well as the formula itself)
>
> > The object of the exercise is to be able to extract data from whatever 
> > spreadsheet format is presented:
> > * without requiring the originator to save it as a particular format
> > * without requiring the extractor to open it and save it as another format
> > * without requiring the presence of Gnumeric/OOo Calc/Excel on the 
> > extracting machine.
>
> I think this is reasonable.  A case in point that I know of is the 
> econometrics program, gretl.  gretl can read a variety of formats 
> including gnumeric XML, but it can't do anything with gnumeric 
> files that use formulas: it's easy to read XML with libxml2, but 
> not so easy to replicate gnumeric's calculation apparatus.
>
> Gnumeric is out of line with other spreadsheet programs in this 
> respect.  (In most respects gnumeric is better than the others, 
> but not this one.)

Gnumeric support an xml file formats that contains the values (Open
Document Format) and an xml file format that does not. Yes some users
may like to access the values in the xml file but others would surely
prefer not to have those (for them) unnecessarily bloated files. 

Andreas 
-- 
Andreas J. Guelzow <aguelzow pyrshep ca>