How to reproduce: 1. create new spreadsheet 2. merge cells A1 and B1 horizontally 3. focus at B2 4. type the UP key to go the merged cell 5. type the UP key again What was observed actually: Now focus looks on B1, not on the merged cell. (Besides, it is OK if the focus starts at A2 in step 3.) Expected behaviour: Focus should stay the merged cell, as in Excel. Similarly, merging vertically adjacent cells is also affected: 2'. merge cells A1 and A2 vertically 3'. focus B2 4'. type the LEFT key to go the merged cell 5'. type the LEFT key again (then A2 seems selected.) Reproduced with LibO 4.3.3.2 on Debian jessie and LibO 5.0.4.2 on Windows 7. This behaviour was originally suggested and discussed at [1]. [1] http://listarchives.libreoffice.org/ja/discuss/msg03989.html
I reproduce in the following versions. Version: 5.1.0.2 Build ID: ecd3574d51754b043f865cf5bafee286d24db7cc Locale: ja-JP (ja_JP.utf8) Debian GNU/Linux 8.2 (jessie) x86-64
And.., I reproduce in the following versions. Version: 5.0.4.2 Build ID: 2b9802c1994aa0b7dc6079e128979269cf95bc78 Locale: ja-JP (ja_JP.utf8 Debian GNU/Linux 8.2 (jessie) x86-64
Takeshi Abe committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c13226bcc5b298dacfe32340711bdfd4d15d8b3b tdf#97247 Keep focus on merged cell at top-left corner It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Takeshi Abe committed a patch related to this issue. It has been pushed to "libreoffice-5-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c68b65ec5581bafc97155b9ac67f6b542044a171&h=libreoffice-5-1 tdf#97247 Keep focus on merged cell at top-left corner It will be available in 5.1.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.