Sorry, my previous link answers the question how to drag down a calculated field, so the formula with relative references spreads over a given column of cells.
http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCellRangeMovement.html#copyRange provides the "normal" way to copy&paste with all (conditional) formattings, relative/absolute references and validation. It takes a c.s.s.table.CellAddress to specify the target cell and a c.s.s.table.CellRangeAddress to specify the source range. The API has not obvious method to copy/move cells between different documents. This is one of the rare cases where you may want to use the dispatcher. -- View this message in context: http://nabble.documentfoundation.org/CALC-copy-formula-via-macro-tp3305429p3306475.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
