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

At 08:36 31/12/2014 -0500, Marc Paré wrote:
> Is there an equivalent Calc function for the Google Sheets function "QUERY"?

Probably not - though you may want to look at 
Calc's "database functions". (That's the database 
functions in Calc, not LibreOffice's database 
functionality, Base.) See the help text for functions such as DGET().

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

At 09:22 31/12/2014 -0500, Marc Paré wrote:
> It references a list of names in another sheet 
> called "NBBP Address Book" and shows the list in 
> a column on the first sheet ...

You probably don't need QUERY to do that. Just construct the formula
='NBBP Address Book'.B2:B52
but instead of clicking the green tick mark or 
pressing Enter, press Ctrl+Shift+Enter. The 
formula will be surrounded by braces (but note 
that you cannot simply type these yourself) and 
will become an array formula with similar results.

I trust this helps.

Brian Barker


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