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.

-- 
Jim

-- 
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