Abstract: A display system comprising a steerable display having a monocular field of view of at least 1 degree, positioned within a scannable field of view of at least 20 degrees, the steerable display positioned for a user. In one embodiment, the steerable display is positioned for the user's fovea.

Abstract: Examples discussed herein relate to automatically creating lambda functions in spreadsheet applications, e.g., Microsoft Excel®. 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.

Abstract: 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.

Abstract: 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.

Abstract: Examples discussed herein relate to rending lambdas in spreadsheet application, e.g., Microsoft Excel®. 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.

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: 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.

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: Examples discussed herein relate to creating and handling lambdas in spreadsheet application, e.g., Microsoft Excel®. 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.

Abstract: 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.

Abstract: 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.

Abstract: Examples discussed herein relate to rending lambdas in spreadsheet application, e.g., Microsoft Excel®. 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.

Abstract: Examples discussed herein relate to automatically creating lambda functions in spreadsheet applications, e.g., Microsoft Excel®. 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.

Abstract: Examples discussed herein relate to creating and handling lambdas in spreadsheet application, e.g., Microsoft Excel®. 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.

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: Technologies are described herein for leveraging data searches in documents. The technologies disclosed herein may be utilized to search one or more data stores to retrieve metadata relating to data entered in a document. The metadata may be used to identify relationships between the data or to identify other aspects of the data. The metadata may also be used to organize the data into a format such as a pivot table or chart.

Abstract: Technologies are described herein for providing visualization suggestions. In order to provide a visualization suggestion, visualized data may be received. The visualized data may have profile data associated therewith and have at least one data connection to a data source associated therewith. Prior visualization information related to the profile data or the data connection may then be identified such that a visualization suggestion based on the identified prior visualization information can be determined. The visualization suggestion may then be returned to a client.

Abstract: 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.