Posted: 06 Dec 2016 12:25 PM PST
To prevent the errors that sometimes plague complex calculations, today we’re launching a new setting in 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).


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.

Search the menus from the Help menu

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

More Information
Help Center: Change a spreadsheet’s locale, time zone, calculation settings, and language


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Follow
( 0 Followers )
X

Follow

E-mail : *