Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index



-----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.
What is "Mays"?



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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJO6qunAAoJEPBpZNn4grcjoP0IAJRMYCBebYUEZZg3ujfw0O9Q
6f3O5Fx8uIS5YYupsaN+3n1zS5fedOXQ6wD066QsHhSBZQitdMNH8uVYCWgMltt4
DNW8nyKkFieecJWlcSpYVT6pjtDbJbq3QhXjkaSSLwSmyFj6eCZShpJgYFuw0gJj
dz+d6b+yzagw63YnWL2W4tLlH3nAdFLfY4n/rQqCu1rgqRA/sLwH02XtPJ8ziMUc
5T5B4lCpg5gKF8OYCHtFAW0OYZJDcxnJF4GvUoqc172xkiC3sAb4RnDQ56d9RZ4T
xUrOX4CNAn8e5BivuQ73KagnwEpDl3s018Bfi8TPc2hFMxpxRE0VtcknG3gQ3Cc=
=mRH6
-----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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.