Jean-Francois Nifenecker has written on 2/15/2014 12:46 PM: > 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, >
Merci, Jean-Francois! What's the difference between this kind of named range and the one you get by doing Data > Define Range in step 2? -- To unsubscribe e-mail to: users+unsubscr...@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
