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

On 12/15/2011 04:11 PM, MiguelAngel wrote:
> El 15/12/11 19:21, Pedro escribió:
> > . wrote
> > > How 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
Thanks Miguel for the tip!
> Miguel Ángel
>
>
>  * Inglés - detectado
>  * Inglés
>  * Español
>
>  * Inglés
>  * Español
>
> <javascript:void(0);>


--
Jay Lozier
jslozier@gmail.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