Bug 118676 - Calc filtered table Paste special as RTF into Writer pastes also hidden rows
Summary: Calc filtered table Paste special as RTF into Writer pastes also hidden rows
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 126975 (view as bug list)
Depends on:
Blocks: RTF-Paste
  Show dependency tree / graph
 
Reported: 2018-07-10 18:07 UTC by Timur
Modified: 2021-05-07 10:10 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Test ODS (9.35 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-07-10 18:07 UTC, Timur 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Timur 2018-07-10 18:07:41 UTC 
Created attachment 143433 [details]
Test ODS

1. Open Calc table with filtered cells like attached
2. Copy header and filter cells like A1:B3
3. Open new Writer document
4. Edit - Paste special - RTF

Expected: only filtered rows are pasted in table. 
Experienced: also hidden rows are pasted if within selected rows
Comment 1 Xisco Faulí 2018-07-13 12:10:11 UTC 
Reproduced in

Version: 6.2.0.0.alpha0+
Build ID: dbf8ad9bc385411c349095dfa66345464b4215d6
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group threaded

I think this issue should be change to become an enhancement.
If LibreOffice detects there are hidden cells, a dialog should be prompted asking the user whether to paste them or not...
Comment 2 Timur 2018-07-13 15:10:12 UTC 
You may be right. Dialog asking the user whether to paste them or not, with the option "do not ask again". Only it's a little bit harder to implement. 

Workaround: 
Copy header and filter cells like A1:B3
Paste in Calc - it will paste filtered rows only
Copy pasted cells
Paste in Writer.
Comment 3 b. 2020-05-18 11:49:27 UTC 
checked with 7.0.0.0.a1+: 

as well ctrl-v as 'rtf' fail, 

copy into a table in writer holds, #124646, #127911

Version: 7.0.0.0.alpha1 (x64)
Build ID: 6a03b2a54143a9bc0c6d4c7f1...
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI: en-US
Calc: threaded
Comment 4 NISZ LibreOffice Team 2021-05-07 10:10:02 UTC 
*** Bug 126975 has been marked as a duplicate of this bug. ***