公开(公告)号：WO2020005653A1

公开(公告)日：2020-01-02

申请号：PCT/US2019/037840

申请日：2019-06-19

Applicant: MICROSOFT TECHNOLOGY LICENSING, LLC

Inventor： GROSS, Christopher John ,  CAMPBELL, Johnny ,  BECKER, Andrew James ,  RUSSO, Claudio Vittorio

IPC: G06F9/448 ,  G06F17/24

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.

公开(公告)号：WO2018187129A1

公开(公告)日：2018-10-11

申请号：PCT/US2018/024985

申请日：2018-03-29

Applicant: MICROSOFT TECHNOLOGY LICENSING, LLC

Inventor： OTERO, Carlos Augusto ,  DERAZ, Ehab Sobhy ,  GROSS, Christopher John

IPC: G06F9/445 ,  G06F21/62

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.

公开(公告)号：WO2022125300A1

公开(公告)日：2022-06-16

申请号：PCT/US2021/060417

申请日：2021-11-23

Applicant: MICROSOFT TECHNOLOGY LICENSING, LLC [US]/[US]

Inventor： KESLIN, Michelle Elena ,  GROSS, Christopher John ,  MCDAID, Joseph ,  BECKER, Andrew James ,  WU, Su-Piao Bill

IPC: G06F40/18

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.

公开(公告)号：WO2020005603A1

公开(公告)日：2020-01-02

申请号：PCT/US2019/037412

申请日：2019-06-17

Applicant: MICROSOFT TECHNOLOGY LICENSING, LLC

Inventor： GROSS, Christopher John ,  CAMPBELL, Johnny ,  RUSSO, Claudio Vittorio

IPC: G06F9/448 ,  G06F17/24

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.

公开(公告)号：WO2016010794A1

公开(公告)日：2016-01-21

申请号：PCT/US2015/039627

申请日：2015-07-09

Applicant: MICROSOFT TECHNOLOGY LICENSING, LLC

Inventor： RAMPSON, Benjamin Edward ,  WELTON, Nickolas Dwayne ,  GROSS, Christopher John ,  HANUMARA, Poornima ,  CARLSON, Andrew Grey

IPC: G06F17/21 ,  G06F17/24

CPC classification number: G06F17/30864 ,  G06F17/211 ,  G06F17/246

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 translation: 这里描述了技术来提供可视化建议。 为了提供可视化建议，可以接收可视化数据。 可视化数据可以具有与其相关联的简档数据，并且具有与其相关联的数据源的至少一个数据连接。 然后可以识别与简档数据或数据连接相关的先前可视化信息，使得可以确定基于所识别的先前可视化信息的可视化建议。 然后，可视化建议可以返回给客户端。

公开(公告)号：WO2020005652A1

公开(公告)日：2020-01-02

申请号：PCT/US2019/037837

申请日：2019-06-19

Applicant: MICROSOFT TECHNOLOGY LICENSING, LLC

Inventor： GROSS, Christopher John ,  DUZAK, Jeffrey James ,  BECKER, Andrew James ,  RUSSO, Claudio Vittorio ,  GORDON, Andrew Donald

IPC: G06F9/448 ,  G06F17/24

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.

公开(公告)号：WO2020005649A1

公开(公告)日：2020-01-02

申请号：PCT/US2019/037833

申请日：2019-06-19

Applicant: MICROSOFT TECHNOLOGY LICENSING, LLC

Inventor： GROSS, Christopher John ,  CAMPBELL, Johnny ,  RUSSO, Claudio Vittorio

IPC: G06F9/448 ,  G06F17/24

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.

公开(公告)号：WO2016022511A1

公开(公告)日：2016-02-11

申请号：PCT/US2015/043519

申请日：2015-08-04

Applicant: MICROSOFT TECHNOLOGY LICENSING, LLC

Inventor： RAMPSON, Benjamin Edward ,  HANUMARA, Poornima ,  GROSS, Christopher John ,  GARG, Anupam ,  BROWN, Kevin Lane

IPC: G06F17/24

CPC classification number: G06F17/30997 ,  G06F17/246 ,  G06F17/30339 ,  G06F17/30722 ,  G06F17/30867

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 translation: 这里描述了用于利用文档中的数据搜索的技术。 本文公开的技术可以用于搜索一个或多个数据存储以检索与输入到文档中的数据有关的元数据。 元数据可用于识别数据之间的关系或识别数据的其他方面。 元数据还可以用于将数据组织成诸如枢轴表或图表的格式。

公开(公告)号：WO2016003777A1

公开(公告)日：2016-01-07

申请号：PCT/US2015/037846

申请日：2015-06-26

Applicant: MICROSOFT TECHNOLOGY LICENSING, LLC

Inventor： GROSS, Christopher John ,  RAMPSON, Benjamin Edward ,  HANUMARA, Poornima ,  GARG, Anupam

IPC: G06F17/24

CPC classification number: G06F17/243 ,  G06F17/245 ,  G06F17/246

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 translation: 本文描述了技术，用于摘要数据自动填充。 设备执行配置为接收数据输入的应用程序。 应用程序可以确定数据的一部分可以被聚合或有助于被总结。 当用户将附加数据的输入检测到包含其中的数据的文档中时，应用程序可以显示建议的数据的完整概要。 可以收到输入以接受建议的完整摘要，从而可以更改显示建议的完整摘要的方式，以表示接受建议的完整摘要。 可以确定建议的完整摘要是数据的正确摘要的置信水平。 可以基于数据或附加数据的进一步输入来调整置信水平。