[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