System and method for rectangular region covering
View Patent ↗Systems and methods are provided for determining mutation regions for a spreadsheet. Mutation regions are iteratively assigned to a first region of cells in the spreadsheet. To assign a mutation region, a column is selected from the first region. A first row in the first region of cells is associated with the selected column that is not assigned to a mutation region and that is not included in a second region of the spreadsheet is determined. A largest region contained within the first region that does not overlap with the second region for which the cell in the selected column and the first row is in a designated position is determined. The largest region is assigned as a mutation region for the spreadsheet.
1. A computing system configured to determine mutation regions for a spreadsheet, the computing system comprising:
a network interface configured to:
receive a first user command comprising a modification to a first region of cells in the spreadsheet; and
receive a second user command comprising a modification to a second region of cells in the spreadsheet, the second region at least partially overlapping with the first region; and
a processor for iteratively assigning mutation regions to the first region of cells in the spreadsheet, the processor configured to:
select a column from the first region of cells in the spreadsheet;
determine a first row in the first region of cells associated with the selected column that is not assigned to a mutation region and that is not included in the second region;
determine a largest region contained within the first region that does not overlap with the second region for which the cell in the selected column and the first row is in a designated position; and
assign the determined largest region as a mutation region for the spreadsheet.
2. The computing system of claim 1 , wherein the first region of cells and the second region of cells are each rectangular regions.
3. The computing system of claim 1 , wherein the designated position is an upper-left position in the largest region.
4. The computing system of claim 1 , wherein the processor is further configured to assign mutation regions only to cells in the first region that are not included in the second region.
5. The computing system of claim 1 , wherein the modification of the first user command is selected from the group consisting of an add row command, a delete row command, an add column command, and a delete column command.
6. The computing system of claim 1 , wherein cells in the first region that are not included in the second region form a non-rectangular region of cells.
7. The computing system of claim 1 , wherein the processor is further configured to determine the first row associated with the selected column to be a lowest-numbered row of the selected column that is not already included in a mutation region and not included in the second region.
8. The computing system of claim 1 , wherein the processor is further configured to apply an operational transform to the second user command to produce a modified second user command.
9. The computing system of claim 8 , wherein the processor is further configured to apply the second user command to cells in the first region that do not overlap with the second region and apply the modified second user command to cells in the first region that overlap with second region.
10. The computing system of claim 1 , wherein the processor is further configured to remove at least one adjacent identical row from the spreadsheet prior to iteratively assigning mutation regions to the first region of cells.
11. A method for determining mutation regions for a spreadsheet, the method comprising:
receiving a first user command comprising a modification to a first region of cells in the spreadsheet;
receiving a second user command comprising a modification to a second region of cells in the spreadsheet, the second region at least partially overlapping with the first region;
iteratively assigning mutation regions to the first region of cells in the spreadsheet by:
selecting a column from the first region of cells in the spreadsheet;
determining a first row in the first region of cells associated with the selected column that is not assigned to a mutation region and that is not included in the second region;
determining a largest region contained within the first region that does not overlap with the second region for which the cell in the selected column and the first row is in a designated position; and
assigning the determined largest region as a mutation region for the spreadsheet.
12. The method of claim 11 , wherein the first region of cells and the second region of cells are each rectangular regions.
13. The method of claim 11 , wherein the designated position is an upper-left position in the largest region.
14. The method of claim 11 , further comprising assigning mutation regions only to cells in the first region that are not included in the second region.
15. The method of claim 11 , wherein the modification of the first user command is selected from the group consisting of an add row command, a delete row command, an add column command, and a delete column command.
16. The method of claim 11 , wherein cells in the first region that are not included in the second region form a non-rectangular region of cells.
17. The method of claim 11 , further comprising determining the first row associated with the selected column to be a lowest-numbered row of the selected column that is not already included in a mutation region and not included in the second region.
18. The method of claim 11 , further comprising an operational transform to the second user command to produce a modified second user command.
19. The method of claim 18 , further comprising applying the second user command to cells in the first region that do not overlap with the second region and apply the modified second user command to cells in the first region that overlap with second region.
20. The method of claim 11 , further comprising removing at least one adjacent identical row from the spreadsheet prior to iteratively assigning mutation regions to the first region of cells.