Abstract: Technology is disclosed herein for the integration of spreadsheet environments with LLM services. In an implementation, an application service receives a natural language input from a user associated with a spreadsheet hosted by a spreadsheet application. The application service generates a prompt based on the natural language input which includes asking a large language model (LLM) service to classify a statement in the input as referring to one of multiple capabilities of the spreadsheet application. The application service inputs the prompt to the LLM service and receives an output from the LLM service which identifies a determined one of the multiple capabilities. The application service generates a revised prompt based on the input and the determined one of the multiple capabilities and inputs the revised prompt to the LLM service.

Abstract: In an implementation, a computing device under the control of a spreadsheet application displays a spreadsheet in a user interface. The application detects a user action in the spreadsheet associated with an unstructured table and responsively drives the computer to display a suggestion component in the user interface. A selection of the component causes the computer to display a preview of a suggested table feature in the user interface.

Abstract: In an implementation, a computing device under the control of a spreadsheet application displays a spreadsheet in a user interface. The application detects a user action in the spreadsheet associated with an unstructured table and responsively drives the computer to display a suggestion component in the user interface. A selection of the component causes the computer to display a preview of a suggested table feature in the user interface.

Abstract: The techniques described herein facilitate supporting remote micro-services from cloud-based analytics platforms as native functions in spreadsheet applications, e.g., Microsoft Excel®. In an implementation, a method of supporting remote micro-services as native functions in a spreadsheet application is disclosed. The method includes accessing a listing identifying at least one micro-service that is available for use by a user of a spreadsheet application. The at least one micro-service is remotely located in a cloud service platform. The method further includes obtaining a schema associated with the at least one remote micro-service, generating a translation model based on the schema, and registering the skeleton spreadsheet function as a native function in the spreadsheet application. The translation model maps between the at least one remote micro-service and a skeleton spreadsheet function.

Abstract: In non-limiting examples of the present disclosure, systems, methods and devices for assisting with providing dataset insights associated with datasets are presented. A dataset and a query relating to the dataset may be received. The dataset may be processed to determine metadata that describes one or more properties of the dataset. The dataset, the determined metadata, and the user query may be provided to one or more modular recommendation elements for processing into an insight result that indicates a result from data analysis directed to the query. The insight result may be transferred in a portable format for use by the productivity application in displaying one or more insight objects based on the insight result.

Abstract: Systems, methods, and software for data calculation frameworks for user applications are provided herein. An exemplary method includes registering dynamic functions for use by a calculation engine of the user application, coupling calls made by the calculation engine for the dynamic functions to services that host the dynamic functions, and monitoring availability status for the dynamic functions related to availability of the dynamic functions to process expressions associated with the calculation engine.

Abstract: The techniques described herein facilitate proactively discovery of remote micro-services by spreadsheet applications, e.g., Microsoft Excel®. In an implementation, a method of operating a spreadsheet application to proactively discover remote micro-services based on credential information is disclosed. The method includes identifying the credential information associated with a user of the spreadsheet application responsive to detecting a micro-service updating event and proactively discovering one or more micro-services that are available to the user of the spreadsheet application through a cloud service platform based on the credential information. The method further includes persisting a list including the one or more micro-services that are available to the user of the spreadsheet application based on the credentials.

Abstract: In non-limiting examples of the present disclosure, systems, methods and devices for assisting with providing dataset insights associated with datasets are presented. A dataset and a query relating to the dataset may be received. The dataset may be processed to determine metadata that describes one or more properties of the dataset. The dataset, the determined metadata, and the user query may be provided to one or more modular recommendation elements for processing into an insight result that indicates a result from data analysis directed to the query. The insight result may be transferred in a portable format for use by the productivity application in displaying one or more insight objects based on the insight result.

Abstract: Performance and capability improvements of computer devices that provide digital images of heatmap visualizations for datasets are provided via both systems and methods. A value-color spectrum is correlated to the dataset via a multi-pass rendering. The multi-pass rendering yields a two-channel mask, which is applied to a map to show the dataset in a heatmap visualization on that map, and may be continually used as the map is manipulated by a user. User interface tools are also provided to enable a user to specify a custom value-color spectrum, how the dataset is to be aggregated, the area of effect for a data point in the visualization, the strength of effect for a data point in the visualization, and which specifies how a dataset will be visually represented in a heatmap.

