https://bugs.documentfoundation.org/show_bug.cgi?id=155799
--- Comment #1 from ady <adylo811...@gmail.com> --- Currently the title of this bug 155799 is: Selecting merged cells for formula doesn't select the complete merged cell Such sentence might imply that users should be able to select complete merged-cells, as if each merged area should act as one cell. This is an inaccurate description. Users should be able to select _whichever_ range, whether it is (as for attachment 187874): A1 A1:A1 A1:A2 A1:A3 A1:A4 A1:A5 A2:A3 A3:A5 A3:B3 or whichever else. The fact that there are merged cells does not mean that each merged area should act as one cell for the purpose of a function. For instance, each cell within a merged area could still contain different values, not all of them being shown while the range is in merged status. IOW, _if possible_, the improvement should not be limited to entire merged cells (only), but rather to whichever range the user wants to select as argument(s) of a function. Ideally, users should be able to select whichever range is desired, whether by dragging the mouse, or by keyboard, or by typing the relevant range directly in the inputwin formula bar. Attachment 187874 demonstrates that this is not always as easy as it should be. For attachment 187874, manually editing the formula later-on is the only way to select certain ranges as arguments, otherwise not possible for this case. This should be corrected/improved, whichever the desired range selection. The situation might not be exactly the same when the selection is not related to arguments of a function; for example, when selecting a range in order to copy it or to apply an attribute on the selection. -- You are receiving this mail because: You are the assignee for the bug.
