On Sun, 2012-05-06 at 14:56 +0300, Igors Mihailovs wrote: > When I paste the output of LOGFIT transposing it simultaneously, I did > it in the wrong place and obtained !#REF error (actually, I was going > to paste it as values but forgot to select appropriate option). So I > wanted to delete the erroneous array - and here the bug appeared: when > I selected it and pressed "Delete",
The only way you can transpose while pasting is by using copy and then paste special, so you have to have the output on the sheet first. In that case you cannot overwrite a parts of the array. If you want to have the output of logfit transposed, then rather than using =logfit(...) as an array function, you should be using =transpose(logfit(...)) Andreas -- Andreas Guelzow <[email protected]> _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
