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" <ville...@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+unsubscr...@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+unsubscr...@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