Download it now!
Bug 124646 - EDITOR ODT Writer inserts all data from filtered range
Summary: EDITOR ODT Writer inserts all data from filtered range
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: László Németh
Whiteboard: target:6.3.0
Depends on:
Reported: 2019-04-10 08:43 UTC by NISZ LibreOffice Team
Modified: 2019-08-16 17:05 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Spreadsheet with filtered range (9.14 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-04-10 08:44 UTC, NISZ LibreOffice Team
Screenshot (107.68 KB, image/png)
2019-04-10 08:52 UTC, NISZ LibreOffice Team

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2019-04-10 08:43:50 UTC
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 inserts all data from filtered range.

Expected Results:
LibreOffice Writer should insert the results of filtering.

Reproducible: Always

User Profile Reset: No

Additional Info:
LibreOffice details:
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
Comment 1 NISZ LibreOffice Team 2019-04-10 08:44:27 UTC
Created attachment 150651 [details]
Spreadsheet with filtered range
Comment 2 NISZ LibreOffice Team 2019-04-10 08:52:16 UTC
Created attachment 150652 [details]
Comment 3 Commit Notification 2019-04-10 15:16:27 UTC
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 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.
Comment 4 László Németh 2019-04-10 15:17:52 UTC
@Gellért: many thanks for the important feedback related to this feature.
Comment 5 Gellért Gyuris 2019-04-10 15:30:23 UTC
Thanks for this feature!