Hi :) When you copy&paste a cell that contains a formula even if you paste it to a different worksheet. If the equation was in Sheet1 cell A1 and you clicked on a different tab at the bottom to look at Sheet3 and then pasted into Sheet3's A12 then the formula would be =SUM(B12:E12)
Often it is easier to get more control and sophistication by doing things programmatically but the gui "point&click" approach is usually easier for most people and can be surprisingly sophisticated. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/CALC-copy-formula-via-macro-tp3305429p3306446.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [email protected] 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
