I just don't get this. If you want results, you save as text. If you want the formula, you save as Gnumeric, XLS, whatever. The results of the formula are dependent on the version, the big-endian status of the machine and the possibly the distribution and the specific hardware you're running on (not to mention some strange interactions). If you really want the results and how they were derived, save two files, one Gnumeric and one text.
So far I haven't seen any use case where you would need the formula and the result in the same place in the same time. Uri David On Feb 11, 2008 8:47 PM, <[EMAIL PROTECTED]> wrote: > There is a common thread in the various posts on "complete installation > package" and results of computations cells. This is that it is sometimes > important to know how a package behaved at some particular point. This is > clearly not very important or relevant for most users, but for some of us > it can be. I don't think it is something I expect the development team to > include as a default, but it would be nice to have easy (or at least > easier) ways to save this kind of information. > > Possibilities? > > - As I'm planning to work on a build-bot for gnumeric (and R), I'm > thinking of looking into a static binary i.e., include everything. Not > what most folk want to have cluttering their hard drive, but maybe OK on > an archive DVD. And also folk with old distros could benefit from such a > binary, though it would be a bit of a heavy download. Has anyone attempted > this? I'd appreciate knowing and also any tips. > > - Possibly a way to save the results cells with the XML. Could a Python > script perhaps do this e.g., copy to an added worksheet or worksheets "as > values"? I'm not a Python programmer, but if someone has something > similar, could probably kludge it. There are definitely times when I could > use such an add-in, and I suspect that it is not terribly complicated to > do things that way, but this approach would double the number of > worksheets. > > Just my 2 cents (here where I'm visiting in Perth WA, that gets rounded to > zero! There's no penny. Sigh.) > > JN > > _______________________________________________ > gnumeric-list mailing list > [email protected] > http://mail.gnome.org/mailman/listinfo/gnumeric-list > _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
