Integrating non-native dependencies in spreadsheet applications
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.
1. 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.
2. The computing apparatus of claim 1 , wherein, to limit the recalculations of the spreadsheet based at least on the indirect dependency, the program instructions direct the computing apparatus to:
absent any other dependencies between the first cell and any other cells of the spreadsheet, exclude the first cell from recalculations triggered by changes to the other cells of the spreadsheet; and
include the first cell in recalculations triggered by changes to the second cell.
3. The computing apparatus of claim 2 , wherein the program instructions further direct the computing apparatus to:
parse the non-native argument for the implicit reference to the second cell;
translate the implicit reference to a native format, resulting in the translated dependency; and
register the translated dependency in the dependency datastore associated with the spreadsheet.
4. The computing apparatus of claim 3 , wherein the formula in the first cell comprises a name of a function native to a spreadsheet application hosting the spreadsheet and wherein the function comprises the non-native argument.
5. The computing apparatus of claim 4 , wherein when a recalculation of the recalculations is triggered that includes the first cell, the program instructions direct the computing apparatus to send a request for an external resource to evaluate the non-native argument of the first cell.
6. The computing apparatus of claim 5 , wherein to send the request for the external resource to evaluate the non-native argument of the first cell, the program instructions direct the computing apparatus to evaluate the second cell prior to sending the request for the external resource to evaluate the non-native argument of the first cell.
7. The computing apparatus of claim 6 , wherein to evaluate the second cell, the program instructions direct the computing apparatus to send a first request to the external resource to evaluate a non-native expression in the second cell.
8. The computing apparatus of claim 7 , wherein the formula in the first cell of the spreadsheet comprises a formula native to the spreadsheet application hosting the spreadsheet.
9. 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.
10. The one or more computer-readable storage media of claim 9 , wherein, to limit the recalculations of the spreadsheet based at least on the indirect dependency, the program instructions direct the computing device to:
absent any other dependencies between the first cell and any other cells of the spreadsheet, exclude the first cell from recalculations triggered by changes to the other cells of the spreadsheet; and
include the first cell in recalculations triggered by changes to the second cell.
11. The one or more computer-readable storage media of claim 10 , wherein the program instructions further direct the computing device to:
parse the non-native argument for the implicit reference to the second cell;
translate the implicit reference to a native format, resulting in the translated dependency; and
register the translated dependency in the dependency datastore associated with the spreadsheet.
12. The one or more computer-readable storage media of claim 11 , wherein the formula in the first cell comprises a name of a function native to a spreadsheet application hosting the spreadsheet and wherein the function comprises the non-native argument.
13. The one or more computer-readable storage media of claim 12 , wherein when a recalculation of the recalculations is triggered that includes the first cell, the program instructions direct the computing device to send a request for an external resource to evaluate the non-native argument of the first cell.
14. The one or more computer-readable storage media of claim 13 , wherein to send the request for the external resource to evaluate the non-native argument of the first cell, the program instructions direct the computing device to evaluate the second cell prior to sending the request for the external resource to evaluate the non-native argument of the first cell.
15. The one or more computer-readable storage media of claim 14 , wherein to evaluate the second cell, the program instructions direct the computing device to send a first request to the external resource to evaluate a non-native expression in the second cell.
16. The one or more computer-readable storage media of claim 15 , wherein the formula in the first cell of the spreadsheet comprises a formula native to the spreadsheet application hosting the spreadsheet.
17. A method of operating a spreadsheet application, the method comprising:
identifying a formula in a first cell of a spreadsheet, at least a portion of which includes a non-native argument;
identifying 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 identifying the indirect dependency, comprises identifying the second cell based on a translated dependency for the implicit reference in a dependency datastore associated with the spreadsheet; and
limiting recalculations of the spreadsheet based at least on the indirect dependency.
18. The method of claim 17 , wherein limiting the recalculations of the spreadsheet based at least on the indirect dependency comprises:
absent any other dependencies between the first cell and any other cells of the spreadsheet, excluding the first cell from recalculations triggered by changes to the other cells of the spreadsheet; and
including the first cell in recalculations triggered by changes to the second cell.
19. The method of claim 18 , further comprising:
parsing the non-native argument for the implicit reference to the second cell;
translating the implicit reference to a native format, resulting in the translated dependency; and
registering the translated dependency in the dependency datastore associated with the spreadsheet.
20. The method of claim 19 , wherein the formula in the first cell comprises a name of a function native to a spreadsheet application hosting the spreadsheet and wherein the function comprises the non-native argument.