Drag-and-Drop Formula Insertion via Status Bar
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Users find it difficult to enter and use custom calculations in productivity applications, especially on tablet devices due to the complexity of learning function names and syntax, and the challenges of typing on virtual keyboards.
Innovation Solution
A user interface that displays a status bar with predetermined calculations, allowing users to select and drag these calculations to a drop location, where the system automatically generates a corresponding formula, simplifying the process of inserting custom calculations.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If users manually enter formulas by typing on virtual keyboards, then formulas can be inserted into the application, but the operation becomes difficult and time-consuming due to keyboard switching and syntax learning requirements
Solution Approach 1:
The patent displays visual representations of formulas directly in the user interface without requiring users to type them. Users can see the formula structure and select it by clicking or tapping, which automatically inserts the formula. This copying approach eliminates the need for manual typing on virtual keyboards while preserving the ability to use standard keyboard input for users who prefer it.
Solution Approach 2:
The patent introduces an intermediary visual display layer between the user and the formula insertion process. Instead of direct typing, users interact with visual formula representations that are rendered in the interface. This intermediary layer translates visual selection into actual formula insertion, bridging the gap between user intent and system action without requiring users to learn syntax or switch keyboard layouts.
2Measurement precision
If users learn function names and syntax to enter formulas, then accurate calculations can be performed, but the learning curve increases and operation becomes more difficult
Solution Approach 1:
The patent displays the actual formula syntax visually in the user interface, allowing users to see exactly what function names and parameters are required. Users can select these visual representations directly, which automatically copies the correct syntax into the application. This eliminates the need for users to memorize or learn the syntax while ensuring accurate formula insertion.
Solution Approach 2:
The patent allows users to select visual formula representations that automatically insert the correct syntax and structure. The system provides the complete, accurate formula formulation without requiring users to manually construct it using correct syntax. Users simply need to identify what calculation they want through visual cues, and the system handles the technical syntax requirements automatically.
3Ease of operation
If predefined calculations are displayed in the status bar, then users can easily select and insert formulas through drag and drop, but the interface complexity increases
Solution Approach 1:
The patent uses the existing status bar component, which is a standard element in spreadsheet applications, to display visual representations of formulas. The status bar already serves the function of showing calculation results, and the patent extends this existing element to also provide formula insertion capability. This multi-functional use of the status bar avoids adding new interface elements while enhancing usability.
Solution Approach 2:
The patent combines the formula display and formula insertion functions into a single visual representation in the status bar. Instead of having separate elements for showing calculations and for inserting formulas, the patent merges these functions so that the same visual element serves both purposes. Users interact with the same displayed formula to both view it and insert it, reducing the number of interface elements needed.
Data Source
Figure 1
Figure 2
Figure 3
AI summary
Inserting a formula at a location on a content surface in a user interface is provided. A user interface showing a status bar which includes one or more predetermined calculations may be displayed on a computer. The computer may receive a selection of a predetermined calculation from the status bar in the user interface. The selected predetermined calculation may then be dragged from the status bar and inserted at a drop location on the content surface in the user interface. The computer may then automatically generate a formula corresponding to the selected predetermined calculation in the user interface.