Spreadsheet Stack Positioning for Data Overlap Management
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing electronic spreadsheet systems lack efficient methods to manage data display, often requiring overwriting or adding rows and columns, which can lead to incomplete data representation and user interface clutter.
Innovation Solution
The system allows items in an electronic spreadsheet to be associated with positions in a stack, enabling overlap without complete overwrite, allowing for dynamic reordering and expansion based on user requests, using a stack position priority system to manage data visibility.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Area of stationary object
If additional rows and columns are added to provide needed display space, then the display area is increased, but the device complexity and data management difficulty increase
Solution Approach 1:
The patent implements a stack-based nesting system where multiple items (tables, charts, other spreadsheet elements) are nested within a hierarchical stack structure. Each item can be positioned at different stack levels, allowing items to overlap spatially while maintaining distinct logical layers. This enables efficient use of display area without requiring additional rows and columns, as items can be layered on top of each other rather than requiring separate spatial allocation.
2Area of stationary object
If neighboring portions are overwritten to provide needed space, then display space is created, but data loss occurs
Solution Approach 1:
The patent introduces a third dimension (stack level) to the traditional two-dimensional spreadsheet layout. Instead of expanding or overwriting in the horizontal and vertical dimensions only, items can be positioned at different stack levels (z-axis), allowing multiple items to occupy the same x-y coordinates without conflict. This dimensional addition eliminates the need to overwrite neighboring portions while still providing adequate display space through vertical layering.
3Loss of information
If items are allowed to overlap without complete overwrite, then data visibility is improved, but the rendering complexity increases
Solution Approach 1:
The patent segments the spreadsheet into discrete items, each with an associated stack level. The rendering system processes items in a standardized sequence based on their stack levels, rendering higher-level items after lower-level items. This segmentation approach simplifies the rendering complexity by providing a clear, deterministic rendering order, eliminating the need for complex real-time collision detection and resolution algorithms that would otherwise be required for arbitrary item overlaps.
Data Source
AI summary
In one embodiment, a method comprises: providing an electronic spreadsheet having a plurality of cells arranged in an array having a plurality of rows and a plurality of columns; receiving information defining a plurality of items, each of the plurality of items representing a respective set of data usable in populating at least a portion of the plurality of cells of the electronic spreadsheet, at least one of the plurality of items including a table having a plurality of rows and a plurality of columns; associating each of the plurality of items with a respective location in the electronic spreadsheet; associating each of the plurality of items with a respective position in a stack, each of the plurality of items being able to be associated with any position in the stack; and rendering the electronic spreadsheet in accordance with the information defining the plurality of items, the respective location associated with each item and the respective stack position associated with each item.