To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107710 Issue #|107710 Summary|Shift+F4 Relative/Absolute references broken in edit l |ine Component|Spreadsheet Version|OOo 3.1.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|ftack
------- Additional comments from ft...@openoffice.org Wed Dec 16 08:50:34 +0000 2009 ------- While in cell editing mode, Shift+F4 is supposed to change the reference where the cursor is located between relative and absolute modes. In Calc, this only works now and then To reproduce the issue In A1 and B1, put values In C3, type =sum(, use arrow keys to select A1, then comma, then arrow keys to select B1. Press Shift+F4: nothing happens. Expected behaviour: B1 changes to $B$1, and on subsequent presses to B$1, etc. When using ; instead of , as delimiter, it works. However, on my system (locale US English) Calc automatically converts the ; to , when entering the formula. It should therefore work with the comma as well. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org