El 15/12/11 19:21, Pedro escribió:
. wroteHow do I do it? I've tried the Absolute reference method ($A$1) but that won't allow for the addition of new rows in an additional sheet.Absolute references won't work because they are updated as you insert rows. One solution is to use INDIRECT to always point at the same cells. http://db.tt/mdp3mBMz Probably there are more elegant ways of doing this :) -- View this message in context: http://nabble.documentfoundation.org/Cell-reference-that-updates-all-sheets-tp3589103p3589460.html Sent from the Users mailing list archive at Nabble.com.
A very good option is use an array. In Sheet2.a1 =Sheet1.a1:a15 and use Mays+Crtl+Enter to get an array.If you insert a row in for example Sheet1.a8 then the array in Sheet2 is expanded to retain the same size, even better if you have formulae in the array rows in Sheet2, they are also copied in the new row.
To edit an array you must select the array not a cell in the array, use Ctrl+/ for this.
The help in the wiki about arrays: http://help.libreoffice.org/Calc/Array_Functions Miguel Ángel * Inglés - detectado * Inglés * Español * Inglés * Español <javascript:void(0);> -- 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