Issue 94192 - Window > Freeze: Referencing cells to another sheet via keyboard doesn't work
Summary: Window > Freeze: Referencing cells to another sheet via keyboard doesn't work
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.0
Hardware: Unknown All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2008-09-22 21:31 UTC by a_l
Modified: 2013-01-29 21:50 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description a_l 2008-09-22 21:31:06 UTC
When having frozen a row and a column on sheet and then entering a
formula/reference to another sheet via the keyboard the formula is cut down to
'=' instead of something like '=Sheet2.A1'.

Using the function-bar and selecting the cell on the other sheet with the mouse
does work.

How to reproduce:

1. Create an new spreadsheet
2. Go to Sheet2
3. Type somewhere a number, say '100' in cell A1
4. Go back to Sheet1
5. Select cell B2
6. Select 'Window > Freeze' from the menu
7. Type '=' to start a formula
8. Press te keys 'ctrl'+'pagedown' to go to Sheet2
9. Select cell A1
10. Press Enter
11. Notice only having a '=' in the cell

I seems to happen if atleast a column is frozen.

This problem is also to be found in Calc from 2.4.0.
Comment 1 probe1 2008-10-23 23:10:11 UTC
Can confirm this for OOo300m9 9358 SuSE Linux 10.1 
Comment 2 logicdaemon 2008-10-25 09:03:09 UTC
confirm on OOO300m9 under Windows XP Pro SP3 and Windows 2000.
Comment 3 jr 2009-06-14 10:20:11 UTC
Confirmed with DEV300m50, Win Vista, Linux

Inserting reference fails in the described way only if Windows - Freeze is enabled.