Methods and systems for flexibly linking spreadsheet cell movements and formulas
AssigneeAdaptam Inc.
InventorsRobert E. Dvorak, Yuriy Garin, Alexey Verkhovskiy
Life of this patent
Estimating the term…
Abstract
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.
Claims28
A method for automatically adjusting input to a range or array prebuilt function in a spreadsheet cell, including:
- the range or array prebuilt function in a cell of the spreadsheet is linked to a range flexing function or flexing capability;
- applying the flexing function or flexing capability to underlying data and instantiating a plurality of returned cells;
- wherein the returned cells are in a range or array of cells;
- and
- responsive to a change
- in the underlying data and/or
- of a parameter of the flexing function or flexing capability
- that changes the number and/or location of returned cells,
- automatically changing the input to the range or array prebuilt function to match the changed number of returned cells.
A non-transitory computer readable memory, the memory impressed with computer instructions that, when executed on hardware, cause the hardware to carry out the actions of a method for automatically adjusting input to a range or array prebuilt function in a spreadsheet cell, including:
- the range or array prebuilt function in a cell of the spreadsheet is linked to a range flexing function or flexing capability;
- applying the flexing function or flexing capability to underlying data and instantiating a plurality of returned cells;
- wherein the returned cells are in a range or array of cells;
- and
- responsive to a change
- in the underlying data and/or
- of a parameter of the flexing function or flexing capability
- that changes the number of returned cells,
- automatically changing the input to the range or array prebuilt function to match the changed number of returned cells.
A system including processing hardware coupled to memory, the memory impressed with computer instructions that, when executed, cause the hardware to carry out the method for automatically adjusting input to a range or array prebuilt function in a spreadsheet cell, including:
- the range or array prebuilt function in a cell of the spreadsheet is linked to a range flexing function or flexing capability;
- applying the flexing function or flexing capability to underlying data and instantiating a plurality of returned cells;
- wherein the returned cells are in a range or array of cells;
- and
- responsive to a change
- in the underlying data and/or
- of a parameter of the flexing function or flexing capability
- that changes the number of returned cells,
- automatically changing the input to the range or array prebuilt function to match the changed number of returned cells.
Dependencies are inferred from the claim text.