Spreadsheet Comparison UI Toggle for Source Formatting
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing spreadsheet comparison tools fail to clearly distinguish changes between versions due to conflicting colors used for change indication and source formatting, leading to increased cognitive load and difficulty in identifying actual changes.
Innovation Solution
A user interface that allows toggling of source formatting on and off, enabling users to focus on changes by hiding or showing source formatting, with a defined spectrum of colors to indicate different change types, thereby simplifying the identification of changes without confusing them with source formatting.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of information
If source formatting is displayed during spreadsheet comparison, then users can understand context and detail, but it becomes difficult to distinguish changes from formatting
Solution Approach 1:
The system dynamically adjusts the display state of source formatting based on user interaction. A toggle mechanism allows users to switch between viewing formatting (for context) and hiding formatting (for clear change detection). The formatting elements are not permanently removed but can be shown or hidden on demand, making the system adaptable to different user needs.
Solution Approach 2:
The display is segmented into two distinct modes: one showing source formatting and one showing only change indicators. This segmentation allows users to focus on specific aspects of the comparison by selecting the appropriate view, separating the concerns of context understanding and change detection into distinct display states.
2Measurement precision
If color spectrum is used to indicate changes, then different change types can be distinguished, but it conflicts with source formatting colors causing confusion
Solution Approach 1:
The system extracts and removes source formatting colors from the display when change detection is the priority. By taking out the conflicting formatting elements, the comparison colors become the sole visual indicators, eliminating confusion. Users can selectively remove formatting that interferes with interpreting change indicators.
Solution Approach 2:
Different parts of the spreadsheet are treated differently based on their function. Change indicators use a defined color spectrum for precise change type identification, while source formatting colors are selectively removed or hidden in areas where they would cause confusion. This local differentiation allows both functions to coexist without conflict.
3Difficulty of detecting and measuring
If source formatting is permanently removed, then change identification becomes easier, but users lose important contextual information
Solution Approach 1:
Instead of permanently removing source formatting, the system implements a dynamic toggle that allows users to switch between viewing formatting and hiding it. This dynamic approach preserves all information while allowing users to optimize the display for their current task, whether that's understanding context or identifying changes.
Solution Approach 2:
The system allows temporary discarding of source formatting display (when hiding it for clear change identification) with the ability to recover it (by toggling it back on). This reversible action ensures no information is permanently lost, and users can switch between viewing modes as needed.
Data Source
AI summary
A method and system for displaying the comparison output of two versions of a spreadsheet document such that the source formatting of the spreadsheet can be selectively suppressed to enhance the legibility of the comparison output.