Invention Grant
- Patent Title: Form-based formula editing in spreadsheets
-
Application No.: US16521397Application Date: 2019-07-24
-
Publication No.: US11080477B2Publication Date: 2021-08-03
- Inventor: Andrew William Stegmaier , Johnny Campbell , Joseph John McDaid , Christian Canton , Vikas Yadav , Sjoerd Roelof de Jong , Robert David Ohn Tinn , Marc Manuel Johannes Brockschmidt , Juliana Patricia Vicente Franco , Sneha Khullar
- 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: G06F40/18
- IPC: G06F40/18 ; G06F3/0481 ; G06F3/0484 ; G06F9/451 ; G06F40/205 ; G06F40/174 ; G06F40/274 ; G06F3/0482 ; G06N3/04 ; G06N3/08

Abstract:
Systems, methods, and software are disclosed herein for enhancing functions and formulas in spreadsheets. A computing apparatus detects a beginning of a formula in a cell of a spreadsheet. In response to detecting the beginning of the formula, the computing apparatus identifies a vector representation of a context of the cell and supplies the vector representation as input to one or more machine learning models. The one or more machine learning models produce output comprising one or more suggested functions for the formula and one or more suggested operands, which the computing apparatus presents in a user interface to the spreadsheet.
Public/Granted literature
- US20200302013A1 FORM-BASED FORMULA EDITING IN SPREADSHEETS Public/Granted day:2020-09-24
Information query