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é
[email protected]
http://www.parEntreprise.com
parEntreprise.com Supports OpenDocument Formats (ODF)
parEntreprise.com Supports http://www.LibreOffice.org
--
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
