Can anyone else reproduce this?
Libreoffice Calc v 6.2.8.2
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee
OS: Linux 4.15 (Ubuntu 18.04.3)
Steps to reproduce:
- Open a new spreadsheet
- Insert a new spreadsheet (you need a second sheet
to make this fail) - On Sheet2, place a
column of numbers at some random
cell, say, B4:B8 - On Sheet1, select a
random cell, say, C12, and type=transpose(
- On Sheet2, select
the previous column of numbers. - Press
Ctrl-Shift-Enter.
Expected behavior: You should see the column of numbers from sheet2, transposed into a row of numbers on sheet1.
Now to cause the failure:
-
Optionally clear the previous test by undoing the transpose step or start over and get to the step where we enter the transpose() function.
-
Pick some random cell, say C12, and freeze rows/columns at that point. (View->Freeze Rows and Columns)
-
Select a cell in the same column, but not necessarily the same row as the freeze cell. Be sure to select at or below the horizontal split row. In our example, select C12 or below.
-
Type
=transpose(
and select the column from the other sheet as before. Press Ctrl-Shift-Enter.
If you see the same problem I do, you should see
Err:511and the formula will have no parameters.
If others can reproduce it, I’ll happily submit a bug.
- The problem does not occur above the
split line. - The problem does not
occur in cells to the right of the
split line (i.e., column of split +
1) - The problem does not occur in
cells to the left of the split line,
even straddling the split line. - You can split after you enter the
=transpose() function and things behave normally.
) next to the answer.
.