Apache OpenOffice (AOO) Bugzilla – Issue 94192
Window > Freeze: Referencing cells to another sheet via keyboard doesn't work
Last modified: 2013-01-29 21:50:23 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 OpenOffice.org 2.4.0.
Can confirm this for OOo300m9 9358 SuSE Linux 10.1
confirm on OOO300m9 under Windows XP Pro SP3 and Windows 2000.
Confirmed with DEV300m50, Win Vista, Linux Inserting reference fails in the described way only if Windows - Freeze is enabled.