[Libreoffice-bugs] [Bug 49205] EDITING: Pasting range into autofiltered fields results in "Insert into multiple selection not possible"

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=49205

stragu <stephane.guillou at member.fsf.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |stephane.guillou at member.fsf
                   |                            |.org
            Summary|EDITING: Pasting to         |EDITING: Pasting range into
                   |autofiltered fields         |autofiltered fields results
                   |                            |in "Insert into multiple
                   |                            |selection not possible"

--- Comment #7 from stragu <stephane.guillou at member.fsf.org> ---
In example document attachment 124421 :

1. Copy B15:B16
2. Paste on A2
Result: "Insert into multiple selection not possible"
I agree that this is not a good error message for this case, as the user has
clearly not selected non-contiguous cell ranges, but only one single cell.

Alternatively:

1. Copy B15:B16
2. Select range A2:A6
3. Paste
Result: this works. Only the visible values are replaced by 2s.
Interestingly, this case seemingly corresponds more to a "multiple selection"
than the previous case.
Note that multi-selecting the same cells one by one instead (with Ctrl +
Click), and pasting, will result in the first error message: "Insert into
multiple selection not possible".

In my opinion, the main issue described here is that the first error message is
not suitable, as there is not multiple selection. A solution would be to
either:
- Use a more relevant error message, along the lines of: "It is unclear from
selected area where the data should be pasted."
- Or, better: the paste should behave exactly like when selecting the range: it
works by bypassing the rows that are not visible.

Tested with:

Version: 7.2.0.0.alpha1+ / LibreOffice Community
Build ID: bb54d6d8241a06a6772052b77b67d6a4f686426c
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64 at 86-TDF, Branch:master, Time:
2021-06-11_20:14:38
Calc: threaded

(Title of report was "EDITING: Pasting to autofiltered fields", so changed to
something more descriptive)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210614/51714232/attachment.htm>