Hi all,

next problem with matrices :(

(All with German local with comma as decimal delimiter)

Fill A1:C3 with
1       2       3
3       6       9
9,1     18      27
Calculate =MINVERSE(A1:C3)

I get
0,00000000-1.#NANE+000  #VALUE! #VALUE!
#NUM!   #NUM!   #VALUE!
#NUM!   #NUM!   #VALUE!

I guess, that the wrong notation in upper, left cell is already tracked in issue 114125. But I think, Calc should not return #NUM! or #VALUE! at all, but Err:502 (illegal argument), because the matrix is singular. The LU decomposition has a zero in the diagonal, so it is possible to detect this case. Excel and Gnumeric return #NUM! in the whole range.

Fill A1:D4 with
1       2       3       4
3       6       9       12
9       18,1    27      36
12,1    24      36      48
Calculate =MINVERSE(A1:D4)

I get in full science notation
-6,809917355371900E+001 -1,652892561983470E+001 0,000000000000000E+000 1,000000000000000E+001 -5,150539867109620E+001 -1,293916112956810E+001 9,999999999999860E+000 -5,177106436424810E-014 1,926351720312250E+015 -6,421172401040780E+014 1,670843776116550E-002 -1,408521303258110E+000 -1,444763790234140E+015 4,815879300780690E+014 -5,012531328320800E+000 -1,443609022556390E+000
which is in two decimal place notation
-68,10  -16,53  0,00    10,00
-51,51  -12,94  10,00   0,00
1926351720312250,00     -642117240104078,00     0,02    -1,41
-1444763790234140,00    481587930078069,00      -5,01   -1,44

If the user sees this result, he will be cautious. But it might be hidden as intermediate part of a larger formula. So the user does not notice that the result is totally wrong. LINEST needs calculating an inverse matrix for the statistics, but does of cause do not show the matrix but the statistics, so that the user might not detect, that the values are wrong. Gnumeric returns #ZAHL! errors and Excel returns the same wrong values as Calc.

Should I test the intermediate results in LINEST to catch this cases and return an error?

kind regards

To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org

Reply via email to