[libreoffice-users] Re: CALC - copy formula via macro

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: users+help@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