Edit spreadsheets on the go with the Drive mobile app

You’re making your list, you’re checking it twice -- and now you can do it from anywhere.

Just in time for this year’s holiday season, you can edit Google Sheets on your mobile device, just like you can with Google Docs. From the Drive app on your Android device, you can create a new spreadsheet or edit an existing one. You can switch fonts, resize columns, sort data, and more. And just like on your computer, you’ll be able to see other people’s edits in real time as they’re made.

Beyond spreadsheets, you may notice a few other tweaks to the Drive app, including better text formatting when you paste from one Google document to another. And from your Android device, you can edit text within tables in documents and add a shortcut on the homescreen of your device to any specific file in Drive.

Whether it’s holiday recipes, shopping lists, or just your family budget, the Drive app on your mobile device makes it easy to get stuff done wherever you are.

Get the Google Drive app today on Google Play.

Posted by Shrikant Shanbhag, Software Engineer

• Tweet

Fiat 130 Coupe

V6 / 3.233 cc / 165 PS / 184 ft/lb (249 Nm) @ 3.400 / Vmax: 123 mph (198 km/h)

(click images for a larger view)

• Tweet

Query Contacts database, selection with AND to combine more cause.

The previous exercise demonstrate how to "Query Contacts database" for all contacts, "Search for contacts with phone number only" and "Search with selection of LIKE cause". To combine both cause to search for contacts has phone number with certain constraint in DISPLAY_NAME, combine both cause with "AND".

Change:
String selection = ContactsContract.Contacts.DISPLAY_NAME + " IS NOT NULL";

to:
String constraint = "Lau";
String selection =
ContactsContract.Contacts.HAS_PHONE_NUMBER + "=1"
+ " AND "
+ ContactsContract.Contacts.DISPLAY_NAME + " LIKE '%" + constraint + "%'";

• Tweet