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.
LibreOffice Writer 22.214.171.124.alpha0+ inserts all data from filtered range.
LibreOffice Writer 126.96.36.199.alpha0+ should insert the results of filtering.
User Profile Reset: No
Build ID: 05a8749ee6f251d4b92eecb97763fa1fe94c68c8
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win;
Locale: hu-HU (hu_HU); UI-Language: en-US
Created attachment 150651 [details]
Spreadsheet with filtered range
Created attachment 150652 [details]
László Németh committed a patch related to this issue.
It has been pushed to "master":
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:
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 188.8.131.52
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 184.108.40.206 (on OpenSuse) and I fund that it pasted all the range and not only the filtered cells. The same happens in version 220.127.116.11 (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 18.104.22.168, filter not respected,
norepro in 22.214.171.124.a1+, that copies only the data displayed by the filter,
thus -> wfm?
*** Bug 127911 has been marked as a duplicate of this bug. ***
> norepro in 126.96.36.199.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. ***