Description: According to online help (German) on this page: https://help.libreoffice.org/7.5/de/text/scalc/guide/cellcopy.html It is possible to filter a libreoffice Chart document and perform copying of cells that are now visible (only). But the real life chart displays that "Einfügen auf Mehrfachauswahl nicht möglich" which is completely opposite of what help text describes and makes the whole process totally useless. User ends up stranding not knowing how to proceed. Steps to Reproduce: 1. LO installed per "other information" below, incl. German language interface 2. Open a CALC sheet that has top header line for auto filtering. Sheet has 7 Columns. 3. Using auto filter, use first column to filter lines for one of its entries, so that visible lines now all contain same filtering text in first column. 4. From last column, per dragging select a number of visibly consecutive lines. STRG+C to copy into clipboard. Actual Results: 5. Bug: place mouse cursor in same starting line as with copied data just other column (not column 1) and use STRG+V to paste from clipboard into other column. Error message is shown "Einfügen auf Mehrfachauswahl nicht möglich". Expected Results: 5. The data that was copied into clipboard is entered into other column, starting at same start line in which selected data starts. Only lines are affected by this action that are visible in filtered view, just as help explains. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.5.2.2 (X86_64) / LibreOffice Community Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2 CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.utf8); UI: de-DE Calc: threaded
You can not paste a data block onto filtered rows if the pasted data is larger than the _contiguous_ block of visible rows from the paste-start (because otherwise the target technically would be a multi-selection, hence the message). You can try with any copied cell range not originating from the filtered rows as well, it's not accepted. And no, the help (English: https://help.libreoffice.org/7.5/en-GB/text/scalc/guide/cellcopy.html ) does not say you could paste so. It says you can _copy_ such. Which you then can paste onto (an unfiltered) contiguous cell range. However, it might make sense to allow pasting in this special case if source and target are both the same filtered row range. RFE (request for enhancement). Anyway, the pasted data shall not alter filtered-out rows.