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

Reply via email to