Issue 106162

Summary: naming matrix deletes top-left element
Product: Calc Reporter: Regina Henschel <rb.henschel>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: 4.1.0-dev   
Target Milestone: ---   
Hardware: PC   
OS: Windows, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Spreatsheet that shows the error none

Description Regina Henschel 2009-10-21 20:19:51 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.
Comment 1 Regina Henschel 2009-10-21 20:21:02 UTC
Created attachment 65521 [details]
Spreatsheet that shows the error
Comment 2 Regina Henschel 2010-07-27 12:28:04 UTC
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.
Comment 3 Regina Henschel 2010-07-27 12:34:15 UTC
See issue 101155 for another scenario with empty cell.
Comment 4 Edwin Sharp 2013-12-06 11:13:50 UTC
As given in description.

AOO410m1(Build:9750)  -  Rev. 1543812
Rev.1543812
Win 7