Issue 17044 - Multi-sheet paste special with shift down broken
Summary: Multi-sheet paste special with shift down broken
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2003-07-18 05:00 UTC by andree
Modified: 2013-02-07 22:37 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description andree 2003-07-18 05:00:33 UTC
- create new spreadsheet document
- select all three tabs
- enter text 'Row 1' in cell A1
- enter text 'Row 2' in cell A2
- enter text 'Row 3' in cell A3
- highlight row 1 & copy
- highlight row 2 & paste special, select 'Shift cells->Down', click ok

Expected result:
- cell A1 reads 'Row 1', cell A2 read 'Row 1', cell A3 reads 'Row 2', cell A4 
  reads 'Row 3' on all three sheets

Actual (buggy) result:
- cell A1 reads 'Row 1', cell A2 read 'Row 1', cell A3 reads 'Row 2', cell A4 
  reads 'Row 3' only on sheet one
- for sheet 2 and sheet 3 a normal paste has happened replacing 'Row 2' in cell 
  A2 with 'Row 1'; no shifting has occurred for sheet 2 and sheet 3
Comment 1 frank 2003-07-18 10:52:34 UTC
Hi Andree,

this is not broken because it was never implemented in this way. So
it's an Feature request and I set the flags accordingly.

Best regards


Hi Bettina,

1 4 u

Comment 2 andree 2003-07-18 13:07:40 UTC
Hi Frank

Excuse me if I attempt some advocacy from a user prespective. ;-)

If it was never implemented, one shouldn't be able to try doing it.
Therefore, I suggest that paste special be deactivated if more than
one sheet is selected I - ideally before 1.1 goes gold.

Otherwise users may just shoot themselves in the foot without the
slightest warning - especially as (a) undo is broken in this scenario
as well (see issue 17043) and (b) the You Know Who spreadsheet
application acts as expected.

It would be great if you could reconsider.

Best regards
Comment 3 bettina.haberer 2003-07-18 13:50:24 UTC
Hello Andree, thank you for posting this issue. As I am evaluating
features and enhancements, I will reconsider this one.
Comment 4 ace_dent 2008-05-16 02:38:46 UTC Issue Tracker - Feedback Request.

The Issue you raised has the status 'New' pending further action, but has not
been updated within the last 4 years. Please consider re-testing with one of the
latest versions of OOo, as the problem(s) may have already been addressed.
Either use the recent stable version:
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
Comment 5 aziem 2008-05-24 15:15:47 UTC
A similar, simpler feature does not work in OOo 2.4.0 but does work in Excel 2003:

"When she wants to insert a row into all four sheets, I tell her to highlight
the four sheets and the row should automagically be inserted into all of them."

In OOo 2.4.0, the operation is just performed on the single sheet visible.
Comment 6 bettina.haberer 2010-05-21 15:13:07 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".