Spreadsheet Formula Bar Automation for Touch Interface Entry
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Users face difficulties in entering and manipulating spreadsheet formulas and functions, especially on touch-enabled devices where the unique syntax and limited display space hinder efficient data handling.
Innovation Solution
The system provides an automatic generation of formula and function syntax in a visible formula/function bar, suggesting completions as the user types, and offering an always visible guide and help resources to assist in creating and using spreadsheet functions.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If a soft keyboard is provided on touch-enabled devices for formula entry, then text input capability is improved, but display space is reduced making formula entry frustrating
Solution Approach 1:
The patent divides the formula entry interface into separate functional areas: a formula bar at the top for displaying and editing formulas, and the spreadsheet grid below for data entry. This segmentation allows the formula bar to remain always visible without obscuring the spreadsheet content, resolving the conflict between formula entry capability and display space.
Solution Approach 2:
The patent introduces an intermediary formula bar that acts as a mediator between the user and the spreadsheet data. This formula bar provides a dedicated space for formula entry and display, eliminating the need for pop-up keyboards that would otherwise block the view of the spreadsheet while formula entry is in progress.
2Manufacturing precision
If unique syntax structure is used for spreadsheet formulas, then computational precision is improved, but ease of operation deteriorates making formula entry difficult
Solution Approach 1:
The patent implements automatic syntax insertion that performs preliminary actions for the user. When a user begins entering a formula, the system automatically inserts the appropriate syntax structure (e.g., equals sign, function names, parentheses), so the user only needs to provide the specific data and parameters, reducing the cognitive load and difficulty of learning complex syntax.
Solution Approach 2:
The formula bar is designed to be self-service by automatically detecting user intent and providing appropriate syntax suggestions. As users type, the system analyzes the input and automatically completes formula syntax, inserts function names, and formats the expression correctly, allowing users to benefit from precise syntax without manually constructing it.
3Ease of operation
If formula syntax is automatically suggested, then ease of operation is improved, but device complexity increases
Solution Approach 1:
The patent implements a feedback mechanism where the formula bar continuously monitors user input and automatically responds by suggesting or inserting appropriate syntax. This feedback loop occurs in real-time as the user types, providing intelligent assistance without requiring complex external processing or multiple application layers, thus managing system complexity while improving ease of operation.
Data Source
Figure 1
Figure 2A
Figure 2B
AI summary
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.