https://bugs.documentfoundation.org/show_bug.cgi?id=49205
stragu <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
| |.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 <[email protected]> ---
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@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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
