Re: [libreoffice-users] Re: Calc: Cutting and Pasting Ranges

Thank you Andreas.

Basically I was inadvertently attempting to do something I ought not to do. I was cutting and 
pasting from a range of cells (Sheet4.A1:AM418) to a different sheet. Some of those cells contained 
references to a PARTIALLY embedded range of cells (Sheet4.P$3:P$1230). After the cut and paste 
operation, the data from 416 of the 1228 referenced cells in the embedded range has been relocated 
while the data in the other 812 referenced cells remain where they were. LO Cannot be expected to 
read my mind WRT my intent in my internally inconsistent operation.

My only issue was that I was not alerted that I was making this error. When I saw that I was 
getting wrong results I undid the cut and paste. When I finally spotted what I'd done wrong I was 
able to revise the formulas by simply deleting rows 419 through 1230 before performing the cut and 
paste once again. In this instance that was the correct action to take.

I'm so happy that I spotted the incorrect values in calculated cells right away but it could have 
been disastrous. 

Upon detection of this inconsistency I would have expected LO to have displayed a notification 
dialog with one option being to cancel the operation.

As I indicated, I made a major boo-boo. I doubt many others have done the same but I hope my 
experience helps somebody else,

-- 
Jim

-----Original Message-----
From: "Andreas Säger" <villeroy@t-online.de>
To: users@global.libreoffice.org
Sent: Tue, 05 May 2015 9:55
Subject: [libreoffice-users] Re: Calc: Cutting and Pasting Ranges

Am 05.05.2015 um 12:48 schrieb James E Lang:
> I had a troubling experience that I want to share.
>
> Cut & Paste from a range of cells on one sheet (e.g. Sheet4.A1:AL418) to a location on another 
> sheet (e.g. Sheet2.XA1) leaves formulas that reference a range of cells (e.g. Sheet4.P$3:P$1230) 
> that is partially but not entirely within the Cut range as they were with no warning. This action 
> left me scratching my head for a while. The examples are from real life.
>
> The desirable action would be to issue a warning but I doubt that would be practical. In this 
> case there were something in the vicinity of 16000 formulas that failed to get converted. Thank 
> goodness for the ability to undo multiple steps.


[Tutorial] Absolute, relative and mixed references

> https://forum.openoffice.org/en/forum/viewtopic.php?f=75&t=2443




-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted