Microsoft Technology Licensing, LLC

Alexander Yuryevich Novokhodko

Joseph John McDaid

Jeffrey James Duzak

Prashant Anand Shirolkar

Guido Van Rossum

Su-Piao Wu

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

Technology is disclosed herein for integrating native and non-native dependencies in a spreadsheet hosted by a spreadsheet application. In an implementation, a computing apparatus identifies a formula in a first cell of a spreadsheet which includes a non-native argument. The computing apparatus identifies a dependency between the first cell and a second cell created by the non-native argument. The computing apparatus limits recalculations of the spreadsheet based at least on the dependency. In an implementation, absent any other dependencies between the first cell and other cells, the first cell is excluded from recalculations triggered by changes to the other cells and included in recalculations triggered by the second cell. In an implementation, a direct or indirect dependency is created by, respectively, an explicit or implicit reference to the second cell in the non-native argument. In some implementations, the formula is native to the spreadsheet application hosting the spreadsheet.

Growing community of inventors

Redmond, WA, United States of America

Alexander Yuryevich Novokhodko