Re: 3D or 4D spreadsheet

[Frederic Parrenin <parrenin gmail com>]

> Gnumeric already supports 3D formula: =sum(Sheet1:Sheet3!A1:C3) is a
> valid formula, summing the contents of a cube of cells three columns
> wide, three columns high, and three worksheets deep.

Thanks for the information, I did not know that.
However, it seems there is a bug.
If I enter your formula, place 1 in Sheet2!A1, the result is 1.
Then if I move Sheet3 before Sheet1, the result is still 1.
Forcing the recalc fixes it.

> Note that there isn't a point-and-click way of entering these formula,
> you've got to type them in by hand (there's a feature request in
> bugzilla for being able to select multiple worksheets, which is what
> you'd need to this).
>
> I've got no idea what a 4D formula would look like, or how you'd
> arrange the data in a spreadsheet.  What were you thinking about for
> this one?

Cells reference could be of the form X1Y3Z2T5.
Of course you can view in a screen only 2D slices of this hyper-cube.
You could select which pair of axes you want to view, e.g. (X,Y).
Then you could move the other 2 variables (Z and T in this case) using
2 cursors.

Best,

Frédéric



> - olly
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> https://mail.gnome.org/mailman/listinfo/gnumeric-list



-- 
http://parrenin.frederic.free.fr/