Description: Filtered cell range content inserted from Calc to Writer inserts all data of range without filtering. Steps to Reproduce: 1. Open the attached ODS file in LibreOffice Calc. 2. Select and copy A1:B9 range. 3. Rows 5-7. are filtered with autofilter. 4. Create a new document in LibreOffice Writer. 5. Insert a 2x9 table. 6. Paste the selected range. 7. Notice, that Writer inserts all data from filtered range. Actual Results: LibreOffice Writer 6.3.0.0.alpha0+ inserts all data from filtered range. Expected Results: LibreOffice Writer 6.3.0.0.alpha0+ should insert the results of filtering. Reproducible: Always User Profile Reset: No Additional Info: LibreOffice details: Version: 6.3.0.0.alpha0+ Build ID: 05a8749ee6f251d4b92eecb97763fa1fe94c68c8 CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; Locale: hu-HU (hu_HU); UI-Language: en-US Calc: threaded
Created attachment 150651 [details] Spreadsheet with filtered range
Created attachment 150652 [details] Screenshot
László Németh committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/0c3ac02d8a3c7ea50ae262daf134c28df5c8b343%5E%21 tdf#124646 Don't paste hidden rows of Calc sheets into Writer tables It will be available in 6.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
@Gellért: many thanks for the important feedback related to this feature.
Thanks for this feature!
On Italian Ask site an user pointed out that the bug still exist in version 6.4.1.2 https://ask.libreoffice.org/it/question/234887/bug-errore-in-copiaincolla/ Since when it was fixed in release 6.3 I had tried it and it worked fine, I replied telling him, that this was fixed. But then I tried again with the newest version 6.4.2.2 (on OpenSuse) and I fund that it pasted all the range and not only the filtered cells. The same happens in version 6.4.1.2 (on Windows 10 64bit)
(In reply to Marco Marega from comment #6) @Marco: A similar regression was fixed in Bug 129083, caused by changing the default paste type, and maybe the reported regression is the other consequence of that issue. I'll check it. Thanks for your report, László
repro in 6.2.8.2, filter not respected, norepro in 7.0.0.0.a1+, that copies only the data displayed by the filter, thus -> wfm? pls. recheck!
*** Bug 127911 has been marked as a duplicate of this bug. ***
> norepro in 7.0.0.0.a1+, that copies only the data displayed by the filter, sometimes, and sometimes it copies hidden rows too, as visible :-(
*** Bug 131191 has been marked as a duplicate of this bug. ***
László Németh committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/7720f8cf22718415adb3db2304916581f864f884 tdf#138688 tdf#124646 sw: fix crash at pasting Calc data It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
It works well in 7.1 and 7.2. The previous patch contains an unit test for this bug, to avoid of the future regressions (as was in tdf#129083).
László Németh committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/e7065337630d414bd17e626155fa4e9fc5a2e29d tdf#138688 tdf#124646 sw: fix crash at pasting Calc data It will be available in 7.1.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
László Németh committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/c8d335f9bfa6a6fd0887171e2b51035dcbb42078 tdf#138688 tdf#124646 sw: fix crash at pasting Calc data It will be available in 7.0.5. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.