Bug 137519 - Calc is not copying data correctly with AutoFilter
Summary: Calc is not copying data correctly with AutoFilter
Status: RESOLVED DUPLICATE of bug 99913
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: XLSX-Autofilter
  Show dependency treegraph
Reported: 2020-10-16 06:29 UTC by Frants
Modified: 2020-10-17 12:02 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Table in XLSX format. And AutoFilter. (6.62 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-10-16 06:29 UTC, Frants

Note You need to log in before you can comment on or make changes to this bug.
Description Frants 2020-10-16 06:29:35 UTC
Created attachment 166399 [details]
Table in XLSX format. And AutoFilter.

The data in my Calc spreadsheet applies AutoFilter. If you copy data immediately after opening the table, then all data in the range is copied (this is wrong). If you delete or change the filter and then copy the selection, then only the selection is copied (as it should be).
The original table in XLSX format. If the table is saved as an ODS, it works fine.
Comment 1 b. 2020-10-17 12:02:28 UTC
i remember some clue from @erAck? on another issue: 

'*.xlsx doesn't store the filtering situation, but only the outfiltered rows as hidden', or similar, 

that applies here, if you open the filter dropdown on the reloaded sheet all items are checked, but the formerly outfiltered rows are hidden, 

as ex$el itself can do better - tested 2010 - i'd say 'weakness of xlsx implementation in calc' ... 


*** This bug has been marked as a duplicate of bug 99913 ***