[libreoffice-users] Google Sheets QUERY and Calc equivalent

2014-12-31 Thread Marc Paré
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)

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

2014-12-31 Thread libreoffice-ml . mbourne
Marc Paré wrote: 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. What does that function to do? From a quick search:

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

2014-12-31 Thread Brian Barker
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