• 12 new file formats in the Google Docs Viewer: The Google Docs Viewer is used by millions of people every day to quickly view PDFs, Microsoft Word documents and PowerPoint presentations online. Not only is viewing files in your browser far more secure than downloading and opening them locally, but it also saves time and doesn’t clutter up your hard-drive with unwanted files. We recently added support for:

    • Microsoft Excel (.XLS and .XLSX)
    • Microsoft PowerPoint 2007 / 2010 (.PPTX)
    • Apple Pages (.PAGES)
    • Adobe Illustrator (.AI)
    • Adobe Photoshop (.PSD)
    • Autodesk AutoCad (.DXF)
    • Scalable Vector Graphics (.SVG)
    • PostScript (.EPS, .PS)
    • TrueType (.TTF)
    • XML Paper Specification (.XPS)

  • Multiple chart ranges and hidden sheets in Spreadsheets: We added the ability to chart multiple ranges and hide sheets in Google spreadsheets. In charts, you can now add extra ranges by clicking on “Select ranges...” and “add another range.” You can also manually add new ranges separated by commas. In addition, we introduced the ability to hide your sheets. You can now click on a sheet tab and select “hide sheet” to remove a sheet from view.
  • Revisions, presence, and format painter in Drawings: We’re making it easier to work together in drawings. First, we’ve added presence highlights around shapes so you can keep track of which object each person is editing. Second, we added revision history which lets you see who made which change as well as go back to previous versions. Third, the new format painter lets you choose a source shape, press the format painter icon to copy its formatting, and then click on another shape to apply that formatting to the destination shape.

  • Quick starring and improved sharing invitations: Now you can star documents while editing them. Once a doc is starred, you’ll be able to find the doc by clicking on the starred link in your document list. We’ve also updated document sharing so that when you share a doc with others, all new collaborators are now included on the email.
  • Cloud printing on the go: now you can print from your smartphone with Google Cloud Print for mobile documents and Gmail for mobile. Just open a document in Google Docs or an email in Gmail in your mobile browser and choose “Print” from the dropdown menu in the top right corner. To get started, you’ll need to connect your printer to Google Cloud Print.
As with all updates in Google Docs, users get access to new features each time they open their browsers, and improvements roll out to customers with no need for administrators to manage patches or install software. Stay tuned for more updates to Google Docs.


March is a special time for college basketball enthusiasts as the NCAA® Championship games heat up. This season is especially exciting for us on the Apps for Education team to watch, as more than half of the teams in this year’s tournament have Gone Google – meaning they’re using Google Apps for Education on campus.

With more than 11 million students, faculty and staff who are already part of the Google Apps “squad” – providing their campus community with collaboration and communication tools – we’d like to congratulate the 37 Apps schools who are vying for the championship and wish them luck with the rest of the tournament, including:
  • Alabama State University
  • Belmont University
  • Bucknell University
  • Clemson University
  • Gonzaga University
  • Notre Dame
  • Old Dominion University
  • San Diego State University
  • Temple University
  • University of Akron
  • University of Arkansas at Little Rock
  • University of Illinois at Urbana Champaign
  • University of Kentucky
  • University of Nevada, Las Vegas
  • University of Texas at San Antonio
  • University of Southern California
  • University of Washington
  • Utah State University
  • Vanderbilt University
  • Villanova University
For information about how to become a 100% web campus, please visit google.com/apps/edu. While we’re sorry to say we can’t promise any success on the basketball court, you can at least make your own bracket a "slam dunk" with the Google Docs bracket template!

Give it a try and send us feedback on how we can make it work better for you!


At Revevol, we train clients’ employees who have just migrated to Google Apps, to help them get the most out of their new system. The more Revevol grows, the more customer trainings we have to handle, so we need to quickly find available trainers depending on parameters like the training date, language, location of trainers and trainer skills.

Google Apps Script, a cloud scripting language based on JavaScript, is wired into almost every Google product, so it’s a perfect solution for checking calendars and spreadsheets, and solving our scheduling problems. In the early days, we were using a simple Google Form. It was really easy to put together and simple to use, but one thing was missing: the form just collected data -- there was no way it could automatically take action based on information submitted. Someone had to manually process the information.

This is where Apps Script came to the rescue -- with a little JavaScript code we could build an interactive form that we so badly needed. In a single day, Apps Script let us build a shiny new graphical user interface for our tool, which lets let us dynamically search for available trainers across all skill levels and categories.

How did we do it? We recreated our form using Ui Services in Apps Script. We added a panel next to the form, to show the search results of trainers that match our queries. By using Spreadsheet Services in Apps Script, we could search and fetch data from a spreadsheet that serves as our database of trainers. We also added the ability to sort the search results of trainers by skill level and distance from the training location.




Thanks to integration with Google Maps Services in Apps Script, we're even able to display a map to help our project managers find the closest trainer. Project managers can select more than one trainer from search results and each selected trainer will receive a calendar invitation. The first to respond “Yes” gets the training assignment. It was incredibly easy to build and deploy this application. In one click, we published it so anyone at Revevol can access the tool in their browsers. Apps Script helped us automate this tedious business process!




Posted by Romain Vialard and Lynn Jaber, Revevol
Share on Google+ Share on Twitter Share on Facebook