Issue 92332 - copy and paste issue with filtered spreadsheets
Summary: copy and paste issue with filtered spreadsheets
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.4.1
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 104507 (view as issue list)
Depends on:
Blocks:
 
Reported: 2008-07-31 12:25 UTC by neilwalkinshaw
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
attachment (9.35 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-08-22 10:03 UTC, chl207 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description neilwalkinshaw 2008-07-31 12:25:23 UTC 
I filter a spreadsheet to only display a subset of the rows, copy a column of
cells, and then paste-transpose these cells in another sheet. However, when the
pasted cells are unfiltered, i.e. include those cells that should have been
filtered out. 

A work-around is to paste the cells without doing the transpose, then re-copying
those cells and then doing the paste-transpose.

Ideally this shouldn't be necessary.
Comment 1 neilwalkinshaw 2008-07-31 12:32:41 UTC 
That should be:

However, the pasted cells are unfiltered. Not "...when the pasted cells are
unfiltered..."
Comment 2 chl207 2008-08-22 10:00:59 UTC 
On WinXP, DEV300_m28,the problem exists.
Reproduce Steps:
1.Open the example file "Example.ods" or create a new calc document;
2.Filter the data "B3:B16", and then Copy the filtered data cells;
3.Select a cell in the same sheet or another sheet,right click—Paste 
Special,in Paste Special dialogue, select "Transpose",click OK.
the paste result is as the original description.
Comment 3 chl207 2008-08-22 10:03:07 UTC 
Created attachment 55937 [details]
attachment
Comment 4 frank 2008-08-22 11:26:58 UTC 
Hi Eike,

maybe it's yours.

Frank
Comment 5 ooo 2008-08-22 11:32:57 UTC 
Well, maybe.
Comment 6 Rainer Bielefeld 2009-08-26 06:31:06 UTC 
*** Issue 104507 has been marked as a duplicate of this issue. ***
Comment 7 Marcus 2017-05-20 11:11:28 UTC 
Reset assigne to the default "issues@openoffice.apache.org".