Formula Bar Parameter Highlighting for Mobile Input
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Limited display devices, such as smartphones, make it cumbersome for users to interact with features like spreadsheet formulas due to their smaller screens, making it difficult to enter and edit formulas efficiently.
Innovation Solution
A formula bar that uses touch input and a Soft Input Panel (SIP) for formula input, where user input initiates a list of formulas, and each parameter is automatically highlighted for entry, allowing users to select and validate parameters with assistance from tooltips, facilitating efficient formula entry on limited display devices.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If formulas are entered and edited on limited display devices, then users can perform spreadsheet tasks on smartphones, but the small screen makes interaction cumbersome and difficult
Solution Approach 1:
The system automatically highlights the next parameter field before the user needs to enter data. When a user starts typing a formula, the system proactively displays the formula completion interface and pre-highlights which parameter should be filled next, eliminating the need for users to manually navigate through multiple parameter fields on the small screen.
Solution Approach 2:
A formula completion interface acts as an intermediary between the user's formula input and the parameter entry process. This intermediate layer provides a structured interface that guides users through formula parameters, displays available options, and automatically manages focus between parameters, making the interaction simpler on limited display devices.
2Extent of automation
If multiple parameters need to be entered for formulas, then complete formula functionality is achieved, but the complexity of navigating and entering each parameter increases
Solution Approach 1:
The system automatically determines and highlights the next parameter that needs to be filled based on the formula structure and current input state. This preliminary identification of the next target parameter eliminates the need for users to manually navigate through the parameter list, reducing the perceived complexity of multi-parameter entry.
Solution Approach 2:
The system provides continuous feedback by displaying which parameter is currently active (through highlighting) and what information is expected for that parameter. This feedback mechanism guides users through the complex parameter entry process by clearly indicating the current state and required input, making multi-parameter formulas more manageable.
Data Source
AI summary
A formula bar is used for receiving user input for entry/editing of formulas using touch input and/or a Soft Input Panel (SIP) designed for formula input. In response to a user initiating entry of a formula, a list of formulas is displayed based on the user's input. A formula may be selected and displayed within the formula bar with a parameter highlighted. The user may then enter the value for the parameter (e.g. a single value, a range, another formula, and the like) using touch input and/or SIP input. As the user enters the value for each parameter, the next parameter for the formula is automatically highlighted. The formula may be validated to determine if the parameters for the formula have been entered correctly. Tips may also be displayed in/near the display of the formula bar to provide assistance to the user entering the formula.