To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=106162
Issue #|106162
Summary|naming matrix deletes top-left element
Component|Spreadsheet
Version|DEV300m62
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|code
Assigned to|spreadsheet
Reported by|regina
------- Additional comments from reg...@openoffice.org Wed Oct 21 19:19:51
+0000 2009 -------
Open the attached document. The cell range A2:D6 is named MatrixA. The cell
range A9:E12 contains the array function {=TRANSPOSE(MatrixA)}.
Mark this cell range A9:E12 and name it, for example MatrixB, either using the
'Name Box' or via Insert>Names>Define.
Scroll up and down to force a screen refresh.
Notice that the cell A9 is empty. It is no screen problem, but the cell is
really empty, although the 'Input line' still shows the formula. Try to
calculate =MMULT(MatrixB;MatrixA) as array function in A14, you will get a
#VALUE! error.
The problem is in naming. If you use the cell ranges directly in the
calculation, it work without problems.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
