Compound Data Objects for Spreadsheet Cell View and Card View
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current spreadsheet applications are cumbersome due to their reliance on single-value cells, leading to complex and difficult-to-manage spreadsheets, with limited display and layout options that hinder readability.
Innovation Solution
The implementation of compound objects that store multiple values in a single cell, organized according to a schema with defined fields and properties, allowing for dynamic updating and customizable views, including cell and card views, to enhance data organization and display.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If multiple values are stored in separate cells across multiple rows and columns, then data can be organized in a traditional spreadsheet format, but the spreadsheet becomes extensive and cumbersome, increasing device complexity and reducing ease of operation
Solution Approach 1:
The patent combines multiple values into a single cell by introducing compound data objects that can store multiple values, fields, and properties within one cell. This merging approach reduces the number of cells needed and simplifies the overall spreadsheet structure while maintaining all necessary data organization capabilities.
Solution Approach 2:
The patent creates a universal data structure (compound object) that can serve multiple functions: storing multiple values, defining custom schemas, creating different views (cell view, card view), and enabling flexible data organization. This multi-functional approach eliminates the need for separate structures for different data organization needs.
2Loss of information
If the cell view displays the entirety of the value stored therein, then all data is visible, but sizing cells and modifying fonts to enhance readability becomes cumbersome
Solution Approach 1:
The patent introduces dynamic views (cell view and card view) that can adapt to different display needs. The cell view provides a condensed representation while the card view expands for detailed viewing. Users can switch between views without manually adjusting cell sizes or fonts, making readability enhancement straightforward and flexible.
Solution Approach 2:
The patent adds a new dimension to data display by introducing card views that present data in an expanded, detailed format separate from the compact cell view. This additional viewing dimension allows users to access complete information without compromising the compactness of the main spreadsheet layout.
3Stability of the object's composition
If a fixed schema is used for compound objects, then data organization is consistent, but the schema cannot adapt to changing data requirements, reducing adaptability
Solution Approach 1:
The patent makes the schema dynamic by allowing users to modify fields, add properties, and update the schema definition at any time. The system automatically adapts to schema changes while maintaining data integrity, enabling both consistency during use and flexibility during modification.
Data Source
AI summary
Aspects of the present disclosure further provide the ability to define, among other features, the layout of the cell view of the cell in which the compound object is stored as well as the card view of the compound object. Aspects of the present disclosure further provide the ability to modify properties associated with the values stored in a compound object, including, but not limited to properties of calculated values, value formatting, and permissions.