[libreoffice-users] Re: Google Sheets "QUERY" and Calc equivalent

Le 2014-12-31 09:01, Alex Thurgood a écrit :
> Le 31/12/2014 14:36, Marc Paré a écrit :
>
> Hi Marc,
>
> > Is there an equivalent Calc function for the Google Sheets function
> > "QUERY"? When I downloaded my spreadsheet from Google Sheets as a Calc
> > file, the "QUERY" function was not translated into an equivalent Calc
> > function.
> >
> > My original Google Sheets function is:"=QUERY('NBBP Address Book'!B2:B52)"
>
> I suppose it might help if we actually knew what this Google specific
> function did / is supposed to do ?
>
> Alex
Ah, yes

It references a list of names in another sheet called "NBBP Address 
Book" and shows the list in a column on the first sheet A1.

So for example, in "NBBP Address Book" sheet

Name1
Name2
Name3
Name4

Will then appear in sheet A1 as the same:

Name1
Name2
Name3
Name4



--
Marc Paré
Marc@MarcPare.com
http://www.parEntreprise.com
parEntreprise.com Supports OpenDocument Formats (ODF)
parEntreprise.com Supports http://www.LibreOffice.org


--
To unsubscribe e-mail to: users+unsubscribe@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