Apache OpenOffice (AOO) Bugzilla – Issue 7954
Cannot access freezed rows.
Last modified: 2003-09-08 16:55:29 UTC
Place the cursor in a column and then click Window->Freeze, then immediately type = to enter into the current cell. Using the cursor keys, you can move the cursor (by arrows or mouse) to the 'freezed' columns, and they are displayed in the selected cell, but if you use the cursor to move to other cells (by arrows or mouse) that are not frozen they are not shown in the cell you are editing. If however you move the cursor from the selected cell before presseing =, you can select cells that are not frozen, but you cannot select the cells that are frozen by using the arrow keys, but you can using the mouse.
Created attachment 2996 [details] Spreadsheet with freeze problem
Attached spreadsheet shows Window->Freeze when in cell C1. Cannot select cells A1, B1 using arrow keys.
Kitsune, thanks for using and supporting OOo. The behaviour I observed is different from you but the same concept. 1. Freeze a row or column. 2. Select a cell right beside the freezed row or column. 3. Hit "=" 4. Move one step to the freezed row or column. Notice in the cell where the "=" is, the selected cell coordinate is not displayed.
I was able to fully confirm the inability and ability to select cells for the input line by using the arrows and mouse as described in the original sequence by Kitsune. I was also able to confirm most of the steps in the sequence described by PM, except that I found I could select the cells in Step 4 of this sequence if I used the mouse to select the cell. I found that I could enter any of the cells in the spreadsheet, frozen or not, to the input line by using the mouse after deselecting the highlited column just after selecting the freeze function. I performed my tests on OOo 1.0.1 running on win98.
Hi Niklas, 1 4 u Frank
Perhaps Issue 8098 is similar or relates to this one?
Fixed in a future 644 build. Affected source files: sc/source/ui/view/tabview.cxx 1.15 sc/source/ui/view/tabview3.cxx 1.26 sc/source/ui/view/gridwin.cxx 1.37 Issue 8098 doesn't mention formula input, I don't quite understand what is meant there.
set to verified
closed verified