On Wed, 2011-08-17 at 18:29 +0200, Frederic Parrenin wrote: > I would like to multiply two matrices in Gnumeric. > The first one has cells without any content. > The second one has all its cells with content. > > > When I do the multiplication, the cells without content are used as if > '0' was placed in these cells. > That is, the multiplication of a cell without content with a cell with > content is '0'. > But in this case I would like the resulting cell to not have any > content. > > > Do you know of a way to circumwent this problem?
Assuming the blank is in the first row of the first matrix, matrix multiplication will use this entry to calculate each entry in the first row of the result, so you want all of those entries to be blank? In other words if you have to 10 by 10 matrices and one entry of each row of the first matrix is blank do you really want the resulting matrix to be completely blank? If that is the case you cannot use the MMULT function but need to define your own operation. Andreas > -- Andreas Guelzow <aguel...@pyrshep.ca> _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
