Spreadsheet Formula Linking for Flexible Cell Range Changes

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing spreadsheet technologies fail to automatically adjust formulae and spatial relationships when cells are flexed, leading to formula errors and overlapping content issues.

Innovation Solution

The technology automatically links formulae and spatial relationships to flexing cells, adjusting formulae and positions to accommodate changes, ensuring error-free and coordinated visual presentation.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If spreadsheet cells are flexed to expand or contract ranges dynamically, then adaptability and productivity are improved, but formula errors and overlapping content occur due to lack of automatic adjustment

Engineering Contradiction:

Improveflexibility of cell rangesVSAvoidformula accuracy

Core Design Contradiction:

Adaptability or versatilityVSReliability

Solution Approach 1:

The patent implements dynamic linking between formulas and cell ranges, allowing formulas to automatically adjust their referenced ranges when cells are flexed. This dynamic adaptation maintains formula accuracy while enabling flexible range expansion and contraction, resolving the contradiction between adaptability and reliability.

Inventive Principle:

Principle #15Dynamics

Solution Approach 2:

The system establishes a feedback mechanism where cell flexing operations trigger automatic detection and adjustment of affected formulas. The formula linkage system monitors range changes and automatically updates formula references, ensuring formula accuracy is maintained throughout the flexing process while preserving range flexibility.

Inventive Principle:

Principle #23Feedback

2Measurement precision

If manual user intervention is required to correct formula errors after cell flexing, then measurement precision of formula references is maintained, but loss of time and productivity decrease

Engineering Contradiction:

Improveformula reference accuracyVSAvoidtime for manual correction

Core Design Contradiction:

Measurement precisionVSLoss of time

Solution Approach 1:

The patent establishes preliminary linkages between formulas and cell ranges before flexing operations occur. These pre-established linkages enable automatic detection and adjustment of formula references when flexing happens, eliminating the need for manual correction and preventing time loss while maintaining reference accuracy.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The formula linkage system enables formulas to self-adjust their references automatically when cell ranges are flexed. This self-service mechanism eliminates manual intervention, preventing both time loss and maintaining precision by having formulas automatically update their own references based on the flexing operation.

Inventive Principle:

Principle #25Self-service

3Device complexity

If cell positions are not automatically adjusted during flexing, then device complexity is reduced, but overlapping content errors occur

Engineering Contradiction:

Improvesimplicity of cell structureVSAvoidcontent positioning accuracy

Core Design Contradiction:

Device complexityVSReliability

Solution Approach 1:

The patent implements dynamic position adjustment mechanisms that activate during flexing operations. Cell positions are automatically adjusted in real-time based on flexing operations, preventing overlapping content errors while maintaining structural simplicity through automated coordination of position changes.

Inventive Principle:

Principle #15Dynamics

Data Source

PatentUS12511269B2Methods and systems for flexibly linking spreadsheet cell movements and formulas

Publication Date: 2025.12.30 ADAPTAM INC

AI summary

The disclosed technology creates a set of technologies that formulaically and/or positionally link cell(s) to spreadsheet functions or capabilities that flex the number of cells they instantiate. Thereby automatically altering the cell formula and/or the cell position reflecting those linked/connected flex range changes. Automatically ensuring no overlap of linked/connected cells and automatically adjusting linked/connected formulas for the referenced flex changes.