Apache OpenOffice (AOO) Bugzilla – Issue 17044
Multi-sheet paste special with shift down broken
Last modified: 2013-02-07 22:37:16 UTC
Scenario: - 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
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 Frank Hi Bettina, 1 4 u Frank
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 Andree
Hello Andree, thank you for posting this issue. As I am evaluating features and enhancements, I will reconsider this one.
OpenOffice.org 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: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ 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: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
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." <http://www.oooninja.com/2008/05/readers-question-inserting-row-in-four.html> In OOo 2.4.0, the operation is just performed on the single sheet visible.
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".