Bug 127911 - Pasting from Calc into a Writer table cell does not respect calc filter
Summary: Pasting from Calc into a Writer table cell does not respect calc filter
Status: RESOLVED DUPLICATE of bug 124646
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.7.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-10-01 17:53 UTC by unbound.si
Modified: 2020-05-18 11:47 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
example (9.43 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-04-15 12:56 UTC, unbound.si
Details

Note You need to log in before you can comment on or make changes to this bug.
Description unbound.si 2019-10-01 17:53:04 UTC
Description:
1 Fill columns A - K with header (single row) and data (cca 400 rows)
2 Select columns A - D and click AutoFilter button
3 Set filters for columns A - D (show cca 10 rows out of 400)
4 Click first cell in D column, press Shift and click last visible cell in H column (multi select)
5 Ctrl +C
6 Create new writer document, insert a 5 column table
7 Click first cell in writer table
8 Ctrl + V -> rows, hidden by calc filter, are pasted into writer table

Steps to Reproduce:
1. Fill columns A - K with header (single row) and data (cca 400 rows)
2. Select columns A - D and click AutoFilter button
3. Set filters for columns A - D (show cca 10 rows out of 400)
4. Click first cell in D column, press Shift and click last visible cell in H column (multi select)
5. Ctrl +C
6. Create new writer document, insert a 5 column table
7. Click first cell in writer table
8. Ctrl + V -> rows, hidden by calc filter, are pasted into writer table

Actual Results:
Cells that are not visible in calc after filter check boxes are pasted into writer table.
Also, on paste, default style is applied to text instead of target cell style.

Expected Results:
Only cells that are still visible in calc after filter check boxes are set by user  should be pasted.


Reproducible: Always


User Profile Reset: No



Additional Info:
Should be trivial to repeat.
Also, on paste, default style is applied to text instead of target cell style.
Comment 1 Oliver Brinzing 2019-10-01 18:06:02 UTC
Can you please check with latest LO Version: 6.3.2.2 ?

the behaviour should have changed with 6.3 release:
https://wiki.documentfoundation.org/ReleaseNotes/6.3/en#Writer

this issue could also be related to:
Bug 126975 - Copy and Paste from Calc to Writer ignores filter when using RTF as target
Comment 2 QA Administrators 2020-03-30 02:32:21 UTC Comment hidden (obsolete)
Comment 3 unbound.si 2020-04-15 12:56:50 UTC
Created attachment 159582 [details]
example
Comment 4 unbound.si 2020-04-15 12:58:17 UTC
Comment on attachment 159582 [details]
example

Reproducible in v6.4.2.2 (x64)
Comment 5 QA Administrators 2020-04-16 03:38:15 UTC Comment hidden (obsolete)
Comment 6 b. 2020-05-18 11:47:20 UTC
repro in 6.2.8.2, filter not respected, 

norepro in 7.0.0.0.a1+, that copies only the data displayed by the filter, 

dup of #124646

pls. recheck!

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