Posts

Google Drive firewall and proxy settings

In order for users on your network to access Google Drive on the web, the Google Drive sync client, and Google Docs editors, your firewall rules should connect to the following hosts and ports. Otherwise, users may be blocked or denied access these services.

For the following hosts, [N] means any single decimal digit and * means any string not containing a period.

  • www.google.com:443/HTTPS
  • accounts.google.com:443/HTTPS
  • googledrive.com:443/HTTPS
  • drive.google.com:443/HTTPS
  • *.drive.google.com:443/HTTPS
  • docs.google.com:443/HTTPS
  • *.docs.google.com:443/HTTPS
  • *.c.docs.google.com:443/HTTPS
  • sheets.google.com:443/HTTPS
  • slides.google.com:443/HTTPS
  • talk.google.com:5222/XMPP (needed only for the Drive sync client)
  • gg.google.com:443/HTTPS
  • script.google.com:443/HTTPS
  • ssl.google-analytics.com:443/HTTPS
  • video.google.com:443/HTTPS
  • s.ytimg.com:443/HTTPS
  • apis.google.com:443/HTTPS
  • *.googleapis.com:443/HTTPS
  • *.googleusercontent.com:443/HTTPS
  • *.gstatic.com:443/HTTPS
  • lh[N].google.com:443/HTTPS
  • [N].client-channel.google.com:443/HTTPS
  • clients[N].google.com:443/HTTPS

Important notes

  • The IP addresses that various domain names resolve to don’t necessarily fall within any given address range.
  • Other Google properties may use the IP addresses that Drive uses.Google.com
  • Techniques that Drive uses to connect to Google servers depend on the browser, browser version, network conditions, etc.
  • Even if you don’t currently observe activity at the addresses listed above in a particular Google product there could be future activity.
  • The Drive sync client supports all unauthenticated proxies that are configured by the operating system.
  • The sync client supports the only DNS-based distribution of PAC files. PAC distribution over DHCP is not supported.

Reference by Google.com

New features for your Google Docs and Sheets mobile apps

Today’s updates to the Google Docs and Sheets mobile apps bring several new and useful features to your Android and iOS devices. Read on for more information.

On your Android phone or tablet, you can now:

Image Manipulation

On your iPhone or iPad, you can now:

iOS Page Setup 2

Download the latest versions of these apps from Google Play or the App Store.

Launch Details
Release track:
Launching to both Rapid release and Scheduled release

Editions:
Available to all G Suite editions

