Invention Grant
- Patent Title: Formula and function generation and use in electronic spreadsheets
- Patent Title (中): 电子表格中的公式和函数生成和使用
-
Application No.: US14108782Application Date: 2013-12-17
-
Publication No.: US09256590B2Publication Date: 2016-02-09
- Inventor: Carlos Augusto Otero , John Campbell
- 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
- Agent Damon Rieth; Tom Wong; Micky Minhas
- Main IPC: G06F17/24
- IPC: G06F17/24 ; G06F3/0486 ; G06F17/21 ; G06F3/0484 ; G06F3/0488 ; G06F17/27

Abstract:
Spreadsheet formula and function creation and use with electronic computing devices are provided. When a user moves content (e.g., a spreadsheet cell) into a spreadsheet formula/function bar, a cell reference for the content may automatically be created and disposed in the formula/function bar, and if a user enters a math operation in a spreadsheet cell, corresponding operation sentence structure (syntax) may be automatically inserted into the formula/function bar. One or more formulas or functions may be automatically suggested as a user begins entering a formula/function. An always visible formula/function guide may be presented or displayed to provide helpful information on arguments/components of a formula/function, and help resources may be provided in a help resources interface with respect to application functionality and spreadsheet formulas/functions.
Public/Granted literature
- US20150169530A1 Formula and Function Generation and Use in Electronic Spreadsheets Public/Granted day:2015-06-18
Information query