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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



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
>
> Miguel Ángel

Miguel, thank you SO much for the help.  It was a little confusing and
the HELP wiki made it even worse!  Then I studied your example more and
figured it out.  You've really saved me hours and hours of work.



> * Inglés - detectado
> * Inglés
> * Español
>
> * Inglés
> * Español
>
> <javascript:void(0);>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJO6r95AAoJEPBpZNn4grcjMEUH/j3XhlMML0E2b4skBRDhP9zz
3+j+x/8JbPAlhZGJT+9UKFg6/5ukbR078m0jYO32HxO5XGNcmLT5DxnfFwc0HusW
bZqHFF5HpsoZY0eISblBqQpsFk1fb0oxVLT2p94wThyF3bGBjc8AVRMVVt9VH6iP
Zpis4ggwV7qfqbVX+idYDR63MD4L4zsA7CZlS7N73siiloZSjyYJnLRwUnVGAPzB
XCVQsLUdBJwaaPA5tOe9S1douX3S6cW50E1absCOfNPjH4KMuhOR7Zpn/NFJaU6x
mPJJSOTci/iC4IrYdlYktqJo0fB2mJrNom67BTA+jUvig2g21Q9sN1AFeExKr3k=
=u/ei
-----END PGP SIGNATURE-----


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