Issue 29849

Summary:	multi sheet special paste troubles
Product:	Calc	Reporter:	bettlerthomas <bettlertho>
Component:	ui	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	davea0511, issues
Version:	OOo 1.1.1
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	FEATURE	Latest Confirmation in:	---
Developer Difficulty:	---

Description bettlerthomas 2004-06-03 22:39:19 UTC

I get an unexpected reaction of ocalc... 
 
Steps to reproduce 
0. Talking about multiple sheet with numerical datasets 
1. Copy a region of a single sheet (say the parameter "size of area") 
2. you like to divide the parameter "individuals" by "size of area" on twenty other sheets (each time 
same posistion) to get values "individuals per squaremile" 
you do a special paste operation for the marked twenty sheets> paste numbers, divide 
3. what you get is not what you might expect 
 
You get on all the sheet the same numbers, so division is performed only on the active sheet and 
these values are inserted for all the others. Instead I'd like the perform the division on all the marked 
sheets.

Comment 1 bettlerthomas 2004-06-03 22:57:56 UTC

oh, sorry i just didn't look right!!!!! 
 
on the inactive but marked sheets paste is performed just without division. 
 
just a detail. so the error still exists.

Comment 2 frank 2004-06-04 10:15:01 UTC

Hi Bettina,

one for you.

Frank

@bettlertho

This is not a bug.

Frank

Comment 3 bettina.haberer 2010-05-21 15:00:34 UTC

To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".

Comment 4 davea0511 2011-06-07 13:22:15 UTC

"you do a special paste operation for the marked twenty sheets"

Please correct me if I'm wrong but by "marked twenty sheets" I assume you mean you've simultaneously selected twenty sheets (holding down the CTRL button which clicking each tab), and then did the paste operation on the one sheet, thereby affecting all the other sheets.

Although the result was not the behavior you expected, IMHO you shouldn't be able to simultaneous edit multiple sheets at all whatsoever as it stealthily (and insidiously I might add) clobbers data on the other sheets if someone accidentally leaves multiple sheets selected after printing multiple sheets (which you must do to print them as a single print job).  There are other ways to accomplish what you are trying to do (like with a macro) without creating this stealthy data-destruction vulnerability.  Simultaneous multi-sheet editing should be disabled by default, unless each edit includes visible feedback that the data on other sheets is also being changed due to the multi-sheet selection.