Microsoft Technology Licensing, LLC

Christopher John Gross

Johnny S Campbell

Claudio Vittorio Russo

Andrew James Becker

Joseph John McDaid

Benjamin Edward Rampson

Carlos Augusto Otero

Christian Canton

Ehab Sobhy Deraz

Andrew Donald Gordon

Andrew Grey Carlson

Michelle Elena Keslin

Anupam Garg

Su-Piao Bill Wu

Jeffrey James Duzak

Nickolas Dwayne Welton

Martin R Calsyn

Poornima Hanumara

Michael Davenport

Catalin I Tomai

Annie Colonna

Arunkumar Thippur Jayakeerthy

A formula abstraction system is described. The system includes detecting a user-generated formula in a cell of a spreadsheet document, generating a graphical user interface that queries entries of a custom function based on the user-generated formula, forming the custom function by abstracting the user-generated formula to the custom function based on the entries, and storing the custom function in a function library of the spreadsheet document. The custom function applies the user-generated formula in a user-selected cell of the spreadsheet document.

Abstraction of formulas into reusable functions

Examples discussed herein relate to automatically creating lambda functions in spreadsheet applications, e.g., Microsoft Excel&#xae;. In an implementation, a method of automatically creating lambda functions in spreadsheet applications using a lambda shorthand notation is disclosed. The method includes analyzing contents of a cell of a spreadsheet to identify a formulaic expression and determining that the formulaic expression can define a body of a lambda function without using explicit lambda function notation or parameter declarations. The method further includes automatically creating and invoking the lambda function responsive to the determination. As discussed herein, creating the lambda function includes registering the lambda function in a lambda registry using the formulaic expression as the body of the lambda function that evaluates into an output value.

Automatically creating lambda functions in spreadsheet applications

Examples discussed herein relate to rending lambdas in spreadsheet application, e.g., Microsoft Excel&#xae;. In an implementation, a method of rendering lambdas in a spreadsheet application is disclosed. The method includes accessing a data object corresponding to the lambda function. The data object includes a listing of metadata associated with the lambda function and one or more items of the metadata identify rendering functionality for the lambda function. The method further includes creating a visual representation of the lambda function based, at least in part, on the rendering functionality for the lambda function, and rendering, in the cell of the spreadsheet on a display screen of the computing device, the visual representation of the lambda function.

Rendering lambda functions in spreadsheet applications

In non-limiting examples of the present disclosure, systems, methods and devices for interacting with data in a productivity application are presented. A plurality of values associated with the productivity application may be analyzed to determine whether they include a value that can be added to a set comprising a plurality of values with a set data type upon which the productivity application can execute a plurality of set operations. An indication to add at least one of the analyzed values as a member of the set may be received. At least one of the analyzed values may be added as a member of the set. An indication to perform a set operation associated with the set may be received and performed, and the result of the performed set operation may be displayed on a productivity application user interface.

Identification of sets and manipulation of set data in productivity applications

The techniques described herein facilitate supporting remote micro-services from cloud-based analytics platforms as native functions in spreadsheet applications, e.g., Microsoft Excel&#xae;. 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.

Techniques for supporting remote micro-services as native functions in spreadsheet applications

Technologies are described herein for summary data autofill. A device executes an application program configured to receive data input. The application program may determine a portion of the data may be aggregated or conducive to being summarized. Upon the detection of a user input of additional data into a document having data contained therein, the application program may display a suggested complete summary of the data. An input may be received to accept the suggested complete summary, whereby the manner in which the suggested complete summary is displayed may be changed to indicate the acceptance of the suggested complete summary. A confidence level that the suggested complete summary is a correct summary of the data may be determined. The confidence level may be adjusted based on further input of data or additional data.

Summary data autofill

The techniques described herein facilitate proactively discovery of remote micro-services by spreadsheet applications, e.g., Microsoft Excel&#xae;. 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.

Credential-based proactive discovery of remote micro-services by spreadsheet applications

Examples discussed herein relate to creating and handling lambdas in spreadsheet application, e.g., Microsoft Excel&#xae;. As discussed herein, lambdas are user defined functions (UDFs) that are natively creatable and maintainable through the use of a lambda registry in the spreadsheet application. In an implementation, a method of handling lambdas in a spreadsheet application is disclosed. The method includes detecting that a cell of a spreadsheet is populated with an expression that defines a lambda function and registering the lambda function with a lambda registry corresponding to the spreadsheet. The registration includes recording a home cell that identifies a location of the cell of the spreadsheet where the lambda function is defined. The method further includes replacing the expression that defines the lambda function with a reference to the registered lambda function.

Creating and handling lambda functions in spreadsheet applications

In non-limiting examples of the present disclosure, systems, methods and devices for interacting with lambda functions are presented. An indication to store a lambda function may be received. The lambda function may comprise: executable information that is specific to a first spreadsheet application instance, executable information that is generic to spreadsheet application instances, and metadata describing the functionality of the lambda function. The lambda function may be stored, and an indication to apply the stored lambda function to data in a separate spreadsheet application instance may be received. The stored lambda function may be provided to the separate spreadsheet application instance for execution.

Distribution of lambda functions

Techniques to manage state information for a web service are described. An apparatus may comprise a processor circuit, and an application program for execution by the processor circuit to provide a set of operations to modify a state of a network resource provided by a network service. The application program may comprise a state manager component arranged to record state information for the network resource provided by the network service as state changes occur to the network resource during a first communication session, and store a resource identifier and associated state information for the network resource in a state database, the state information for use in automatically reproducing a state of the network resource during a second communication session. Other embodiments are described and claimed.

Growing community of inventors

Seattle, WA, United States of America

Christopher John Gross