Le 15/02/2014 18:20, Pikov Andropov a écrit : > How do you name an array? >
(1) Select the array (2) Menu Insert > Names > Define (3) Enter the name of your choice (no spaces allowed) and hit OK. From now on, using the array in a formula is equivalent to the absolute reference to this array. EG: you select A1:B2 and name it "my_array" You may write formulae using the $A$1:$B$2 or the my_array syntax (note that you must not use quotes when dealing with array names in formulae). That is: =SUM($A$1:$B$2) or =SUM(my_array) give the same result HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: [email protected] 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
