Apache OpenOffice (AOO) Bugzilla – Issue 106162
naming matrix deletes top-left element
Last modified: 2013-12-06 11:13:50 UTC
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.
Created attachment 65521 [details] Spreatsheet that shows the error
I think a have an reproducible work-flow now. 1. Take a spreadshead document and enter some values in a range, for example 1 2 3 4 5 6 2. Select the range and define a name for it, for example matA. 3. Enter the formula =matA in a cell and finish it as matrix formula with ctrl-shift-enter. You get a range which is selected. Do not leave or deselect this selection! 4. Define a name for the still selected range, for example matB. 5. Enter the formula =matB as matrix formula in some cell. Notice that the upper-left cell is empty. Saving and reloading solves the problem, so an example document is useless.
See issue 101155 for another scenario with empty cell.
As given in description. AOO410m1(Build:9750) - Rev. 1543812 Rev.1543812 Win 7