Re: matrix operations in 1.2.10



On Wed, Apr 14, 2004 at 10:49:54AM -0400, Allin Cottrell wrote:
I'm tryint to invert a 2x2 matrix in gnumeric 1.2.10.  I enter the
formula

=minverse(C3:D4)

and press Ctrl-Shift-Enter.  I get a scalar result, and the
auto-generated formula bar entry reads

{=minverse(C3:D4)}(1,1)[0][0]
                   ^^^

What am I (or what is gnumeric) doing wrong?

C3:D4 contains

2  4
1  3

You need to select a range the size of the expected result.
Ctrl-Shift-Enter creates an 'array formula' in XL parlance.  It is
not smart enough to dynamicly size itself (nor is XL).  I'd like to
support it one day but it's a tricky problem.



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]