Bug Hunting Session
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
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.
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!