[libreoffice-users] Re: Cell reference that updates all sheets?

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

Yep. Definitely much more elegant (and efficient) ;)

Thank you, Miguel Angel :)

--
View this message in context: 
http://nabble.documentfoundation.org/Cell-reference-that-updates-all-sheets-tp3589103p3590158.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