Method and system for managing dynamic tables
First Claim
1. A method for modifying a dynamic table within an array while maintaining integrity of subsequent tables in the array, the method comprising:
- editing the dynamic table by selectively inserting at least one record to or deleting at least one record from the dynamic table, wherein the at least one record does not encompass an entire row of the array;
determining whether a subsequent table within the array includes an initially unaltered first portion and a second portion that is shifted within the array by the step of editing the dynamic table; and
shifting the first portion of the subsequent table within the array to align the first and second portions of the subsequent table.
2 Assignments
0 Petitions
Accused Products
Abstract
A method and system for modifying a dynamic table within an array includes inserting or deleting one or more records from the table while maintaining the integrity of subsequent tables within the array. The method first determines which subsequent tables at least partially overlap the boundary of the modified table, wherein the overlapping portions are shifted by the changes to the modified table. Next, the invention shifts the non-overlapping (unaltered) portions of the subsequent tables so that the two separate portions of the subsequent table are properly aligned and the integrity of the data within the subsequent table is maintained. In the case where data records are deleted from the modified table, the method first determines if a shift of the non-overlapping portions of the subsequent data would compromise any existing cell data within the array and then adjusts both the overlapping and the non-overlapping portions in order to reintegrate the entire subsequent table.
100 Citations
25 Claims
-
1. A method for modifying a dynamic table within an array while maintaining integrity of subsequent tables in the array, the method comprising:
-
editing the dynamic table by selectively inserting at least one record to or deleting at least one record from the dynamic table, wherein the at least one record does not encompass an entire row of the array; determining whether a subsequent table within the array includes an initially unaltered first portion and a second portion that is shifted within the array by the step of editing the dynamic table; and shifting the first portion of the subsequent table within the array to align the first and second portions of the subsequent table. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)
-
-
15. A system for modifying a dynamic table within an array while maintaining integrity of subsequent tables in the array, the system and the array stored in memory of a computer, the system comprising:
-
an input module for receiving edits to the dynamic table; a table edit module for selectively inserting at least one record to or deleting at least one record from the dynamic table in accordance with instructions received from the input module, wherein the at least one record does not encompass an entire row of the array; and a spreadsheet integration module for determining whether a subsequent table within the array includes an initially unaltered first portion and a second portion that is shifted within the array in response to an insertion or deletion of records in the dynamic table by the table edit module, the spreadsheet integration module further operating to shift the first portion of the subsequent table within the array to align the first and second portions of the subsequent table. - View Dependent Claims (16, 17, 18, 19, 20, 21, 22, 23, 24, 25)
-
Specification