https://bugs.documentfoundation.org/show_bug.cgi?id=71519
--- Comment #13 from Plavozont <[email protected]> --- (In reply to gmolleda from comment #10) > There seem to be two different cases involved here: > > 1) When rows are hidden by filter: > - Pasting into a filtered range may fail with "Cannot insert into > multiple selection". > - However, if only visible cells are explicitly selected before pasting, > the operation works correctly and only affects visible rows. > > 2) When rows are hidden manually: > - Pasting still affects hidden rows, which is inconsistent with the > filtered case. > > This suggests that Calc already supports correct behavior (visible-only > paste), but only when the target range is explicitly defined as visible > cells. > > It would be useful to clarify whether the patch addresses: > - only the "multiple selection" error, or > - also the inconsistency between filtered and manually hidden rows. Inconsistency also matters, because when you paste something and there are hidden rows/cols and you didn't know about it, you may not notice that part of what you pasted is invisible, so there should be a kind of warning to inform about that too (a dialog with options). About "multiple selection" error - pasting only visible data into only visible cells should work both when range is selected and if it's not - the dialog that offers the method of pasting should appear. -- You are receiving this mail because: You are the assignee for the bug.
