Re: Re: Using logfit on worksheet - please describe thoroughly for a dummy

[Igors Mihailovs <igors mihailovs0 gmail com>]

Hello Jean,
Thank you very much for your help! It would be nice if you also add this to the actual "Help" of "Gnumeric", in case you haven't yet. "Gnumeric" is indeed very practical and convenient for use, personally I like it more than "LibreOffice Calc", partially because of better compatibility with MS Excel file format, partially for its great charting tool and solver.

I submitted the bug - but while I was making a sample worksheet I run onto another one :) 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", "Gnumeric" complained that array XNN:XNN will be split, where XNN:XNN is the array where the output of LOGFIT would be if it were not transposed. So I had to select the full square (5x5 in this case) to be able to use "Delete" key. The bug is not crucial (when I'm aware of it, I understand that I can perform the "transpose" operation in an extra workbook to not corrupt my data), but it seems to me better if I report it, too.

See attachment for sample workbook. Interestingly, when a workbook is saved and then reopened, the array appears to be pasted WITHOUT being transposed.

2012/5/5 Jean Brefort <jean brefort normalesup org>:

> The unreadable characters might be a bug, please file a bug report and
> attach a sample screenshot (or, better, a sample workbook).
>
>
> When you enter an array formula as iut is the case for fitting, you need
> to select the cells which will receive all the results, type the formula
> and then Ctrl+Shift+Enter.
>
>
> Hope this helps,
> Jean
>
> Le samedi 05 mai 2012 à 10:58 +0300, Igors Mihailovs a écrit :
>> Dear helpful people,
>> As LOGFIT function returned regression equation on a chart with some
>> characters unreadable (between a and b, or some parts of them), I
>> tried to use it on worksheet. Help says it should return an array with
>> 5 numerical results. But how can I view these results on a worksheet?
>> Only the 1st one is displayed in the cell where the function is
>> entered. I suppose I should point explicitly to the cells where I want
>> results to appear, but how? I googled a lot but haven't found
>> anything, at least anything I could understand.
>> Many thanks in advance!
>>
>> --
>> Best regards,
>> Igors
>> _______________________________________________
>> gnumeric-list mailing list
>> gnumeric-list gnome org
>> http://mail.gnome.org/mailman/listinfo/gnumeric-list
>
>

-- 
With best regards,

Igors

Attachment: logfit_possible_bugs.gnumeric
Description: Binary data