Calc: Transpose Fails if Freeze Rows & Columns Set
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.
Yepp - you need to click into the formula bar before being able to select the range of cells to be transposed. Would consider this a bug - but not of specific function
TRANSPOSE
but selection of a range (perform the same thing forSUM
., etc... - you always need to click into the formula bar before you can select the range)