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 126.96.36.199.alpha0+ inserts all data from filtered range.
LibreOffice Writer 188.8.131.52.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!