Table Cell Expansion Rules for Conflict-Free Collaborative Merging
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing table editors face complications in real-time collaborative models due to uncontrolled cell expansion and merging, leading to conflicts and errors when multiple users make simultaneous edits, especially when cells expand over non-existent cells or collide with each other.
Innovation Solution
A system and method that processes changes to a table by identifying the state of cells, allowing or denying expansion based on adjacent cell states, and resolving conflicts by prioritizing edits to prevent error states, using rules for laying out cells and managing cell states to ensure proper display and merging.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If cells are allowed to expand freely to merge with adjacent cells, then the table can represent merged cell structures, but conflicts and errors occur when multiple users make simultaneous edits in collaborative environments
Solution Approach 1:
The system performs preliminary validation by checking the state of adjacent cells before allowing expansion. The controller examines whether target cells exist and are in appropriate states before permitting the expansion operation, preventing conflicts before they occur in collaborative editing scenarios
Solution Approach 2:
The system implements feedback mechanisms by continuously monitoring cell states and providing validation results. When an expansion is attempted, the system checks adjacent cell states and either permits or denies the expansion based on the current table configuration, ensuring consistency in collaborative environments
2Manufacturing precision
If expanding cells are explicitly marked as covering cells with direct dependencies, then cell coverage relationships are clearly defined, but any change to one cell affects all dependent cells causing complexity in collaborative models
Solution Approach 1:
The system segments the cell expansion mechanism into independent validation steps. Instead of creating direct dependencies between covering and covered cells, the system checks adjacent cell states independently and makes local decisions about whether to permit expansion, breaking the complex dependency chain into manageable segments
Solution Approach 2:
The system extracts the dependency relationship from the cell expansion model. Rather than requiring explicit covering/covered cell markings with direct dependencies, the system removes these dependencies by using state-based validation that operates independently on each expansion request
3Adaptability or versatility
If no limits are placed on cell expansion, then cells can freely merge to create flexible table layouts, but the model becomes complicated and difficult to control
Solution Approach 1:
The system applies local quality control by validating each expansion request based on the specific state of adjacent cells at the expansion boundary. Different rules are applied locally at each cell boundary depending on the adjacent cell's state, providing flexible yet controlled expansion behavior
Data Source
AI summary
Systems and methods are disclosed herein for resolving a change to a table. A processing circuitry receives, from a user in a collaborative document editing environment, the change to the table, wherein the change comprises an expansion of a first cell in the table. A first state of the first cell is identified, wherein the state is indicative of a number of columns and a number of rows over which the first cell spans, and at least one of the number of columns and the number of rows is greater than one. A second state of a second cell that is adjacent to the first cell is identified, and the processing circuitry selects whether to allow the expansion of the first cell based on the second state of the second cell.