- Patent Title: Creating and handling lambda functions in spreadsheet applications
-
Application No.: US16024566Application Date: 2018-06-29
-
Publication No.: US10496740B1Publication Date: 2019-12-03
- Inventor: Christopher John Gross , Jeffrey James Duzak , Andrew James Becker , Claudio Vittorio Russo , Andrew Donald Gordon
- Applicant: Microsoft Technology Licensing, LLC
- Applicant Address: US WA Redmond
- Assignee: Microsoft Technology Licensing, LLC
- Current Assignee: Microsoft Technology Licensing, LLC
- Current Assignee Address: US WA Redmond
- Main IPC: G06F17/24
- IPC: G06F17/24 ; G06F8/30 ; G06F17/27 ; G06F17/17 ; G06F17/21

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.
Public/Granted literature
- US10726201B1 Creating and handling lambda functions in spreadsheet applications Public/Granted day:2020-07-28
Information query