Spreadsheet Formula View for Auditing and Search
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing spreadsheet applications do not provide an efficient way to view and manage formulas associated with a set of cells separately from the cell values, making auditing and error checking cumbersome.
Innovation Solution
A formula view is introduced that allows users to collect and display formulas associated with a set of cells in a separate view, enabling hierarchical organization, search options, editing capabilities, and navigation, while maintaining the primary cell view intact.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of information
If formulas are expanded in cells to show the entire formula, then formula visibility is improved, but cell dimension expansion makes the spreadsheet complex and difficult to navigate
Solution Approach 1:
The patent segments the formula display into a separate dedicated area (formula bar or formula view pane) distinct from the cell display area. This allows formulas to be viewed without expanding cell dimensions, resolving the contradiction between formula visibility and spreadsheet complexity.
Solution Approach 2:
The patent introduces an intermediary formula display interface (such as a formula bar or separate formula view) that mediates between the cell data and the user's need to view formulas. This intermediary layer provides formula visibility without requiring cell expansion, maintaining spreadsheet simplicity.
2Loss of information
If cell dimensions are expanded to accommodate long formulas, then formula completeness is improved, but navigation and editing efficiency deteriorates
Solution Approach 1:
The patent separates the formula display function from the cell display function by providing a dedicated formula view or formula bar. This segmentation allows complete formula viewing without expanding cell dimensions, thereby maintaining navigation and editing efficiency while ensuring formula completeness.
Solution Approach 2:
The patent moves formula display to another dimension (a separate pane, sidebar, or formula bar) rather than expanding within the cell's original dimension. This dimensional shift allows formula completeness without compromising the compactness and navigability of the spreadsheet grid.
3Ease of operation
If formulas are displayed alongside cell values in the same view, then formula accessibility is improved, but search and filter functionality deteriorates
Solution Approach 1:
The patent segments the display into separate areas for cell values and formulas, with the formula area providing dedicated accessibility features. This segmentation allows formulas to be easily accessed while maintaining robust search and filter capabilities in the cell value area, as each area can be optimized independently.
Solution Approach 2:
The patent creates a multi-functional formula display interface that serves multiple purposes: formula viewing, formula searching, formula filtering, and navigation. This universal interface improves formula accessibility while enhancing overall system versatility through integrated search and filter options specific to formulas.
Data Source
AI summary
In some embodiments, a spreadsheet application provides an option for collectively displaying the formulas associated with a set of cells in a separate view. In some embodiments, the view provides an option to search within the formulas (and/or other content) provided by the view. In some embodiments, a find and replace user interface of a spreadsheet application includes an option to search only in formulas.