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