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

Le 2014-12-31 09:22, Marc Paré a écrit :
> 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

I should also add that the Google "=QUERY" then lists the names as 
above, but, the formula only shows on the first name (Name1) and the 
other names in the list are displayed as names. This allows a user to 
copy/paste the other names without having any formula appear when 
clicking in the field.

I use the list as a reference list to help users copy/paste names into 
other fields on the A1 sheet. It avoids users from spelling the names 
with errors.

Marc


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