Rollout pace:
Gradual rollout (potentially longer than 3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

 

 

 

New iterative calculation settings and more in Google Sheets

To prevent the errors that sometimes plague complex calculations, today we’re launching a new setting in Google Sheets on the web (File > Spreadsheet settings > Calculation > Iterative calculation) that allows you to set the maximum number of times a calculation with a circular reference can take place. In addition, you can specify a “convergence threshold,” and when results from successive calculations differ by less than that threshold value, the calculations will stop (even if the maximum number of calculations has yet to be reached).
iterative-calc-settings- Google Sheets
Over the course of the week, we’ll make additional improvements to your Sheets experience on the web and Android devices. First, we’ll update the Sheets Android app UI to make it easier for users with right-to-left language settings to read and navigate. Second, we’ll make it possible to search the menus in Sheets on the web, much like you can in Google Docs and Slides.
menu-search-1- google sheets

menu-search-2

Search the menus while in Compact Controls mode

For more details on these features, please visit the Help Center.

Launch Details
Release track:

  • Launching to Rapid release, with Scheduled release coming on January 9th, 2017
    • Iterative calculation setting
  • Launching to both Rapid release and Scheduled release
    • Right-to-left language improvements
    • Menu search

Editions:
Available to all G Suite editions

Rollout pace:
Gradual rollout (potentially longer than 3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

 

Reference by google.com

 

Include hidden and filtered data in charts in Google Sheets

We’re making charts in Google Sheets easier to use and analyze. This launch introduces the option to include hidden and/or filtered data in Sheets charts. Going forward, if you create a chart in Sheets on the web and then filter or hide any of the source data, a small message will appear indicating that the data has been removed from your chart and giving you the option to include it. While this option will only appear on the web, any settings will be respected on mobile as well.

comprompt-GoogleAppUpdate

If you opt to include that hidden or filtered data and then later want to exclude it from the same sheet, you can simply expand the chart menu in the upper right corner of the chart and select Advanced edit. That will open the Chart Editor, where you can choose Chart types and uncheck the box next to Include hidden / filtered data. The next time you hide or filter source data in that same sheet, you’ll see the message again.

Not only will this give you greater control over the spreadsheets you create within Google Sheets, it will prevent Microsoft Excel spreadsheets that contain hidden data and that are imported into Sheets from being inaccurately displayed.

Reference By Google

Publish Google Sheets spreadsheets in five additional formats

In Google Sheets on the web, if a person wants to make a spreadsheet available for a large audience to see, they can publish the file as a web page. Once that file is published, the person receives a URL that can be sent to whomever they choose or embedded into a website. Today’s launch allows people to publish spreadsheets in five additional formats—as comma-separated values (.csv), tab-separated values (.tsv), a PDF document (.pdf), a Microsoft Excel® spreadsheet (.xlsx), or an OpenDocument spreadsheet (.ods). The URL generated, when opened in a browser, will automatically download the spreadsheet in the chosen format (spreadsheets in these additional formats cannot be embedded).

Publish Google Sheets spreadsheets in five additional formats

Google Sheets

Try out this new feature in Google Sheets on the web today.

Release track:
Rapid release and Scheduled release

Reference By www.google.com

More options for charts, cells, and collaboration in Google Sheets on the web

When working with spreadsheets, it’s important to take raw figures and turn them into a story. Today’s update to Google Sheets on the web allows people to do just that, offering even more ways to visualize and analyze data.

Customized charts, made easier
Charts can make even the largest data sets digestible, so we’ve made a few improvements to help people highlight what’s most important. With this launch, people can now:

  • Use data labels to display the exact values of bars and points in charts.
  • Choose different shapes and symbols for data points in both line and scatter charts.
  • Move and resize charts more easily.

Charts-Data-Labels_Shapes

Data, displayed right
Today’s launch also includes new tools for analyzing spreadsheet data. For example, people can:

  • Preview the results of a formula, including any formula errors, instantly as they type.
  • Filter rows and columns by conditions, including “less than,” “greater than,” “text contains,” “date after,” and more.
  • Add calculated fields to pivot tables in order to apply formulas to pivot table data.
  • Use the GETPIVOTDATA function to retrieve data from a pivot table.

Docs-Sheets-Formula-V2-7

Collaborate, confidently
Collaborating in Sheets can greatly improve the end product, but it’s important to avoid making accidental edits. Currently, people can restrict who can edit an entire worksheet or range of cells using the protected sheets and ranges feature. To reduce the number of unintended changes (e.g. typos) made by people who do have permission to edit, today’s launch includes the ability to warn individuals who attempt to edit certain cells. This will facilitate increased collaboration, as owners won’t need to set complicated permissions in order to allow others to work on the document.

Heads Up

Try these updated Google Sheets features on the web today, and start telling better stories with data.

Release track:
Rapid release and Scheduled release:

  • Calculated fields in pivot tables
  • GETPIVOTDATA functionality
  • Protected cell warnings

Live on Rapid release, with Scheduled release to follow on June 29th:

  • Data labels in charts
  • Custom data point shapes in charts
  • Moving and resizing charts
  • Formula previews
  • Filter by condition

Reference by google.com

An update on the migration of older spreadsheets to the new Google Sheets

comprompt- Google Sheets

Back in November 2014, GOOGLE  announced that older spreadsheets (those created prior to Dec 2013, including any subsequent copies) would start being gradually migrated to the new version of Google Sheets for Google Apps domains on the Rapid release track, with Scheduled domains to follow.

While the migration started for consumer spreadsheets, GOOGLE decided to delay the migration for the Rapid release track to ensure a more smooth process. Starting next week, google will formally start the migration for Rapid release domains, with Scheduled release domains to follow 2-3 weeks later (note: we have decided against displaying the migration notification in the Sheets interface for Google Apps customers to prevent unnecessary confusion).

The migrations will take several months to complete, but you’ll be able to take advantage of the new features and capabilities in the new Sheets as older spreadsheets are migrated. Simpler spreadsheets will be upgraded first, while those that use Apps Script and more complex features will be migrated weeks to months later to ensure a seamless transition.

 

Reference by:www.google.com


Bring a little something extra to Docs and Sheets with add-ons

Today we’re launching add-ons—new tools created by developer partners that give you even more features in your documents and spreadsheets. To browse through add-ons for Docs and Sheets, select Get add-ons in the Add-ons menu of any open document or spreadsheet. Once you install an add-on it will become available across all of your documents or spreadsheets and you can start using it right away. Note that add-ons for spreadsheets are only available in the new Google Sheets.

Google Apps admins must enable add-ons through Drive settings in the Admin console. Users will always see the Add-ons menu and can browse them but will not be able to install them if the feature isn’t enabled by the admin.

Release Track:
Rapid release

Editions included: 
Google Apps for Business, Education and Government

For more information:
https://support.google.com/a/answer/4530135
http://googleenterprise.blogspot.com/2014/03/bring-little-something-extra-to-docs.html

 

 Reference by : http://www.google.com/