Hi Falko,
would be nice to have.
Peter

*** Issue 17045 has been marked as a duplicate of this issue. ***

As this has been on the back burner for a while and issue 17045 has
been closed as a duplicate of this:

From a user's point of view, I asume that functions I can select from
a menu or otherwise do actually what they say. Now, consider the
situation: I select multiple sheets and use the insert/delete
row/column function. What would one expect? As far as I am concerned
that the program does as told (especially as it allows me to tell it
in the first place).

Therefore, I suggest that insert/delete row/column are being disabled
in the menus and elsewhere if more than one sheet is selected as the
scope for these functions is currently only one sheet, not multiple
sheets. The situation would then be much more in line with the
fundamental design principle of least surprise.

I feel this should ideally happen before 1.1 is released - but then
again I'm just a nagging user. ;-)

When I select multiple sheets, I can format, add values, formulas,
etc., but I cannot add or delete rows or columns.  I have to do it
manually for every sheet. 
This must change.
When I add or delete rows/coumns than this has to happen on all other
selected sheets, too.
Note: A competitor behaves like this, too.

.

Hello Niklas, please give approval for this evaluated OO.o 2.0 flagged
issue. 
If you confirm with the target OO.o 2.0, then please keep it on your
owner (or the owner of the concerning developer) for implementation.
In case you want this issue for 'OOo Later', then please reset the
target milestone. If you decline the issue finally, please set the
resolution to 'Wontfix' (but do not close). In case of 'OOo Later' or
'Wontfix' please reset it on Bettina's owner. Thank you.

This is a duplicate of issue 23263. (or the other way round :)

according to the announcement on releases
(http://www.openoffice.org/servlets/ReadMsg?list=releases&msgNo=7503) this issue
will be re-targeted to OOo Later.

*** Issue 29847 has been marked as a duplicate of this issue. ***

*** Issue 33402 has been marked as a duplicate of this issue. ***

*** Issue 37427 has been marked as a duplicate of this issue. ***

*** Issue 38598 has been marked as a duplicate of this issue. ***

*** Issue 23263 has been marked as a duplicate of this issue. ***

I too think that when deleting or inserting rows/columns when more than one
sheet is selected should work on all selected sheets. It still doesn't work 1.9.79.

I confess to not having thoroughly tested the following macros - written for
1.1.4 for Linux (but should work for all versions I think). Beware word wrap
there is just one line between for and next.

Sub subDeleteRowsMultipleSheets
oSheets = thisComponent.sheets
on local error goto finished
mRangeAddresses = thisComponent.currentController.selection.rangeAddresses
for i = uBound(mRangeAddresses) to 0 step -1
	oSheets(mRangeAddresses(i).sheet).rows.removeByIndex(mRangeAddresses(i).startRow,
mRangeAddresses(i).endRow - mRangeAddresses(i).startRow + 1)
next
finished:
end sub


Sub subDeleteColumnsMultipleSheets
oSheets = thisComponent.sheets
on local error goto finished
mRangeAddresses = thisComponent.currentController.selection.rangeAddresses
for i = uBound(mRangeAddresses) to 0 step -1
	oSheets(mRangeAddresses(i).sheet).columns.removeByIndex(mRangeAddresses(i).startColumn,
mRangeAddresses(i).endColumn - mRangeAddresses(i).startColumn + 1)
next
finished:
end sub


Sub subInsertRowsMultipleSheets
oSheets = thisComponent.sheets
on local error goto finished
mRangeAddresses = thisComponent.currentController.selection.rangeAddresses
for i = uBound(mRangeAddresses) to 0 step -1
	oSheets(mRangeAddresses(i).sheet).rows.insertByIndex(mRangeAddresses(i).startRow,
mRangeAddresses(i).endRow - mRangeAddresses(i).startRow + 1)
next
finished:
end sub


Sub subInsertColumnsMultipleSheets
oSheets = thisComponent.sheets
on local error goto finished
mRangeAddresses = thisComponent.currentController.selection.rangeAddresses
for i = uBound(mRangeAddresses) to 0 step -1
	oSheets(mRangeAddresses(i).sheet).columns.insertByIndex(mRangeAddresses(i).startColumn,
mRangeAddresses(i).endColumn - mRangeAddresses(i).startColumn + 1)
next
finished:
end sub

*** Issue 44945 has been marked as a duplicate of this issue. ***

*** Issue 44967 has been marked as a duplicate of this issue. ***

*** Issue 45010 has been marked as a duplicate of this issue. ***

*** Issue 56384 has been marked as a duplicate of this issue. ***

*** Issue 59098 has been marked as a duplicate of this issue. ***

*** Issue 59969 has been marked as a duplicate of this issue. ***

From my view this is not an enhancement, it is a DEFECT. 
 
I LOST HOURS OF WORK! 
 
When I select multiple sheets, it has to work with multiple sheets  
or display a warning like "I am not able to do that".  
Everything else, I used, worked on multiple sheets. So I worked on the wrong 
columns in the not visible sheets. 
 
Sorry, I am a little echauffaged, 
Frank 
 

I just lost a bunch of time and work when I tried to insert a line to multiple
sheets and not knowing the less than inlogical behavior of OO-Calc. Thinking of
all selected sheets were added the new line I worked and worked until after an
hour of thinking, typing, formatting (and saving!) I saw the mess.

PLEASE make inserting a line to multiple sheets working like in Exc...

A nice guy gave me a hint of a workaround: Cut and paste - but not the way it
should go all the future...

Hi there,

I do not understand, why such a substantial bug - existing for 5 years now - is
not eliminated. My employer - the City of Munich - is planning to change to
LINUX and also OOo. In my department now EXCEL is used intensively and also this
bug would concern not only me, but many of my coworkers.

I think this is a substantial bug which sould have at least Priority P3 ans
should be eliminated before adding some nice to have gimmicks, only few people
are using. This bug costs a lot of productive time, especially when you are used
to work with EXCEL at office and change to OOo...

5 years are a long time...

*** Issue 71788 has been marked as a duplicate of this issue. ***

Also, Paste special - Move cells right / Move cells down overwrites data on 
other sheets, instead of moving

Sorry guys,

taking this issue for "ENHANCEMENT" is some great understatement. I understand 
misworking functions as errors, so this issue type should be really "DEFECT".

The EX**L programmers got it long ago. So go on, please!

Accepted

start

Created attachment 55876 [details]
The patch file is about i7088#-v1.

Created attachment 55987 [details]
The patch file is about i7088#-v2.

Created attachment 56035 [details]
The patch file is about i7088#-v3.

The last patch looks good. This can go into 3.1.

taking the issue

I added the last patch to CWS "calc47".

Reassigning to QA for verification

verified in internal build cws_calc47

Issue 7088 has been fixed in master version OOo-dev 3.1 .0 (OOO310m7 Build:9393) 
for Windows XP.

Checked and closed by HitekSchool Group 1.