I am a novice at Gnumeric so I need help. I have an array in a Gnumeric sheet, let's call it B1:K50.
I want to do numeric operations on *all* the elements in this array. Firstly, I highlight the array. (But one cell seems to still be more 'active' than the others, it is white while the others are blue. It is usually B1. Why is that? I want my formula applied to *all* the cells. How do I ensure this?). One kind of operation I want to do is like this: =product((a-B1:K50)*(b-B1:K50)) where a,b are constants and are integers as are the elements in B1:K50. Then I type Ctrl-Shift-Enter (as stated in the manual). All that happens is that I get text in another cell like A52 (or just anywhere, usually in A) which says things like #VALUE? or #NAME? But I nothing happens to the elements in my array. Can anyone advise me what to do? Thanx if you can // RobertB
_______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
