Created attachment 189526 [details] D9 selected, A9 appears When you define a new area database, the previously selected area changes, you have to edit the address in the dialog window. In the example: I've selected cell D9, but cell A9 appears in the dialog window. NB: D9 selected, with light blue background, not simply clicked There is no rule to guess which area will be selected. Sometimes the area I select is what I see in the dialog window.
Thank you for the report! This behaviour started in 7.4. I tested with the cursor on D9, then open Data > Define Range... Result: selection for range moves to A9. Bibisected with linux-64-7.4 repo to first bad commit d14c498f036bf5f6f99503115eeec2a72bd1ba83 which points to core commit: commit 9e2d48b9e04f7ea895fb095699c32ed8a44eb129 author Luboš Luňák Wed Mar 30 11:58:04 2022 +0200 committer Luboš Luňák Thu Apr 28 05:51:53 2022 +0200 reduce Calc's INITIALCOLCOUNT to 1 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/133311 Before that commit, a one-cell selection would be created to populate the field. Bumping the priority as Luboš is not active anymore. Still repro in recent master build: Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 19e9fe7c8c89399753ac1730e1c76378b18418bc CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded
Similarly to bug 158918, if there is data in some columns, the range picker will move to the right-most column with data. Both issues might be fixed together.