US 2025/0061271 A1 · INTEGRATING NON-NATIVE DEPENDENCIES IN SPREADSHEET APPLICATIONS

Abstract

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.

Claims20

Dependent claims

A computing apparatus comprising:

one or more computer readable storage media;
one or more processors operatively coupled with the one or more computer readable storage media;
and
program instructions stored on the one or more computer readable storage media that, when executed by the one or more processors, direct the computing apparatus to at least:
identify a formula in a first cell of a spreadsheet, at least a portion of which includes a non-native argument;
identify an indirect dependency between the first cell and a second cell in the spreadsheet created by an implicit reference in the non-native argument to the second cell, wherein to identify the indirect dependency, the program instructions direct the computing apparatus to identify the second cell based on a translated dependency for the implicit reference in a dependency datastore associated with the spreadsheet;
and
limit recalculations of the spreadsheet based at least on the indirect dependency.

5 more elements

One or more computer-readable storage media having program instructions stored thereon that, when executed by one or more processors of a computing device, direct the computing device to at least:

identify a formula in a first cell of a spreadsheet, at least a portion of which includes a non-native argument;
identify an indirect dependency between the first cell and a second cell in the spreadsheet created by an implicit reference in the non-native argument to the second cell, wherein to identify the indirect dependency, the program instructions direct the computing device to identify the second cell based on a translated dependency for the implicit reference in a dependency datastore associated with the spreadsheet;
and
limit recalculations of the spreadsheet based at least on the indirect dependency.

1 more element

Dependencies are inferred from the claim text.

Integrating non-native dependencies in spreadsheet applications

Life of this patent

Integrating non-native dependencies in spreadsheet applications

Life of this patent

Abstract

Claims20