1 Jun 2005 01:45
[sc-issues] [Issue 50154] New - Numerical stability issue with the MINVERSE() function
<masato12610 <at> openoffice.org>
2005-05-31 23:45:10 GMT
2005-05-31 23:45:10 GMT
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50154 Issue #:|50154 Summary:|Numerical stability issue with the MINVERSE() |function Component:|Spreadsheet Version:|OOo 1.1.4 Platform:|All URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|programming Assigned to:|spreadsheet Reported by:|masato12610 ------- Additional comments from masato12610 <at> openoffice.org Tue May 31 16:45:10 -0700 2005 ------- I believe there is an issue with the numerical stability of the MINVERSE worksheet function. From matrix algebra, if A is a square matrix (n rows and n columns) and is not singular, then a matrix inverse "Inv(A)" exists, such that for matrix multiplication A*Inv(A) = I, where I is the n-by-n identity matrix, i.e., the main diagonal of I contains ones and all other elements of I contain zero. Attached are Excel and Calc workbooks that illustrate the issue. The Excel workbook appears to work correctly but the Calc workbook shows the issue.(Continue reading)
RSS Feed