Abstract: Systems, methods, and software for data calculation frameworks for user applications are provided herein. An exemplary method includes providing functions for use by a calculation engine of the user application, determining that the calculation engine issues a call for evaluation of a nested expression comprising at least a child function embedded in a parent function, and responsively dispatching at least a first evaluation process for a first portion of the nested expression that employs the child function. During evaluation of the nested expression, the method includes indicating to the calculation engine a predetermined result for at least the parent function, and dispatching at least a second evaluation process for a second portion of the nested expression that employs the child result. Responsive to receiving a parent result from the second evaluation process, the method includes indicating the parent result to the calculation engine.

Abstract: The techniques described herein facilitate proactively discovery of remote micro-services by spreadsheet applications, e.g., Microsoft Excel®. In an implementation, a method of operating a spreadsheet application to proactively discover remote micro-services based on credential information is disclosed. The method includes identifying the credential information associated with a user of the spreadsheet application responsive to detecting a micro-service updating event and proactively discovering one or more micro-services that are available to the user of the spreadsheet application through a cloud service platform based on the credential information. The method further includes persisting a list including the one or more micro-services that are available to the user of the spreadsheet application based on the credentials.

Abstract: The techniques described herein facilitate supporting remote micro-services from cloud-based analytics platforms as native functions in spreadsheet applications, e.g., Microsoft Excel®. In an implementation, a method of supporting remote micro-services as native functions in a spreadsheet application is disclosed. The method includes accessing a listing identifying at least one micro-service that is available for use by a user of a spreadsheet application. The at least one micro-service is remotely located in a cloud service platform. The method further includes obtaining a schema associated with the at least one remote micro-service, generating a translation model based on the schema, and registering the skeleton spreadsheet function as a native function in the spreadsheet application. The translation model maps between the at least one remote micro-service and a skeleton spreadsheet function.

Abstract: Systems, methods, and software for data calculation frameworks for user applications are provided herein. An exemplary method includes registering dynamic functions for use by a calculation engine of the user application, coupling calls made by the calculation engine for the dynamic functions to services that host the dynamic functions, and monitoring availability status for the dynamic functions related to availability of the dynamic functions to process expressions associated with the calculation engine.

Abstract: Systems, methods, and software for data calculation frameworks for user applications are provided herein. An exemplary method includes providing functions for use by a calculation engine of the user application, determining that the calculation engine issues a call for evaluation of a nested expression comprising at least a child function embedded in a parent function, and responsively dispatching at least a first evaluation process for a first portion of the nested expression that employs the child function. During evaluation of the nested expression, the method includes indicating to the calculation engine a predetermined result for at least the parent function, and dispatching at least a second evaluation process for a second portion of the nested expression that employs the child result. Responsive to receiving a parent result from the second evaluation process, the method includes indicating the parent result to the calculation engine.

Abstract: Computer systems, methods, and computer storage media for dynamically rendering geographic data. Geographic data is dynamically rendered as a digital map such that changes to the corresponding geographic data are automatically applied to the map and the map is automatically updated to show the changes to the geographic data. The map is rendered to give the most effective view of the corresponding geographic data by determining a least common ancestor of identified geographic entities. The least common ancestor is the lowest ranked geographic entity, within a geographic hierarchy, that is still common to all of the identified geographic entities within a set of geographic data.

Abstract: Performance and capability improvements of computer devices that provide digital images of heatmap visualizations for datasets are provided via both systems and methods. A value-color spectrum is correlated to the dataset via a multi-pass rendering. The multi-pass rendering yields a two-channel mask, which is applied to a map to show the dataset in a heatmap visualization on that map, and may be continually used as the map is manipulated by a user. User interface tools are also provided to enable a user to specify a custom value-color spectrum, how the dataset is to be aggregated, the area of effect for a data point in the visualization, the strength of effect for a data point in the visualization, and which specifies how a dataset will be visually represented in a heatmap.