Issue 106162 - naming matrix deletes top-left element
Summary: naming matrix deletes top-left element
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 4.1.0-dev
Hardware: PC Windows, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-10-21 20:19 UTC by Regina Henschel
Modified: 2013-12-06 11:13 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Spreatsheet that shows the error (10.10 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-10-21 20:21 UTC, Regina Henschel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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
Win 7