quote: Absolute reference is set to Shift+F4 (because F4 is set to Data Sources). This is quite annoying since F4 is the STANDARD key since Lotus 123... unquote Above quote is from http://ask.libreoffice.org/en/question/9898/asbolute-cell-reference-shortcut-key/?answer=9900#post-id-9900 I do feel the same and just changed the key allocation my self. However, it would avoid a lot of frustration and questions in AskLibO if the the key allocation could be changed to F4= absolute/relative reference and Shift-F4 = Datasource. Operating System: Windows XP Version: 3.6.4.3 release
Agreed. The F4 shortcut to toggle through relative and absolute reference options has been the standard for a long time, supported by many different spreadsheet programs. LibreOffice should retain this behavior.
As a Professor trying to show students the legitimacy of Libre Office as an alternative to expensive office application solutions, having this kind of inconsistency adds a completely unnecessary perception of incompatibility which has to be explained away or compensated for. This minor change will go a long way to help bring along converts!
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.