Description: Found an interesting bug in the latest (6.0.5.2) and previous (6.0.4.2) LibreOffice Calc on MacOS 10.13.6. It may have occurred in earlier releases in the 6.x branch, but I haven't had the occasion to test those. I've not tried in other operating systems. When selecting cells in a filtered table and copying them to the clipboard, I would normally expect only the selected visible cells to be copied. However, what I see is that all cells in the range (including cells filtered out based on my filter) are copied as well, if I view the clipboard directly as plain text. What is actually pasted seems to depend on the target application, however. Other LibreOffice apps get only what I've selected, as do other competing office applications. Plain text editors, on the other hand, get the whole range (exactly what's in the clipboard). It may be the exact object copied to the clipboard contains the whole range with certain metadata indicating to compatible apps what should be shown (which would allow copying the whole range with the filter in place between spreadsheets), but this would seem to be a counter-intuitive behavior, and it's certainly a new behavior. In the 5.x branch of LibreOffice the expected behavior (only visible selected cells are copied) occurs. Interestingly, with some external text editors (TextMate, for example) I can select the visible cells with the mouse, then drag-and-drop paste into the editor exactly the cells you have selected, but that operation doesn't use the MacOS clipboard. Steps to Reproduce: 1. Create a multi-column, multi-row spreadsheet with a header row. For example: Number,Day one,Monday two,Monday three,Wednesday four,Friday five,Tuesday six,Monday 2. Filter the sheet so only rows with "Monday" in the Day column are shown. 3. Select the now visible cells from the Number column: one two six 4. Select Edit -> Copy or press command+C 5. Open a program that can receive text that isn't part of Libre Office, such as Text Edit. 6. Paste Actual Results: Observe that you jut pasted: one two three four five six Expected Results: What should have been pasted: one two six Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: I'm viewing the clipboard pre-paste with an app called Pastebot, which stores clipboard history beyond the current clipboard and lets you view or perform actions on the current clipboard. It does not modify the clipboard until instructed to.
No repro with Version: 6.2.0.0.alpha0+ Build ID: d11313f341d1d9a9c73c736932441a89d5292e37 CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3; and gedit
No repro with Version: 6.0.5.2 Build ID: 1:6.0.5~rc2-0ubuntu0.16.04.1~lo1 CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3; Locale: fr-FR (fr_FR.UTF-8); Calc: group threaded Best regards. JBF
No repro with Version: 6.0.5.2 Build ID: 54c8cbb85f300ac59db32fe8a675ff7683cd5a16 Threads CPU : 4; OS : Mac OS X 10.13.6; UI Render : par défaut; Locale : fr-FR (fr_FR.UTF-8); Calc: group and copy/pasting filtered content to TextWrangler text editor
Reproduced with Version: 6.0.5.2 Build ID: 54c8cbb85f300ac59db32fe8a675ff7683cd5a16 Threads CPU : 4; OS : Mac OS X 10.13.6; UI Render : par défaut; Locale : fr-FR (fr_FR.UTF-8); Calc: group and Apple Notes 4.5 (876.1) Confirming that the behaviour is dependent on the target application.
Created attachment 143818 [details] sample file
Reproduce it back to LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
*** Bug 125734 has been marked as a duplicate of this bug. ***
Repro 7.2+ Windows with copy to MS Excel. (not to Notepad++).
*** Bug 146709 has been marked as a duplicate of this bug. ***
LibreOffice puts a lot of formats into the clipboard. Some of them have all rows, some of them exclude the filtered rows. It depends on the use case, what is the best suitable format. In Excel you can select 'SYLK' or 'DIF' and you get all rows or you select 'HTML' and the filters rows are excluded, for example. If the decision were to only use formats, which exclude the filters rows, would that really fit to all used cases?
(In reply to Regina Henschel from comment #10) > LibreOffice puts a lot of formats into the clipboard. There is at least a documentation issue.
I did some research with the example file about paste results: Calc puts copied data to the clipboard in various formats, and some are filtered, some are not. External applications (even Writer) may or may not choose a filtered one by default. Calc default paste: filtered. Writer default paste: not filtered (result is a table) Impress default paste: not filtered Notepad default paste: filtered Notepad++ default paste: filtered Excel 16 default paste: not filtered Word 16 default paste: filtered (result is a table) Pasting in Writer with all the Paste special options, results in: LO spreadsheet: filtered (result is OLE object) DDE Link: unfiltered HTML: filtered Rich text formatting (RTF): unfiltered Rich text formatting (Richtext): unfiltered Unformatted text: filtered Graphics Device Interface Metafile (GDI): filtered Bitmap image: filtered Pasting in Excel has some more options on top of these: PNG: filtered Unformatted text (TSV-Calc): filtered Data Interchange Format (DIF): unfiltered For comparison, Excel -> Word (2016 in my case) paste supports the following formats: Default: filtered Special, Excel Worksheet Object: filtered Special, RTF: filtered Special, Unformatted text: filtered Special, Bitmap: filtered Special, EMF: filtered Special, HTML: filtered Special, Unformatted Unicode Text: filtered So all in all, we may say that in case of spreadsheet to text editor it makes sense to change the relevant formats - in our case, RTF. I'm unsure about the "DDE Link" format, may make sense to keep as-is, given it's kinda rarely used. Another interesting comparison, Excel -> PowerPoint results in the following: Default: filtered Special: Excel Worksheet object: filtered Special: HTML: filtered Special: RTF: Filtered Special: Unformatted text: filtered Special: EMF: filtered Special: WMF: filtered Special: DIB: filtered Special: Bitmap: Filtered And Calc -> Impress: Default paste: unfiltered Special: LO spreadsheet: filtered Special: GDI: filtered Special: BMP: Filtered Special: HTML: crash (oops... I'll file a separate one for this) Special: Unformatted: Filtered Special: Rich Text Format (RTF): Unfiltered Special: Rich text formatting (Richtext): Unfiltered (also why do we even need 2 RTF paste formats?)