Microsoft Technology Licensing, LLC

Prashant Anand Shirolkar

Jeffrey James Duzak

Benjamin C Chamberlain

Daniel C Battagin

Johnny S Campbell

Aaron Lamar Wilson

George Randell Dong

Chae Seong Lim

Alexander Yuryevich Novokhodko

Henry Nathan Shomber

Bradley Scott Prugar

Qusai Bassam Saleam Al-Rabadi

In various implementations, a calculation manger identifies one or more external references within a workbook, wherein the workbook resides in a spreadsheet environment comprising multiple workbooks. The recalculation manager then identifies a scope of a recalculation, triggered by an event in the workbook, based on one or more factors comprising the one or more external references. A recalculation engine then performs the recalculation within the identified scope.

Dynamically limiting the scope of spreadsheet recalculations

A method may include receiving an indication that a recalculation operation is to be completed for data stored in a data file; determining that a currently assigned number of threads for execution of the recalculation operation is lower than a target number of threads for the recalculation operation; requesting an additional thread for execution of the recalculation operation; beginning execution of the recalculation operation using the currently assigned number of threads; receiving an indication that the additional thread is available for execution of the recalculation operation; updating the currently assigned number of threads to include the additional thread; and continuing execution of the recalculation operation using the updated currently assigned number of threads.

System for adaptive multithreaded recalculation operations

In non-limiting examples of the present disclosure, systems, methods and devices for identifying a target value in a data set are presented. A request for a first target value in a data array may be received, wherein the request comprises first reference value. The data array may comprise a plurality of values and a plurality of value types included in one or more tables in a computer-implemented spreadsheet application. An index comprising a plurality of sorted reference numbers corresponding to a plurality of values in the data array may be generated based on the request. The index may be searched, and based at least on the search, the first reference value may be identified. In additional examples, the index may be cached and utilized to process additional target value requests that reference an overlapping range value with the first request.

Data set lookup with binary search integration and caching

Suggestions are automatically displayed in response to an event. For example, suggestions may be automatically displayed in response to a receiving an indication from a user to enter content (e.g. receiving a selection of a content entry area). The suggestions may be displayed before a user enters any characters and before an input device is displayed and/or used (e.g. keyboard, Software Input Panel (SIP), and the like. Suggestions may also be automatically displayed in response to detecting a pause while a user is entering content. For example, when a user is actively entering content, suggestions are not automatically displayed but when a user pauses a predetermined amount while entering content, suggestions are automatically displayed. The suggestions may be determined from content that may be seen on a display and/or hidden from view (e.g. hidden rows in a spreadsheet).

Automatically displaying suggestions for entry

Growing community of inventors

Kirkland, WA, United States of America

Prashant Anand Shirolkar